VB.NET -Web App: Problems Updating Datagrid

[tanya2001]

hi all..
I am trying to update my datagrid in my webform...but its not getting updated..though in the database it removing the <null> and inserting a blank field....its not taking the input which m typing...can sombody plz help me out in this..i need help urgently
I am posting the code in vb.net for the webform as well as html

Protected Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand
        Dim Stocksent1 As TextBox = CType(e.Item.FindControl("TextBox2"), TextBox)
        Dim Signed1 As TextBox = CType(e.Item.FindControl("SignedTextBox"), TextBox)
        Dim Items1 As String = DataGrid1.DataKeys(e.Item.ItemIndex).ToString()
        Dim myConnection As New SqlConnection("Server=SERVER;uid=sa;pwd=;Database=Central")
        myConnection.Open()
 
        myCommand1 = New SqlCommand("Update Table3 set Stocksent='" & Stocksent1.Text & "', Signedby='" & Signed1.Text & "' , Flag=0, Sentdate=getdate() where Items='" & Items1 & "' ", myConnection)
        'myCommand1.Parameters.Add("@Items", SqlDbType.NVarChar).Value = Items
        'myCommand1.Parameters.Add("@Stocksent1", SqlDbType.NVarChar).Value = Stocksent1.Text
        'myCommand1.Parameters.Add("@Signedby1", SqlDbType.NVarChar).Value = Signed1.Text
        ra = myCommand1.ExecuteNonQuery()
        myConnection.Close()
        Response.Write("Records Updated")
        DataGrid1.EditItemIndex = -1
        DataGrid1.DataBind()
        DataGrid1.Columns(8).Visible = False
        DataGrid1.Columns(9).Visible = False
        DataGrid1.Columns(10).Visible = False
        DataGrid1.Columns(11).Visible = False
        DataGrid1.Columns(12).Visible = False
 
    End Sub
 

HTML CODE

<form id="Form1" method="post" runat="server">
            <asp:datagrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 64px; POSITION: absolute; TOP: 296px"
                runat="server" AutoGenerateColumns="False" DataKeyField="Items" Width="848px" ForeColor="DimGray"
                BackColor="Wheat" BorderColor="#660033" Height="72px">
                <HeaderStyle Font-Bold="True" ForeColor="Chocolate" BackColor="LightGray"></HeaderStyle>
                <Columns>
                    <asp:BoundColumn DataField="Lognumm" ReadOnly="True" HeaderText="Lognumm"></asp:BoundColumn>
                    <asp:BoundColumn DataField="Requestdate" ReadOnly="True" HeaderText="Requestdate"></asp:BoundColumn>
                    <asp:BoundColumn DataField="Hospital" ReadOnly="True" HeaderText="Hospital"></asp:BoundColumn>
                    <asp:BoundColumn DataField="Items" ReadOnly="True" HeaderText="Items"></asp:BoundColumn>
                    <asp:BoundColumn DataField="Currentstock" ReadOnly="True" HeaderText="Currentstock"></asp:BoundColumn>
                    <asp:BoundColumn DataField="Stockrequest" ReadOnly="True" HeaderText="Stockrequest"></asp:BoundColumn>
                    <asp:BoundColumn DataField="Priority" ReadOnly="True" HeaderText="Priority"></asp:BoundColumn>
                    <asp:BoundColumn DataField="Comment" ReadOnly="True" HeaderText="Comment"></asp:BoundColumn>
                    <asp:TemplateColumn Visible="False" HeaderText="Stocksent">
                        <ItemTemplate>
                            <asp:Label id=Label2 runat="server" Text='<%# DataBinder.Eval (Container.DataItem , "Stocksent") %>'>
                            </asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox id=TextBox2 runat="server" Text='<%# DataBinder.Eval(Container.DataItem , "Stocksent") %>'>
                            </asp:TextBox>
                            <asp:RequiredFieldValidator id="RequiredFieldValidator1" runat="server" ErrorMessage="Enter value" ControlToValidate="TextBox2"></asp:RequiredFieldValidator>
                        </EditItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn Visible="False" HeaderText="Signedby">
                        <ItemTemplate>
                            <asp:Label id=Label1 runat="server" NAME="Label1" Text='<%# DataBinder.Eval(Container, "DataItem.Signedby") %>'>
                            </asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox id=SignedTextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Signedby") %>'>
                            </asp:TextBox>
                            <asp:RequiredFieldValidator id="RequiredFieldValidator2" runat="server" Width="128px" ErrorMessage="Enter Value"
                                ControlToValidate="SignedTextBox"></asp:RequiredFieldValidator>
                        </EditItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn Visible="False" HeaderText="Takenby">
                        <ItemTemplate>
                            <asp:Label id="Label3" runat="server"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox id="TextBox1" runat="server"></asp:TextBox>
                            <asp:RequiredFieldValidator id="RequiredFieldValidator3" runat="server" ErrorMessage="Enter Value" ControlToValidate="TextBox1"></asp:RequiredFieldValidator>
                        </EditItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn Visible="False" HeaderText="Comments">
                        <ItemTemplate>
                            <asp:Label runat="server"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox runat="server"></asp:TextBox>
                        </EditItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn HeaderText="Edit">
                        <ItemTemplate>
                            <asp:LinkButton runat="server" CausesValidation="false" CommandName="Edit" Text="Edit" ID="Linkbutton1"></asp:LinkButton>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:LinkButton runat="server" CommandName="Update" Text="Update" ID="Linkbutton2"></asp:LinkButton>
                            <asp:LinkButton runat="server" CausesValidation="false" CommandName="Cancel" Text="Cancel" ID="Linkbutton3"></asp:LinkButton>
                        </EditItemTemplate>
                    </asp:TemplateColumn>
                </Columns>
            </asp:datagrid>

[Frinavale]

hi all..
I am trying to update my datagrid in my webform...but its not getting updated..though in the database it removing the <null> and inserting a blank field....its not taking the input which m typing...can sombody plz help me out in this..i need help urgently
I am posting the code in vb.net for the webform as well as html...

Hi Tanya,
In the future could you please post your code within [code] tags.
(For example you'd type [code=vbnet]'...paste code here...[ /code] if you wanted to post vb.net code)
This just makes it easier for everyone.

Are you by any chance binding your DataGrid to its DataSource during PageLoad?

[tanya2001]

Hi Tanya,
In the future could you please post your code within [code] tags.
(For example you'd type [code=vbnet]'...paste code here...[ /code] if you wanted to post vb.net code)
This just makes it easier for everyone.

Are you by any chance binding your DataGrid to its DataSource during PageLoad?

yes i am do u want me to give u the code for page load event as well?

[mzmishra]

I think this part is missing in your code
DataGrid.DataSo urce

[tanya2001]

I think this part is missing in your code
DataGrid.DataSo urce

where shud this part be i mean Datagrid.Dataso urce????

[Frinavale]

where shud this part be i mean Datagrid.Dataso urce????

Could you please post your code for the PageLoad method?

[tanya2001]

Could you please post your code for the PageLoad method?

 
 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim cn As New SqlConnection("Server=SERVER;uid=sa;pwd=;Database=Central")
        Dim da As New SqlDataAdapter("select * from Table3 where Lognumm= '" & Request.QueryString("ID") & "' and Flag=1", cn)
        Dim dt As New DataTable
        da.Fill(dt)
        da.Dispose()
        cn.Dispose()
        Me.DataGrid1.DataSource = dt
        Me.DataGrid1.DataBind()
    End Sub
 
 

[Frinavale]

 
 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim cn As New SqlConnection("Server=SERVER;uid=sa;pwd=;Database=Central")
        Dim da As New SqlDataAdapter("select * from Table3 where Lognumm= '" & Request.QueryString("ID") & "' and Flag=1", cn)
        Dim dt As New DataTable
        da.Fill(dt)
        da.Dispose()
        cn.Dispose()
        Me.DataGrid1.DataSource = dt
        Me.DataGrid1.DataBind()
    End Sub
 
 

Try changing your code so that you only set and bind the DataSource to your DataGrid when it is not isPostBack

Eg

 
 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
 
 
      If IsPostBack = False Then
 
        Dim cn As New SqlConnection("Server=SERVER;uid=sa;pwd=;Database=Central")
        Dim da As New SqlDataAdapter("select * from Table3 where Lognumm= '" & Request.QueryString("ID") & "' and Flag=1", cn)
        Dim dt As New DataTable
        da.Fill(dt)
        da.Dispose()
        cn.Dispose()
        Me.DataGrid1.DataSource = dt
        Me.DataGrid1.DataBind()
 
        End If
    End Sub
 

The reason for this is during your page cycle, when you're in the PageLoad, you can set your control's properties Before ASP.NET sets them. If you do this, then any properties that the control gathered from the user is lost....so if your user is editing an empty row and adding new values to it...and then you reset the data source for your DataGrid in PageLoad, you will lose the data that the user supplied while editing.

(PS. Please take a look at my not on using the [code] tags again. It should be code=vbnet not code : Vb.Net :) Thanks)

[tanya2001]

lol....hi
well i did write it the way u said as shown below but when i click the edit link its just showing me a blank page the datagrid disappears...th e entire code for the page is shown below( i hope i m right this time :-))

 
Imports System.Data.SqlClient
Public Class trial
    Inherits System.Web.UI.Page
    Dim myCommand1 As New SqlCommand
    Protected WithEvents LinkButton4 As System.Web.UI.WebControls.LinkButton
    Protected WithEvents LinkButton5 As System.Web.UI.WebControls.LinkButton
    Dim ra As Integer
 
#Region " Web Form Designer Generated Code "
 
    'This call is required by the Web Form Designer.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
 
    End Sub
    Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
 
    'NOTE: The following placeholder declaration is required by the Web Form Designer.
    'Do not delete or move it.
    Private designerPlaceholderDeclaration As System.Object
 
    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: This method call is required by the Web Form Designer
        'Do not modify it using the code editor.
        InitializeComponent()
    End Sub
 
#End Region
 
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        If IsPostBack = False Then
 
 
        Dim cn As New SqlConnection("Server=SERVER;uid=sa;pwd=;Database=Central")
        Dim da As New SqlDataAdapter("select * from Table3 where Lognumm= '" & Request.QueryString("ID") & "' and Flag=1", cn)
        Dim dt As New DataTable
        da.Fill(dt)
        da.Dispose()
        cn.Dispose()
        Me.DataGrid1.DataSource = dt
        Me.DataGrid1.DataBind()
               end if
    End Sub
 
    Protected Sub DataGrid1_EditCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.EditCommand
        DataGrid1.Columns(8).Visible = True
        DataGrid1.Columns(9).Visible = True
        DataGrid1.Columns(10).Visible = True
        DataGrid1.Columns(11).Visible = True
 
        DataGrid1.EditItemIndex = e.Item.ItemIndex
        DataGrid1.DataBind()
 
    End Sub
    Protected Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand
 
        Dim Stocksent1 As TextBox = CType(e.Item.FindControl("TextBox2"), TextBox)
        Dim Signed1 As TextBox = CType(e.Item.FindControl("SignedTextBox"), TextBox)
        Dim Items1 As String = DataGrid1.DataKeys(e.Item.ItemIndex).ToString()
        Dim myConnection As New SqlConnection("Server=SERVER;uid=sa;pwd=;Database=Central")
        myConnection.Open()
 
        myCommand1 = New SqlCommand("Update Table3 set Stocksent='" & Stocksent1.Text & "', Signedby='" & Signed1.Text & "' , Flag=0, Sentdate=getdate() where Items='" & Items1 & "' ", myConnection)
        'myCommand1.Parameters.Add("@Items", SqlDbType.NVarChar).Value = Items
        'myCommand1.Parameters.Add("@Stocksent1", SqlDbType.NVarChar).Value = Stocksent1.Text
        'myCommand1.Parameters.Add("@Signedby1", SqlDbType.NVarChar).Value = Signed1.Text
        ra = myCommand1.ExecuteNonQuery()
        myConnection.Close()
        Response.Write("Records Updated")
        DataGrid1.EditItemIndex = -1
        DataGrid1.DataBind()
        DataGrid1.Columns(8).Visible = False
        DataGrid1.Columns(9).Visible = False
        DataGrid1.Columns(10).Visible = False
        DataGrid1.Columns(11).Visible = False
        DataGrid1.Columns(12).Visible = False
 
    End Sub
    Private Sub LinkButton5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton5.Click
 
        Response.Redirect("http://localhost/WebApplication3\Warehouse1.aspx")
 
    End Sub
    Private Sub LinkButton4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton4.Click
 
        Response.Redirect("http://localhost/WebApplication3\WebForm6.aspx")
 
    End Sub
 
End Class
 

[tanya2001]

Try changing your code so that you only set and bind the DataSource to your DataGrid when it is not isPostBack

Eg

 
 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
 
 
      If IsPostBack = False Then
 
        Dim cn As New SqlConnection("Server=SERVER;uid=sa;pwd=;Database=Central")
        Dim da As New SqlDataAdapter("select * from Table3 where Lognumm= '" & Request.QueryString("ID") & "' and Flag=1", cn)
        Dim dt As New DataTable
        da.Fill(dt)
        da.Dispose()
        cn.Dispose()
        Me.DataGrid1.DataSource = dt
        Me.DataGrid1.DataBind()
 
        End If
    End Sub
 

The reason for this is during your page cycle, when you're in the PageLoad, you can set your control's properties Before ASP.NET sets them. If you do this, then any properties that the control gathered from the user is lost....so if your user is editing an empty row and adding new values to it...and then you reset the data source for your DataGrid in PageLoad, you will lose the data that the user supplied while editing.

(PS. Please take a look at my not on using the [code] tags again. It should be code=vbnet not code : Vb.Net :) Thanks)

hi i did it but its like showing me a blank page wehn i click edit...y is it so???