Originally posted by Frinavale
well d first 2 field in this r getting updated but then wen i have added 2 more fields in this its not updating...y is it so?
m giving u d code below
[code=vbnet]
Dim Stocksent1 As TextBox = CType(e.Item.Fi ndControl("Text Box2"), TextBox)
Dim Signed1 As TextBox = CType(e.Item.Fi ndControl("Sign edTextBox"), TextBox)
Dim Takenby1 As TextBox = CType(e.Item.Fi ndControl("Text Box1"), TextBox)
Dim Comments1 As TextBox = CType(e.Item.Fi ndControl("Text Box4"), TextBox)
Dim Items1 As String = DataGrid1.DataK eys(e.Item.Item Index).ToString ()
Dim myConnection As New SqlConnection(" Server=SERVER;u id=sa;pwd=;Data base=Central")
myConnection.Op en()
myCommand1 = New SqlCommand("Upd ate Table3 set Stocksent='" & Stocksent1.Text & "', Signedby='" & Signed1.Text & "',Takenby= '" & Takenby1.Text & "', Comments='" & Comments1.Text & "', Flag=0, Sentdate=getdat e() where Items='" & Items1 & "' ", myConnection)
ra = myCommand1.Exec uteNonQuery()
myConnection.Cl ose()
Response.Write( "Records Updated")
DataGrid1.EditI temIndex = -1
DataGrid1.DataB ind()
DataGrid1.Colum ns(8).Visible = False
DataGrid1.Colum ns(9).Visible = False
DataGrid1.Colum ns(10).Visible = False
DataGrid1.Colum ns(11).Visible = False
DataGrid1.Colum ns(12).Visible = False
[/code]
[code=html]
<asp:datagrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 64px; POSITION: absolute; TOP: 296px"
runat="server" Height="72px" BorderColor="#6 60033" BackColor="Whea t" ForeColor="DimG ray" Width="848px"
DataKeyField="I tems" AutoGenerateCol umns="False">
<HeaderStyle Font-Bold="True" ForeColor="Choc olate" BackColor="Ligh tGray"></HeaderStyle>
<Columns>
<asp:BoundColum n DataField="Logn umm" ReadOnly="True" HeaderText="Log numm"></asp:BoundColumn >
<asp:BoundColum n DataField="Requ estdate" ReadOnly="True" HeaderText="Req uestdate"></asp:BoundColumn >
<asp:BoundColum n DataField="Hosp ital" ReadOnly="True" HeaderText="Hos pital"></asp:BoundColumn >
<asp:BoundColum n DataField="Item s" ReadOnly="True" HeaderText="Ite ms"></asp:BoundColumn >
<asp:BoundColum n DataField="Curr entstock" ReadOnly="True" HeaderText="Cur rentstock"></asp:BoundColumn >
<asp:BoundColum n DataField="Stoc krequest" ReadOnly="True" HeaderText="Sto ckrequest"></asp:BoundColumn >
<asp:BoundColum n DataField="Prio rity" ReadOnly="True" HeaderText="Pri ority"></asp:BoundColumn >
<asp:BoundColum n DataField="Comm ent" ReadOnly="True" HeaderText="Com ment"></asp:BoundColumn >
<asp:TemplateCo lumn HeaderText="Sto cksent">
<ItemTemplate >
<asp:Label id=Label2 runat="server" Text='<%# DataBinder.Eval (Container.Data Item , "Stocksent" ) %>'>
</asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox id=TextBox2 runat="server" Text='<%# DataBinder.Eval (Container.Data Item , "Stocksent" ) %>'>
</asp:TextBox>
<asp:RequiredFi eldValidator id="RequiredFie ldValidator1" runat="server" ControlToValida te="TextBox2" ErrorMessage="E nter value"></asp:RequiredFie ldValidator>
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Sig nedby">
<ItemTemplate >
<asp:Label id=Label1 runat="server" NAME="Label1" Text='<%# DataBinder.Eval (Container, "DataItem.Signe dby") %>'>
</asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox id=SignedTextBo x runat="server" Text='<%# DataBinder.Eval (Container, "DataItem.Signe dby") %>'>
</asp:TextBox>
<asp:RequiredFi eldValidator id="RequiredFie ldValidator2" runat="server" Width="128px" ErrorMessage="E nter Value"
ControlToValida te="SignedTextB ox"></asp:RequiredFie ldValidator>
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Tak enby">
<ItemTemplate >
<asp:Label id="Label3" runat="server" Text='<%# DataBinder.Eval (Container, "DataItem.Taken by") %>'>
</asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox id="TextBox1" runat="server" Text='<%# DataBinder.Eval (Container, "DataItem.Taken by") %>'>
</asp:TextBox>
<asp:RequiredFi eldValidator id="RequiredFie ldValidator3" runat="server" ErrorMessage="E nter Value" ControlToValida te="TextBox1"> </asp:RequiredFie ldValidator>
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Com ments">
<ItemTemplate >
<asp:Label id="Label4" runat="server" Text='<%# DataBinder.Eval (Container, "DataItem.Comme nts") %>'>
</asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox id="TextBox3" runat="server" Text='<%# DataBinder.Eval (Container, "DataItem.Comme nts") %>'>
</asp:TextBox>
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Edi t">
<ItemTemplate >
<asp:LinkButt on runat="server" CausesValidatio n="false" CommandName="Ed it" Text="Edit" ID="Linkbutton1 "></asp:LinkButton>
</ItemTemplate>
<EditItemTempla te>
<asp:LinkButt on runat="server" CommandName="Up date" Text="Update" ID="Linkbutton2 "></asp:LinkButton>
<asp:LinkButt on runat="server" CausesValidatio n="false" CommandName="Ca ncel" Text="Cancel" ID="Linkbutton3 "></asp:LinkButton>
</EditItemTemplat e>
</asp:TemplateCol umn>
</Columns>
</asp:datagrid>
[/code]
ERROR:
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullRefe renceException: Object reference not set to an instance of an object.
Line 66: myCommand1 = New SqlCommand("Upd ate Table3 set Stocksent='" & Stocksent1.Text & "', Signedby='" & Signed1.Text & "',Takenby= '" & Takenby1.Text & "', Comments='" & Comments1.Text & "', Flag=0, Sentdate=getdat e() where Items='" & Items1 & "' ", myConnection)
Comment