本文介绍了我在搜索datagridview时遇到错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想使用文本更改事件从数据网格视图中搜索记录但是当我尝试此代码时
I want to search record from data grid view using Text change event but when I tried this code
string rowFilter = string.Format("SELECT * FROM [VisitorInfo] where First Name LIKE '%{0}%' AND Last Name LIKE '%{1}%'", F_Name.Text, L_Name.Text);
(metroGrid1.DataSource as DataTable).DefaultView.RowFilter = rowFilter;
我收到
I'm getting
Object reference not set to an instance of an object
错误可以有人帮助我
我的尝试:
到目前为止我的代码
error can someone help me
What I have tried:
so far my codes
private void metroTile8_Click(object sender, EventArgs e)
{
try
{
Connection.Open();
String str = "select * from [VisitorInfo]";
OleDbCommand com = new OleDbCommand(str, Connection);
DataSet ds = new DataSet();
OleDbDataAdapter oledbda = new OleDbDataAdapter(com);
oledbda.Fill(ds, "[VisitorInfo]");
Connection.Close();
metroGrid1.DataSource = ds;
metroGrid1.DataMember = "[VisitorInfo]";
metroGrid1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
metroGrid1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
metroGrid1.DefaultCellStyle.Font = new Font("Tahoma", 15);
metroGrid1.ColumnHeadersDefaultCellStyle.Font = new Font("Tahoma", 12, FontStyle.Bold);
metroGrid1.Columns[0].Visible = false;
metroGrid1.Columns[0].FillWeight = 25;
metroGrid1.Columns[1].FillWeight = 50;
metroGrid1.Columns[2].FillWeight = 50;
Connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void search_txt_TextChanged(object sender, EventArgs e)
{
string rowFilter = string.Format("SELECT * FROM [VisitorInfo] where First Name LIKE '%{0}%' AND Last Name LIKE '%{1}%'", F_Name.Text, L_Name.Text);
(metroGrid1.DataSource as DataTable).DefaultView.RowFilter = rowFilter;
}
推荐答案
这篇关于我在搜索datagridview时遇到错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!