62,046
社区成员
发帖
与我相关
我的任务
分享
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="select top 1 * from employees "
UpdateCommand="UPDATE Employees SET LastName = @LastName WHERE (EmployeeID = @EmployeeID)"
>
<UpdateParameters>
<asp:Parameter Name="LastName" Type="String" />
<asp:Parameter Name="EmployeeID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
SqlDataSource1.UpdateCommand = "UPDATE Employees SET LastName = '" + "aaa'" + " WHERE EmployeeID = " + EmployeeID;
SqlDataSource1.Update();
SqlDataSource1.UpdateParameters.Add(new Parameter("EmployeeID",System.Data.DbType.Int32,));
SqlDataSource1.UpdateParameters.Add(new Parameter("@LastName",System.Data.DbType.Byte));