關于datagrid的使用以及動態修改，以及使用存儲過程的介紹
2024-07-21 02:24:48
供稿：網友
網站運營seo文章大全提供全面的站長運營經驗及seo技術!1.關于datagrid,datalist等數據綁定控件
由于vs.net是codebehind的， 而quickstart 上的例子是代碼與頁面混合的，所以許多朋友有些疑惑。特別是有關template中如何觸發事件的問題。
是這樣，許多server control都有一個commandname屬性
就是在.aspx中設置你那個edit的commandname，在.cs中用e.commandname 得到
如
///aspx頁面
<asp:datalist id=userslist runat="server" >
<template name="itemtemplate">
<asp:imagebutton id=imagebutton1 runat="server" imageurl="../images/edit.gif" alternatetext="編輯條目" commandname="edit"></asp:imagebutton>
<asp:imagebutton id=imagebutton2 runat="server" imageurl="../images/delete.gif" alternatetext="刪除條目" commandname="delete"></asp:imagebutton>
<asp:label id=lblrole runat="server" text="<%# container.dataitem%>" cssclass="normal"></asp:label>
</template>
<template name="edititemtemplate">
<span class="normal">email (cookie auth) or domain/username (windows auth)</span><br />
<asp:textbox id=username width="200" cssclass="normaltextbox" text="<%# container.dataitem %>" runat="server" />
<asp:linkbutton text="apply" commandname="apply" cssclass="commandbutton" runat="server" id=applybutton/>
</template>
</asp:datalist>
///cs文件
protected void userslist_itemcommand (object sender, datalistcommandeventargs e)
{
if (e.commandname == "edit") {
// set editable list item index if "edit" button clicked next to the item
userslist.edititemindex = e.item.itemindex;
// repopulate the datalist control
binddata();
}
else if (e.commandname == "apply") {
// obtain the current portal settings
portalconfigurationdata portalconfig = portalconfiguration.loadsettings(portalconfiguration.configfilepath);
// update user entry
portalconfig.securityroles[roleindex].users[e.item.itemindex] = ((textbox) e.item.findcontrol("username")).text;
// persist settings back to disk
portalconfiguration.persistsettings(portalconfig);
// disable editable list item access
userslist.edititemindex = -1;
// repopulate the datalist control
binddata();
}
else if (e.commandname == "delete") {
// obtain the current portal settings
portalconfigurationdata portalconfig = portalconfiguration.loadsettings(portalconfiguration.configfilepath);
// delete selected user
string[] users = new string[portalconfig.securityroles][roleindex].users.length-1];
for (int i=0, j=0; i < portalconfig.securityroles[roleindex].users.length; i++) {
if (i != e.item.itemindex) {
users[j] = portalconfig.securityroles[roleindex].users[i];
j++;
}
}
// update users
portalconfig.securityroles[roleindex].users = users;
// persist settings back to disk
portalconfiguration.persistsettings(portalconfig);
// ensure that item is not editable
userslist.edititemindex = -1;
// repopulate list
binddata();
}
}
2.關于在asp.net中調用存儲過程
例子如下：
sqlconnection myconnection = new sqlconnection(portalconfiguration.settings.databaseconnectionstring);
sqlcommand mycommand = new sqlcommand("addmessage", myconnection);
// mark the command as a sproc
mycommand.commandtype = commandtype.storedprocedure;
// add parameters to sproc
sqlparameter parameteritemid = new sqlparameter("@itemid", sqldatatype.int, 4);
parameteritemid.direction = parameterdirection.output;
mycommand.parameters.add(parameteritemid);
sqlparameter parametertitle = new sqlparameter("@title", sqldatatype.nvarchar, 100);
parametertitle.value = title;
mycommand.parameters.add(parametertitle);
sqlparameter parameterbody = new sqlparameter("@body", sqldatatype.nvarchar, 3000);
parameterbody.value = body;
mycommand.parameters.add(parameterbody);
sqlparameter parameterparentid = new sqlparameter("@parentid", sqldatatype.int, 4);
parameterparentid.value = parentid;
mycommand.parameters.add(parameterparentid);
sqlparameter parameterusername = new sqlparameter("@username", sqldatatype.nvarchar, 100);
parameterusername.value = username;
mycommand.parameters.add(parameterusername);
sqlparameter parameterportalid = new sqlparameter("@portalid", sqldatatype.int, 4);
parameterportalid.value = portalid;
mycommand.parameters.add(parameterportalid);
sqlparameter parametermoduleid = new sqlparameter("@moduleid", sqldatatype.int, 4);
parametermoduleid.value = moduleid;
mycommand.parameters.add(parametermoduleid);
