程序很简单,就是一个GridView显示一些记录,这些记录是通过ObjectDataSource来显示的。然后有一个删除操作,用来删除相关的记录,但执行删除操作时总出问题。GridView的DataSource
<asp:ObjectDataSource ID="ObjectDataSource_gridView" runat="server" SelectMethod="getRssList" TypeName="DAL.rssUser" DeleteMethod="deleteUser">
<DeleteParameters>
<asp:Parameter Name="masterid" Type="Int16" />
</DeleteParameters>
</asp:ObjectDataSource>
当执行删除操作时调用deleteUser方法,该方法需要一个Int型的参数,也就是ID的值 .
public void deleteUser(int masterid)
{
string sql = "delete from rss_info where masterid=@id";
SqlParameter para = new SqlParameter("@id", SqlDbType.Int);
para.Value = masterid;
SqlHelper.ExecuteNonQuery(SqlHelper.connectionString, CommandType.Text, sql, para);
}
GridView的部份代码
<asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource_gridView" style="font-size: 9pt; font-family: 'Courier New'; text-decoration: none" BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None" AutoGenerateColumns="False" AllowPaging="True" AllowSorting="True" PageSize="20" DataKeyNames="masterid" AutoGenerateDeleteButton="True" >
为什么会出错?哪里有问题?
<asp:ObjectDataSource ID="ObjectDataSource_gridView" runat="server" SelectMethod="getRssList" TypeName="DAL.rssUser" DeleteMethod="deleteUser">
<DeleteParameters>
<asp:Parameter Name="masterid" Type="Int16" />
</DeleteParameters>
</asp:ObjectDataSource>
当执行删除操作时调用deleteUser方法,该方法需要一个Int型的参数,也就是ID的值 .
public void deleteUser(int masterid)
{
string sql = "delete from rss_info where masterid=@id";
SqlParameter para = new SqlParameter("@id", SqlDbType.Int);
para.Value = masterid;
SqlHelper.ExecuteNonQuery(SqlHelper.connectionString, CommandType.Text, sql, para);
}
GridView的部份代码
<asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource_gridView" style="font-size: 9pt; font-family: 'Courier New'; text-decoration: none" BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None" AutoGenerateColumns="False" AllowPaging="True" AllowSorting="True" PageSize="20" DataKeyNames="masterid" AutoGenerateDeleteButton="True" >
为什么会出错?哪里有问题?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货