Obout grid get error
HiAm using obout grid asp.net with sql server.when i click obout grid update got error i don't know why it's showing.
My error : Must declare the scalar variable "@customerId".
my code :
<Obout:Grid ID="grdview" runat="server" PageSizeOptions="-1,1,2,3,4,5,6,7,8,9,10"
OnUpdateCommand="UpdateRecord" OnDeleteCommand="DeleteRecord" CallbackMode="true" Serialize="true" AutoGenerateColumns="false">
<Columns>
<obout:Column DataField="CustomerId" HeaderText="Customer Id" runat="server"/>
<obout:Column DataField="CompanyName" HeaderText="Company Name" runat="server"/>
<obout:Column DataField="CustomerName" HeaderText="Customer Name" runat="server"/>
<obout:Column DataField="Street" HeaderText="Street" runat="server"/>
<obout:Column DataField="City" HeaderText="City" runat="server"/>
<obout:Column DataField="State" HeaderText="State" runat="server"/>
<obout:Column DataField="PhoneNo" HeaderText="Phone No" runat="server"/>
<obout:Column DataField="MobileNo" HeaderText="Mobile No" runat="server"/>
<obout:Column DataField="PANNumber" HeaderText="PAN No" runat="server"/>
<obout:Column DataField="GSTNumber" HeaderText="GST No" runat="server"/>
<obout:Column AllowEdit="true" AllowDelete="true" HeaderText="Edit" Width="100" runat="server" />
</Columns>
<ScrollingSettings ScrollHeight="100%" ScrollWidth="100%" ScrollLeft="100" ScrollTop="250"/>
</Obout:Grid>
void UpdateRecord(object sender, GridRecordEventArgs e)
{
try
{
OleDbConnection myConn = new OleDbConnection("Provider=SQLNCLI10;Data Source=DESKTOP-2TNPDQS;Integrated Security=SSPI;Initial Catalog=AppAccounting_Web;");
myConn.Open();
//OleDbCommand myComm = new OleDbCommand(@"update CompanyMaster set CustomerId=@CustomerId,CustomerName=@CustomerName,Street=@Street,City=@City,State=@State,PhoneNo=@PhoneNo,MobileNo=@MobileNo,PANNumber=@PANNumber,GSTNumber=@GSTNumber where CustomerId=@CustomerId", myConn);
OleDbCommand myComm = new OleDbCommand(@"update CompanyMaster set CustomerId=@customerId,CompanyName=@companyName,CustomerName=@customerName,Street=@street,City=@city,State=@state,PhoneNo=@phoneNo,MobileNo=@mobileNo,PANNumber=@pANNumber,GSTNumber=@gSTNumber where CustomerId=@customerId", myConn);
myComm.Parameters.Add("@customerId", OleDbType.VarChar).Value = e.Record["CustomerId"];
myComm.Parameters.Add("@companyName", OleDbType.VarChar).Value = e.Record["CompanyName"];
myComm.Parameters.Add("@customerName", OleDbType.VarChar).Value = e.Record["CustomerName"];
myComm.Parameters.Add("@street", OleDbType.VarChar).Value = e.Record["Street"];
myComm.Parameters.Add("@city", OleDbType.VarChar).Value = e.Record["City"];
myComm.Parameters.Add("@state", OleDbType.VarChar).Value = e.Record["State"];
myComm.Parameters.Add("@phoneNo", OleDbType.VarChar).Value = e.Record["PhoneNo"];
myComm.Parameters.Add("@mobileNo", OleDbType.VarChar).Value = e.Record["MobileNo"];
myComm.Parameters.Add("@pANNumber", OleDbType.VarChar).Value = e.Record["PANNumber"];
myComm.Parameters.Add("@gSTNumber", OleDbType.VarChar).Value = e.Record["GSTNumber"];
myComm.ExecuteNonQuery();
myConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}