| 发表于：2007-01-18 23:38:51 楼主 |
利用gridview内置的更新功能，但点击“更新”后变成删除记录了！
<%@ import namespace= "system "%>
<%@ import namespace= "system.data "%>
<%@ import namespace= "system.data.oledb "%>
<%@ import namespace= "system.configuration "%>
<%@ import namespace= "system.collections "%>
<%@ import namespace= "system.web "%>
<%@ import namespace= "system.web.security "%>
<%@ import namespace= "system.web.ui "%>
<%@ import namespace= "system.web.ui.webcontrols "%>
<%@ import namespace= "system.web.ui.webcontrols.webparts "%>
<%@ import namespace= "system.web.ui.htmlcontrols "%>
<%@ page language= "c# " masterpagefile= "~/masterpage.master " %>
<script runat= "server ">
void page_load（object sender, eventargs e)
{
}
void gridview1_onselectedindexchanged（object sender, eventargs e)
{
gridview1.selectedindex = -1;
}
public void gridview1_page（object sender, gridviewpageeventargs e)
{
gridview1.pageindex = e.newpageindex;
}
public void gridview1_rowupdating（object sender, gridviewupdateeventargs e)
{
e.newvalues[ "field1 "] = gridview1.rows[gridview1.editindex].cells[2].text;
e.newvalues[ "field2 "] = gridview1.rows[gridview1.editindex].cells[3].text;
}
</script>
<asp:content id= "content1 " contentplaceholderid= "maincontent " runat= "server ">
<asp:gridview id= "gridview1 " runat= "server " bordercolor= "black " borderwidth= "1px " cellpadding= "3 " width= "100% " pagesize= "10 " datasourceid= "sds1 " datakeynames= "id "
font-names= "宋体 " font-size= "10pt " headerstyle-backcolor= "#aaaadd " autogeneratecolumns= "false " allowpaging= "true "
onpageindexchanging= "gridview1_page " onrowupdating= "gridview1_rowupdating " autogenerateeditbutton= "true "
onselectedindexchanged= "gridview1_onselectedindexchanged ">
<pagerstyle horizontalalign= "left " />
<alternatingrowstyle backcolor= "#eeeeee " />
<columns>
<asp:boundfield datafield= "id " headertext= "id " sortexpression= "id " readonly= "true " />
<asp:boundfield datafield= "field1 " headertext= "field1 " />
<asp:boundfield datafield= "field2 " headertext= "field2 " />
</columns>
<headerstyle backcolor= "#aaaadd " />
</asp:gridview>
<asp:sqldatasource id= "sds1 " connectionstring= " <%$ connectionstrings:sql2000 %> " runat= "server "
selectcommand= "select * from v_applyrecords "
updatecommand= "update applyrecords set field1=@field1,field2=@field2 where （id=@id) " >
</asp:sqldatasource>
</asp:content>
|
|
|
|
|
