从文本框内在Datagridview中搜索(Windows App) [英] Search inside Datagridview from Textbox (Windows App)

问题描述

如何在C#Windows应用程序的文本框中搜索Datagridview?

How do I search in a Datagridview from a Textbox in a C# Windows App?

推荐答案

如果要在网格中使用搜索"，请看一下男人我建议您使用Telerik网格(Telerik控件可以在Internet上看到它们)，它在所有列中都包含通过网格进行的所有搜索(真的，您可以在某些列中停止它们)，请参见链接

最好的问候

look man if you want to use a "search" in your grid i advise you to use telerik grid (Telerik Controls see them in the internet) it contain all the kind of search via grid in all column (really you can stop them in some columns) see this link or thislink

best regards

在Textbox的Text_Changed事件中编写搜索查询.
使用DataAdapter和Dataset

Write search query in Textbox''s Text_Changed Event.
use DataAdapter and Dataset

dim DataAdapter as new OleDbDataAdapter("select * from [TableName] where [ColumnName] like %'" & Textbox1.Text &"'%",con);

Dim ds as DataSet;

adp.fill(ds);

DataGridView.Datasource=ds.Tables(0);

您可以轻松地使用文本框搜索datagridview输入搜索词.请尝试下面的简单示例.对我来说很好用.

You can easily search the datagridview using a textbox while typing the search words. Try the below simple example. It works perfectly with me.

DataTable dt = new DataTable();
DataView dv = null;

private void Test()
{

dt.Columns.Add("id", typeof(Int32));
dt.Columns.Add("code", typeof(String));

DataRow dr;

dr = dt.NewRow();
dr[0] = 1;
dr[1] = "abc";
dt.Rows.Add(dr);

dr = dt.NewRow();
dr[0] = 2;
dr[1] = "def";
dt.Rows.Add(dr);

dv = dt.DefaultView;
dataGridView1.DataSource = dv;

}

}

private void textBox1_TextChanged(object sender, EventArgs e)
{
 try
 {
    dv.RowFilter = "code like'%" + textBox1.Text.Trim() +  "%'";
 }
 catch { }
}

这篇关于从文本框内在Datagridview中搜索(Windows App)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！