asp.net - Incorrect syntax near 'int' when using updatecommand on a gridview -


i have problem when ever try update record in database using gridview update event handler , updatecommand in sqldatascource following exception incorrect syntax near 'int'. weird thing when reload page find record updated yet need exception message not appear should do

update event handler

   protected void gridview1_rowupdating(object sender, gridviewupdateeventargs e)     {              gridviewrow row = gridview1.rows[e.rowindex];             int busid = convert.toint32(((datakey)gridview1.datakeys[e.rowindex]).value);             textbox capacity =(textbox) row.cells[1].controls[0];             textbox drivername =(textbox) row.cells[3].controls[0];             textbox phone =(textbox) row.cells[4].controls[0];             sqldatasource1.updateparameters.add("capaity", capacity.text);             sqldatasource1.updateparameters.add("id", busid.tostring());             sqldatasource1.updateparameters.add("driver", drivername.text);             sqldatasource1.updateparameters.add("phone", phone.text);             sqldatasource1.update();     } 

gridview asp.net code

<asp:gridview id="gridview1" runat="server" autogeneratecolumns="false" cellpadding="4" datakeynames="bus number" datasourceid="sqldatasource1" forecolor="#333333" gridlines="none" height="326px" width="1017px" onrowupdating="gridview1_rowupdating">             <alternatingrowstyle backcolor="white" forecolor="#284775" />             <columns>                 <asp:boundfield datafield="bus number" headertext="bus number" readonly="true" sortexpression="bus number" />                 <asp:boundfield datafield="capacity" headertext="capacity" sortexpression="capacity" />                 <asp:boundfield datafield="numberofbooking" headertext="numberofbooking" sortexpression="numberofbooking" readonly="true" />                 <asp:boundfield datafield="driver" headertext="driver" sortexpression="driver" />                 <asp:boundfield datafield="phone" headertext="phone" sortexpression="phone" showheader="false" />                 <asp:boundfield datafield="date added" headertext="date added" sortexpression="date added" dataformatstring="{0:mm/dd/yyyy}" readonly="true" />                 <asp:commandfield showeditbutton="true" />                 <asp:commandfield showdeletebutton="true" />             </columns>             <editrowstyle backcolor="#999999" />             <footerstyle backcolor="#5d7b9d" font-bold="true" forecolor="white" />             <headerstyle backcolor="#5d7b9d" font-bold="true" forecolor="white" />             <pagerstyle backcolor="#284775" forecolor="white" horizontalalign="center" />             <rowstyle backcolor="#f7f6f3" forecolor="#333333" />             <selectedrowstyle backcolor="#e2ded6" font-bold="true" forecolor="#333333" />             <sortedascendingcellstyle backcolor="#e9e7e2" />             <sortedascendingheaderstyle backcolor="#506c8c" />             <sorteddescendingcellstyle backcolor="#fffdf8" />             <sorteddescendingheaderstyle backcolor="#6f8dae" />         </asp:gridview> 

the updatecommand

updatecommand="update buses set capacity = @capaity vechileid = @id ;update vechile set driver = @driver, phone = @phone    vechileid = @id"> 


Comments

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -