110,567
社区成员
发帖
与我相关
我的任务
分享
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:GridView ID="gvMain" runat="server" OnSelectedIndexChanging="gvMain_SelectedIndexChanging">
<Columns>
<asp:CommandField ButtonType="Link" SelectText="选择" ShowSelectButton="true" />
</Columns>
</asp:GridView>
<br />
<asp:GridView ID="gv" runat="server">
</asp:GridView>
</form>
</body>
</html>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (SqlConnection connection = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=Northwind"))
{
SqlDataAdapter dataAdpater = new SqlDataAdapter("SELECT CategoryID, CategoryName,Description FROM Categories", connection);
DataSet dataSet = new DataSet();
dataAdpater.Fill(dataSet, "Categories");
if (dataSet.Tables.Contains("Categories"))
{
gvMain.DataSource = dataSet.Tables["Categories"].DefaultView;
gvMain.DataKeyNames = new string[] { "CategoryID" };
gvMain.DataBind();
}
}
}
}
protected void gvMain_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
using (SqlConnection connection = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=Northwind"))
{
SqlDataAdapter dataAdpater = new SqlDataAdapter("SELECT * FROM Products where CategoryID=@CategoryID ", connection);
dataAdpater.SelectCommand.Parameters.Add(new SqlParameter("@CategoryID", gvMain.DataKeys[e.NewSelectedIndex].Value));
DataSet dataSet = new DataSet();
dataAdpater.Fill(dataSet, "Products");
if (dataSet.Tables.Contains("Products"))
{
gv.DataSource = dataSet.Tables["Products"].DefaultView;
gv.DataBind();
}
}
}