求教育:在SqlDataSource中,如何使用UpdateCommand,DeleteCommand更新、删除多个表?
有两个表,需要从中取出数据,selectcommand已经写完了,运行正常,请问如何使用UpdateCommand更新呢?
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ZtbConnectionString %>"
SelectCommand="SELECT COMPANY.COMPANY as company, COMPANY.COMPANY_ADDRESS as address, COMPANY.COMPANY_MAILNUM as mailnum, COMPANY.COMPANY_PROVINCE as province, COMPANY.COMPANY_OPERATION, COMPANY.COMPANY_HOMEPAGE as homepage, COMPANY.COMPANY_PHONE as phone, COMPANY.COMPANY_EMAIL as email,TRADE.TRADE_NAME as trade_name FROM COMPANY INNER JOIN TRADE ON (COMPANY.TRADE_ID = TRADE.TRADE_ID) "
UpdateCommand="UPDATE COMPANY SET company = @company,address = @address,mailnum = @mailnum WHERE (company = @company" >
<UpdateParameters>
<asp:Parameter Name="company" />
<asp:Parameter Name="address" />
<asp:Parameter Name="mailnum" />
</UpdateParameters>
</asp:SqlDataSource>
后面使用了gridview
自动生成的"删除",和“编辑”不可用,请问高手如何写updateCommand?