problem at the time of edit in gridview
-
hi i m using asp.net when i edit any feild it will generate a error. code is <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames="material_issueno" Style="position: relative;" AllowPaging="True" PageSize="20" AutoGenerateEditButton="True" OnRowEditing="GridView1_RowEditing1" CellPadding="4" ForeColor="#333333" GridLines="None"> <Columns> <asp:BoundField DataField="material_issueno" HeaderText="material_issueno" InsertVisible="False" ReadOnly="True" SortExpression="material_issueno" /> <asp:BoundField DataField="materialissue_date" HeaderText="materialissue_date" SortExpression="materialissue_date" /> <asp:BoundField DataField="qty" HeaderText="qty" SortExpression="qty" /> <asp:BoundField DataField="sno_to" HeaderText="sno_to" SortExpression="sno_to" /> <asp:BoundField DataField="sno_from" HeaderText="sno_from" SortExpression="sno_from" /> <asp:BoundField DataField="issue_to" HeaderText="issue_to" SortExpression="issue_to" /> <asp:BoundField DataField="issue_by" HeaderText="issue_by" SortExpression="issue_by" /> <asp:BoundField DataField="clientname" HeaderText="clientname" SortExpression="clientname" /> <asp:BoundField DataField="entered_by" HeaderText="entered_by" SortExpression="entered_by" /> <asp:BoundField DataField="ptypename" HeaderText="ptypename" SortExpression="ptypename" /> <asp:BoundField DataField="remarks" HeaderText="remarks" SortExpression="remarks" /> <asp:BoundField DataField="invoice" HeaderText="invoice" SortExpression="invoice" /> </Columns> <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <EditRowStyle BackColor="#999999" /> <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> </asp:GridView> <asp:SqlDataSou
-
hi i m using asp.net when i edit any feild it will generate a error. code is <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames="material_issueno" Style="position: relative;" AllowPaging="True" PageSize="20" AutoGenerateEditButton="True" OnRowEditing="GridView1_RowEditing1" CellPadding="4" ForeColor="#333333" GridLines="None"> <Columns> <asp:BoundField DataField="material_issueno" HeaderText="material_issueno" InsertVisible="False" ReadOnly="True" SortExpression="material_issueno" /> <asp:BoundField DataField="materialissue_date" HeaderText="materialissue_date" SortExpression="materialissue_date" /> <asp:BoundField DataField="qty" HeaderText="qty" SortExpression="qty" /> <asp:BoundField DataField="sno_to" HeaderText="sno_to" SortExpression="sno_to" /> <asp:BoundField DataField="sno_from" HeaderText="sno_from" SortExpression="sno_from" /> <asp:BoundField DataField="issue_to" HeaderText="issue_to" SortExpression="issue_to" /> <asp:BoundField DataField="issue_by" HeaderText="issue_by" SortExpression="issue_by" /> <asp:BoundField DataField="clientname" HeaderText="clientname" SortExpression="clientname" /> <asp:BoundField DataField="entered_by" HeaderText="entered_by" SortExpression="entered_by" /> <asp:BoundField DataField="ptypename" HeaderText="ptypename" SortExpression="ptypename" /> <asp:BoundField DataField="remarks" HeaderText="remarks" SortExpression="remarks" /> <asp:BoundField DataField="invoice" HeaderText="invoice" SortExpression="invoice" /> </Columns> <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <EditRowStyle BackColor="#999999" /> <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> </asp:GridView> <asp:SqlDataSou
-
Aren't you missing a comma after @sno_from ?
prateekfgiet wrote:
,[sno_from]=@sno_from [issue_to]=@issue_to,[issue_by]=@issue_by,
Scott
ok thanks now its working