selvi subramanian

NA
818
422.1k

error in update query

Jul 3 2014 12:54 AM

string nm = ((Label)GridView1.Rows[e.RowIndex].FindControl("lblname")).Text;

string Bo = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txnbno")).Text;

//string BNo = Convert.ToInt32(Bo)

string bdate = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtbildate")).Text;

string adre = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtadrsse")).Text;

string phn = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtphnebin")).Text;

string emil = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtemidl")).Text;

string supfr = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtsupfor")).Text;

string bbd = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtbnd")).Text;

SqlConnection con = new SqlConnection(strConnString);

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.Text;

cmd.CommandText = "update suplerrate set BillNo=@BillNo," + "BillDate=@BillDate," + "Address=@Address, " + " Phone=@Phone ," + " EmailId=@EmailId," + "Supplierfor=@Supplierfor," + "Brand=@Brand where Name=@Name;" +

"select Name, BillNo,BillDate, Address,Phone,EmailId,Supplierfor,Brand from suplerrate";

// "select Name, BillNo,BillDate, Address,Phone,EmailId,Supplierfor,Brand,Billingrate,vat,discount,total,percentage,amount from suplerrate";

cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = nm;

cmd.Parameters.Add("@BillNo", SqlDbType.Int).Value = BNo;

cmd.Parameters.Add("@BillDate", SqlDbType.VarChar).Value = bdate;

cmd.Parameters.Add("@Address", SqlDbType.VarChar).Value = adre;

cmd.Parameters.Add("@Phone", SqlDbType.BigInt).Value = phn;

cmd.Parameters.Add("@EmailId", SqlDbType.VarChar).Value = emil;

cmd.Parameters.Add("@Supplierfor", SqlDbType.VarChar).Value = supfr;

cmd.Parameters.Add("@Brand", SqlDbType.VarChar).Value = bbd;

GridView1.EditIndex = -1;

GridView1.DataSource = GetData(cmd);

GridView1.DataBind();

my source code is

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"

Font-Names = "Arial" Font-Size = "11pt" BackColor="White"

AlternatingRowStyle-BackColor = "#C2D69B" HeaderStyle-BackColor = "pink"

ShowFooter="true" onrowediting="EditCustomer"

onrowcancelingedit="CancelEdit"

onrowupdating="UpdateCustomer">

<asp:TemplateField HeaderText="Name" ItemStyle-Width = "5px">

<asp:Label ID="lblname" runat="server" Text="<%#bind('Name') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txbna" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="BillNo">

<asp:Label ID="lblbillno" runat="server" Text="<%# bind('BillNo') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txnbno" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="BillDate">

<asp:Label ID="lbldatebil" runat="server" Text="<%#bind('BillDate' )%>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtbildate" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Address">

<asp:Label ID="lblladrss" runat="server" Text="<%#bind('Address') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtadrsse" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Phone">

<asp:Label ID="lblbinpho" runat="server" Text="<%#bind('Phone') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtphnebin" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="EmailId">

<asp:Label ID="lblemiid" runat="server" Text="<%#bind('EmailId') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtemidl" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Supplierfor">

<asp:Label ID="lblsuplerfor" runat="server" Text="<%#bind('Supplierfor') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtsupfor" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Brand">

<asp:Label ID="lblbrdn" runat="server" Text="<%#bind('Brand') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtbnd" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<%-- <asp:TemplateField HeaderText="Billingrate">

<asp:Label ID="lbbigent" runat="server" Text="<%#bind('Billingrate') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtbingnnt" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="vat">

<asp:Label ID="lbvvat" runat="server" Text="<%#bind('vat') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txvaatb" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="discount">

<asp:Label ID="lbdisun" runat="server" Text="<%#bind('discount') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtdiscnt" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="total">

<asp:Label ID="lbtolot" runat="server" Text="<%#bind('total') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txttoool" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="percentage">

<asp:Label ID="lblpercng" runat="server" Text="<%#bind('percentage') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtpecntge" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="amount">

<asp:Label ID="lbamt" runat="server" Text="<%#bind('amount') %>"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtamnut" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

--%> <asp:TemplateField>

<asp:LinkButton ID="lnkRemove" runat="server" CommandArgument = '<%# Eval("Name")%>' OnClientClick = "return confirm('Do you want to delete?')"

Text = "Delete" OnClick = "DeleteCustomer"> </asp:LinkButton>

</ItemTemplate>

<asp:Button ID="btnAdd" runat="server" Text="Add" OnClick = "AddNewCustomer" />

</FooterTemplate>

</asp:TemplateField>

<asp:CommandField ShowEditButton="True" />

</Columns><AlternatingRowStyle BackColor="#C2D69B" />

</asp:GridView>

my error is

Server Error in '/bramandam site' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0103: The name 'BNo' does not exist in the current context

Source Error:

Line 421:        //  "select  Name, BillNo,BillDate, Address,Phone,EmailId,Supplierfor,Brand,Billingrate,vat,discount,total,percentage,amount from suplerrate"; Line 422:        cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = nm; Line 423:        cmd.Parameters.Add("@BillNo", SqlDbType.Int).Value = BNo; Line 424:        cmd.Parameters.Add("@BillDate", SqlDbType.VarChar).Value = bdate; Line 425:        cmd.Parameters.Add("@Address", SqlDbType.VarChar).Value = adre;

Source File: d:\bramandam site\stockentry.aspx.cs Line: 423

Show Detailed Compiler Output:

Show Complete Compilation Source:

Version Information: Microsoft .NET Framework Version:2.0.50727.4984; ASP.NET Version:2.0.50727.4971

Answers (1)

Datalist pagination current values access on button click

How to drag item from database in kendoGrid