mammad_kami
سه شنبه 24 اردیبهشت 1387, 15:46 عصر
مشکل از کجاست؟ خیلی باهاش ور رفتم ولی هیچ ایرادی پیدا نکردم.
اینم قطعه کدمه:
تو قسمته delete command ارور میده.
<asp:sqldatasource id="sdsFields" runat="server" providername="System.Data.SqlClient" connectionstring="Data Source=homeserver\sqlexpress;Initial Catalog=fahamuserdb;Integrated Security=True" selectcommand="SELECT id,name,username,pass,access FROM fields" updatecommand="UPDATE fields SET name=@name,username=@username,pass=@pass,access=@a ccess WHERE id=@id" deletecommand="DELETE FROM fields WHERE id=@id">
<deleteparameters>
<asp:parameter type="Int32" name="id" />
<asp:parameter type="string" name="name" />
<asp:parameter type="string" name="username" />
<asp:parameter type="string" name="pass" />
<asp:parameter type="Int16" name="access" />
</deleteparameters>
<asp:updateparameters>
<asp:parameter type="Int32" name="id" />
<asp:parameter type="string" name="name" />
<asp:parameter type="string" name="username" />
<asp:parameter type="string" name="pass" />
<asp:parameter type="Int16" name="access" />
</asp:updateparameters>
</asp:sqldatasource>
اینم قطعه کدمه:
تو قسمته delete command ارور میده.
<asp:sqldatasource id="sdsFields" runat="server" providername="System.Data.SqlClient" connectionstring="Data Source=homeserver\sqlexpress;Initial Catalog=fahamuserdb;Integrated Security=True" selectcommand="SELECT id,name,username,pass,access FROM fields" updatecommand="UPDATE fields SET name=@name,username=@username,pass=@pass,access=@a ccess WHERE id=@id" deletecommand="DELETE FROM fields WHERE id=@id">
<deleteparameters>
<asp:parameter type="Int32" name="id" />
<asp:parameter type="string" name="name" />
<asp:parameter type="string" name="username" />
<asp:parameter type="string" name="pass" />
<asp:parameter type="Int16" name="access" />
</deleteparameters>
<asp:updateparameters>
<asp:parameter type="Int32" name="id" />
<asp:parameter type="string" name="name" />
<asp:parameter type="string" name="username" />
<asp:parameter type="string" name="pass" />
<asp:parameter type="Int16" name="access" />
</asp:updateparameters>
</asp:sqldatasource>