如何根据windows应用程序中的combobox选择项过滤在datagridview中显示数据? [英] How to display data in datagridview according to filter by combobox selected item in windows application?
问题描述
你好,
我想在combobox选择索引更改事件上过滤datagridview数据,我已编写代码,但是当我们选择Item时,我的datagridview被清空。 br />
我的代码是: -
private void cmbSearchTileCategory_SelectedIndexChanged(object sender,EventArgs e)
{
var obj = new ConnectionClass();
var con = obj.GetConnection();
SqlCommand cmd = new SqlCommand(select * from FloorTile where FloorCatName =''+ cmbSearchTileCategory.SelectedItem +'',con);
SqlDataReader sdr = cmd.ExecuteReader();
SqlDataAdapter sda = new SqlDataAdapter(cmd );
DataSet ds = new DataSet();
sda.Fill(ds,FloorTile);
dgvDisplayTiles.DataSource = ds ;
}
此流程仅适用于C#.Net Windows应用程序。
请帮我解决这个问题。
先谢谢。
Ankit Agarwal
软件工程师
Hello,
I want to filter datagridview data on combobox selected index changed event, I have written code but when we select Item so my datagridview is blanked.
My Code is:-
private void cmbSearchTileCategory_SelectedIndexChanged(object sender, EventArgs e)
{
var obj = new ConnectionClass();
var con = obj.GetConnection();
SqlCommand cmd = new SqlCommand("select * from FloorTile where FloorCatName=''" + cmbSearchTileCategory.SelectedItem + "''", con);
SqlDataReader sdr = cmd.ExecuteReader();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds, "FloorTile");
dgvDisplayTiles.DataSource = ds;
}
This process only for C# .Net Windows Application.
Please help me for this problem.
Thanks in Advance.
Ankit Agarwal
Software Engineer
推荐答案
更改
Change
dgvDisplayTiles.DataSource = ds;
to
to
dgvDisplayTiles.DataSource = ds["FloorTile"].DefaultView;
这篇关于如何根据windows应用程序中的combobox选择项过滤在datagridview中显示数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!