DataGrid學習三
2024-07-21 02:22:37
供稿：網友
上一例中靜態填充選擇框的值，但這不太適合那些值在數據庫中會更改的情況。因為 select htmlcontrol 也支持 ienumerable
datasource 屬性，可以轉而使用選擇查詢動態填充選擇框，這將保證數據庫和用戶界面始終同步。下面的示例說明此過程。
<%@ import namespace="system.data" %>
<%@ import namespace="system.data.sqlclient" %>
<html>
<script language="c#" runat="server">
sqlconnection myconnection;
protected void page_load(object src, eventargs e)
{
myconnection = new sqlconnection("user id=sa;password=;initial catalog=pubs;data source=jeff");
if (!ispostback)
{
sqldataadapter mycommand = new sqldataadapter("select distinct state from authors", myconnection);
dataset ds = new dataset();
mycommand.fill(ds, "states");
myselect.datasource= ds.tables["states"].defaultview;
myselect.databind();
}
}
public void getauthors_click(object sender, eventargs e)
{
string selectcmd = "select * from authors where state = @state";
sqldataadapter mycommand = new sqldataadapter(selectcmd, myconnection);
mycommand.selectcommand.parameters.add(new sqlparameter("@state", sqldbtype.nvarchar, 2));
mycommand.selectcommand.parameters["@state"].value = myselect.value;
dataset ds = new dataset();
mycommand.fill(ds, "authors");
mydatagrid.datasource= ds.tables["authors"].defaultview;
mydatagrid.databind();
}
</script>
<body >
<form runat="server">
<h3><font face="宋體">對 datagrid 控件的動態參數化選擇</font></h3>
選擇州:
<select id="myselect" datatextfield="state" runat="server"/>
<input type="submit" onserverclick="getauthors_click" value="獲取作者" runat="server"/><p>
<asp:datagrid id="mydatagrid" runat="server"
width="700"
backcolor="#ccccff"
bordercolor="black"
showfooter="false"
cellpadding=3
cellspacing="0"
font-name="宋體"
font-size="8pt"
headerstyle-backcolor="#aaaadd"
enableviewstate="false"
/>
</form>
</body>
</html>
