Category Archives: VB.NET

One page PDF don’t open in IE8

Posted on March 4, 2011 by Ahmed

Very weired !!! I can open 2 or more PDF pages in IE8, but one page or less IE8 can’t and gives me this error message: The file is damaged and could not be repaired. By the way, Chrome can. … Continue reading →

Posted in ASP.NET, Error Message, Programming, VB.NET | Tagged , , , , | Leave a comment

Copy Cell in GridView

Posted on January 25, 2011 by Ahmed

In GridView add this column:  <asp:CommandField ButtonType=”Button” SelectText=”” ShowSelectButton=”True” /> [\sourcecode] Then in code-behind: Protected Sub GridViewHandLinks_RowCommand(ByVal sender As Object, ByVal e As GridViewCommandEventArgs)   If e.CommandName.Equals(“Select“) Then   Dim index As Integer = Convert.ToInt32(e.CommandArgument)   Dim row As GridViewRow … Continue reading →

Posted in ASP.NET, Programming, VB.NET | Tagged , , | Leave a comment

Refresh TreeView after insert/update/delete ?

Posted on December 27, 2010 by Ahmed

Wrong solution : DataBind() BEFORE close()         TreeView1.DataBind()         con.Close() Right solution: In btnListtAdd_Click :   To get the ID         Dim lastID As String = “Select @@Identity”         Dim getID As Integer         ‘this is to get last ID … Continue reading →

Posted in Databases, Programming, SQL-Server, VB.NET | Tagged , , , , , | Leave a comment

Read PDF from a Database and Open it into a Frame

Posted on December 27, 2010 by Ahmed

IHttpHandler is aowsome. You read your file in the buffer and just send it to src as if it is a named file, so no need to read and save a temporary file in client’s PC. iframePDF1.Attributes.Add(“src”, “ShowPDF.ashx?pID=” & Request.QueryString(“pID”)) … Continue reading →

Posted in Databases, Programming, SQL-Server, VB.NET | Tagged , , , , , | Leave a comment

Error msg: No mapping exists from object type System.Data.SqlClient.SqlParameter to a known managed provider native type.

Posted on December 19, 2010 by Ahmed

        Dim pID As New SqlParameter(“@ID”, SqlDbType.Int)         pID.Value = TextBoxParentID.Text         cmd.Parameters.AddWithValue(“@ID”, pID) I changed it to:         Dim pID As New SqlParameter(“@ID”, SqlDbType.Int)         pID.Value = TextBoxParentID.Text         cmd.Parameters.Add(pID) and it works also this works:         Dim pID … Continue reading →

Posted in Databases, Programming, SQL-Server, VB.NET | Tagged , , , , , | 3 Comments

ExecuteReader vs ExecuteNonQuery vs ExecuteScalar

Posted on December 19, 2010 by Ahmed

ExecuteReader() For SELECT statement ExecuteNonQuery() For INSERT , UPDATE and DELETE Not for SELECT statement. ExecuteScalar() For images   Ahmed.

Posted in Comparison, Databases, Programming, SQL-Server, VB.NET | Tagged , , , , , , , , , | Leave a comment

Increasing the Maximum Upload Size

Posted on December 17, 2010 by Ahmed

The 4MB default is set in machine.config, but you can override it in your web.config. For instance, to expand the upload limit to 20MB, you’d do this: <system.web>   <httpRuntime executionTimeout=”240″ maxRequestLength=”20480″ /> </system.web>

Posted in Databases, Programming, SQL-Server, VB.NET | Tagged , , , , | Leave a comment

How to Save and Display a PDf/Word file ?

Posted on December 17, 2010 by Ahmed

For displaying, it will save the pdf/word to temp folder then open it and after closing will delete the temp file.

Posted in Databases, Programming, SQL-Server, VB.NET | Tagged , , , , | Leave a comment

Sending data to another page

Posted on December 15, 2010 by Ahmed

There are many ways to send data to another page. QueryString , Context or Session. The easiest and oldest way is QueryString. In first page: Link second page and variable e.g. NavigateUrl = “~/SecondPage.aspx?variable_to_be_send=1” In second page: Protected Sub Page_Load(ByVal … Continue reading →

Posted in Programming, VB.NET | Tagged , | Leave a comment

Error 7 It is an error to use a section registered as allowDefinition=’MachineToApplication’ beyond application level.

Posted on December 15, 2010 by Ahmed

PROBLEM: Error 7 It is an error to use a section registered as allowDefinition=’MachineToApplication’ beyond application level.  This error can be caused by a virtual directory not being configured as an application in IIS. D:\lawsDB\laws\news\web.config 83  SOLUTION: There was two web.config files, one in … Continue reading →

Posted in Programming, VB.NET | Tagged , , | Leave a comment