DataGridView和ComboBox [英] DataGridView and ComboBox
本文介绍了DataGridView和ComboBox的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
显示DataGriView在Combobox中选择一个对象
Display DataGriView When choose a object in Combobox
推荐答案
你可以调整这个
示例以满足您的需求。
You may adapt this
Example to suit your needs.
public void loadgrid()
{
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [tablename] where [columnname] ='"+DropDownList1.SelecetedValue+"'", connStr); // Change query as per ur requirement
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
loadgrid();
}
试试这种方式.. :)
try this way..:)
<body>
<form runat="server">
<asp:dropdownlist runat="server" id="ddlDb" autopostback="True" onselectedindexchanged="ddlDb_SelectedIndexChanged" xmlns:asp="#unknown">
<asp:listitem text="-- Select --" value=""></asp:listitem>
<asp:listitem text="Students" value="Students"></asp:listitem>
<asp:listitem text="Classes" value="Classes"></asp:listitem>
</asp:dropdownlist>
<asp:gridview id="GridView1" runat="server" xmlns:asp="#unknown">
</asp:gridview>
</form>
</body>
protected void ddlDb_SelectedIndexChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(ddlDb.SelectedValue))
{
var dbPath = Server.MapPath(@"\App_Data\Database1.mdf");
var scon = "Data Source=.\\SQLEXPRESS;AttachDbFilename='" + dbPath + "';Integrated Security=True;User Instance=True";
var cmd = "select * from " + ddlDb.SelectedValue;
var dt = new DataTable();
var da = new SqlDataAdapter(cmd, scon);
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
这篇关于DataGridView和ComboBox的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文