while update i have error

Hi try this
protected void UpdateCustomer(object sender, GridViewUpdateEventArgs e)
    {
       
         string nm = ((Label)GridView1.Rows[e.RowIndex].FindControl("lblname")).Text;
        string BNo = ((TextBox)GridView1.FooterRow.FindControl("txnbno")).Text;
        //string BNo = Convert.ToInt32(Bo)
        string bdate = ((TextBox)GridView1.FooterRow.FindControl("txtbildate")).Text;
        string adre = ((TextBox)GridView1.FooterRow.FindControl("txtadrsse")).Text;
        string phn = ((TextBox)GridView1.FooterRow.FindControl("txtphnebin")).Text;
        string emil = ((TextBox)GridView1.FooterRow.FindControl("txtemidl")).Text;
        string supfr = ((TextBox)GridView1.FooterRow.FindControl("txtsupfor")).Text;
        string bbd = ((TextBox)GridView1.FooterRow.FindControl("txtbnd")).Text;
        //string bigt = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtbingnnt")).Text;
        //string vatt = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txvaatb")).Text;
        //string bdiste = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtdiscnt")).Text;
        //string tool = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txttoool")).Text;
        //string pentg = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtpecntge")).Text;
        //string txtamt = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtamnut")).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," + "Billingrate=@Billingrate," + "vat=@vat," + "discount=@discount," + "total=@total," + "percentage=@percentage," + "amount=@amount   where Name=@Name;" +
        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;
        //cmd.Parameters.Add("@vat", SqlDbType.Float).Value = vatt;
        //cmd.Parameters.Add("@discount", SqlDbType.Float).Value = bdiste;
        //cmd.Parameters.Add("@total", SqlDbType.Float).Value = tool;
        //cmd.Parameters.Add("@percentage", SqlDbType.Float).Value = pentg;
        //cmd.Parameters.Add("@amount", SqlDbType.Float).Value = txtamt;
        GridView1.EditIndex = -1;
        GridView1.DataSource = GetData(cmd);
        GridView1.DataBind();
    }

Hi you have to use this

BNo=((TextBox)GridView1.FooterRow[e.RowIndex].FindControl("txnbno")).Text;
and any text box u are using in Footer uhave to use FooterRow[e.RowIndex]. for finding the control and value.

it throw this error



An exception of type 'System.NullReferenceException' occurred in App_Web_ll8dodpz.dll but was not handled in user code Additional information: Object reference not set to an instance of an object.

Hi you have to use
BNo = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txnbno")).Text;



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: CS0029: Cannot implicitly convert type 'System.Web.UI.WebControls.TextBox' to 'string' Source Error: Line 401: Line 402: string nm = ((Label)GridView1.Rows[e.RowIndex].FindControl("lblname")).Text; Line 403: string BNo = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txnbno")); Line 404: string bdate = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtbildate")).Text; Line 405: string adre = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtadrsse")).Text; Source File: d:\bramandam site\stockentry.aspx.cs Line: 403 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

it throw the error like this if i try ur code



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: CS0029: Cannot implicitly convert type 'System.Web.UI.WebControls.TextBox' to 'string' Source Error: Line 401: Line 402: string nm = ((Label)GridView1.Rows[e.RowIndex].FindControl("lblname")).Text; Line 403: string BNo = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txnbno")); Line 404: string bdate = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtbildate")).Text; Line 405: string adre = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtadrsse")).Text; Source File: d:\bramandam site\stockentry.aspx.cs Line: 403 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

Hi selvi,

if i m not wrong the issue is in below code because when you are trying to find the control value it is not finding, because it is in footer templeten
 
               
           


try like this when you are fetching the data.