改变数据视图中搜索关键字的颜色
本文关键字:关键字 颜色 搜索 数据 视图 改变 | 更新日期: 2023-09-27 17:49:33
我必须写一个DataGridView
并以编程方式填充它。我想当用户搜索一个词,例如关键字,有包含它的单元格(例如其关键字)只是突出在关键字搜索词关键字不是所有关键字或不是单元格也不是行。下面是填充DataGridView
的代码:
private void Fill()
{
try
{
if (dataGridView1 != null)
{
dataGridView1.ColumnCount = 11;
dataGridView1.Columns[0].HeaderText = Resources.Form1_Fill_ID;
dataGridView1.Columns[1].HeaderText = Resources.Form1_Fill_Family;
dataGridView1.Columns[2].HeaderText = Resources.Form1_Fill_Cellphone;
dataGridView1.Columns[3].HeaderText = Resources.Form1_Fill_Phone1;
dataGridView1.Columns[4].HeaderText = Resources.Form1_Fill_Phone2;
dataGridView1.Columns[5].HeaderText = Resources.Form1_Fill_Phone3;
dataGridView1.Columns[6].HeaderText = Resources.Form1_Fill_Fax;
dataGridView1.Columns[7].HeaderText = Resources.Form1_Fill_CompanyName;
dataGridView1.Columns[8].HeaderText = Resources.Form1_Fill_Agency;
dataGridView1.Columns[9].HeaderText = Resources.Form1_Fill_Brands;
dataGridView1.Columns[10].HeaderText = Resources.Form1_Fill_Address;
dataGridView1.Columns[0].Name = Resources.Form1_Fill_ID;
dataGridView1.Columns[1].Name = Resources.Form1_Fill_Family;
dataGridView1.Columns[2].Name = Resources.Form1_Fill_Cellphone;
dataGridView1.Columns[3].Name = Resources.Form1_Fill_Phone1;
dataGridView1.Columns[4].Name = Resources.Form1_Fill_Phone2;
dataGridView1.Columns[5].Name = Resources.Form1_Fill_Phone3;
dataGridView1.Columns[6].Name = Resources.Form1_Fill_Fax;
dataGridView1.Columns[7].Name = Resources.Form1_Fill_CompanyName;
dataGridView1.Columns[8].Name = Resources.Form1_Fill_Agency;
dataGridView1.Columns[9].Name = Resources.Form1_Fill_Brands;
dataGridView1.Columns[10].Name = Resources.Form1_Fill_Address;
}
_conn.ConnectionString = _connectionString;
var cmd = new OleDbCommand("Select * from contacts ", _conn);
_conn.Open();
OleDbDataReader reader = cmd.ExecuteReader();
int i = 0;
while (reader != null && reader.Read())
{
if (dataGridView1 != null)
{
dataGridView1.Rows.Add(1);
}
if (dataGridView1 != null)
{
var row = dataGridView1.Rows[i];
row.Cells[Resources.Form1_Fill_ID].Value = reader[0].ToString();
row.Cells[Resources.Form1_Fill_Family].Value = reader[1].ToString();
row.Cells[Resources.Form1_Fill_Cellphone].Value = reader[2].ToString();
row.Cells[Resources.Form1_Fill_Phone1].Value = reader[3].ToString();
row.Cells[Resources.Form1_Fill_Phone2].Value = reader[4].ToString();
row.Cells[Resources.Form1_Fill_Phone3].Value = reader[5].ToString();
row.Cells[Resources.Form1_Fill_Fax].Value = reader[6].ToString();
row.Cells[Resources.Form1_Fill_CompanyName].Value = reader[7].ToString();
row.Cells[Resources.Form1_Fill_Agency].Value = reader[8].ToString();
row.Cells[Resources.Form1_Fill_Brands].Value = reader[9].ToString();
row.Cells[Resources.Form1_Fill_Address].Value = reader[10].ToString();
}
i++;
}
}
catch (Exception ex)
{
return;
}
finally
{
_conn.Close();
}
}
,这是搜索代码
private void searchBtn_Click(object sender, EventArgs e)
{
// Code to search the alphanumneric Part Number (in Column1 header called "PART NUMBER") and highlihgt the row
foreach (DataGridViewRow row in dataGridView1.Rows)
{
try
{
if (row.Cells[0].Value.ToString().Contains(searchTxt.Text))
//row.Cells[0].Style.ForeColor = Color.Red;
{
var t = row.Cells[0].Value.ToString();
}
if (row.Cells[1].Value.ToString().Contains(searchTxt.Text))
row.Cells[1].Style.ForeColor = Color.Red;
if (row.Cells[2].Value.ToString().Contains(searchTxt.Text))
row.Cells[2].Style.ForeColor = Color.Red;
if (row.Cells[3].Value.ToString().Contains(searchTxt.Text))
row.Cells[3].Style.ForeColor = Color.Red;
if (row.Cells[4].Value.ToString().Contains(searchTxt.Text))
row.Cells[4].Style.ForeColor = Color.Red;
if (row.Cells[5].Value.ToString().Contains(searchTxt.Text))
row.Cells[5].Style.ForeColor = Color.Red;
if (row.Cells[6].Value.ToString().Contains(searchTxt.Text))
row.Cells[6].Style.ForeColor = Color.Red;
if (row.Cells[7].Value.ToString().Contains(searchTxt.Text))
row.Cells[7].Style.ForeColor = Color.Red;
if (row.Cells[8].Value.ToString().Contains(searchTxt.Text))
row.Cells[8].Style.ForeColor = Color.Red;
if (row.Cells[9].Value.ToString().Contains(searchTxt.Text))
row.Cells[9].Style.ForeColor = Color.Red;
if (row.Cells[10].Value.ToString().Contains(searchTxt.Text))
row.Cells[10].Style.ForeColor = Color.Red;
}
catch (Exception)
{
return;
}
}
}
如果此搜索仅依赖于客户端加载的数据,那么您为什么不建议客户使用浏览器搜索功能呢?
如果你仍然需要为客户提供这个功能,那么为什么你要在服务器端代码来完成这个任务....你可以在javascript中处理这个问题。下面是一个示例链接,它解释了如何在javascript中访问datagridview。
- http://www.netomatix.com/development/gridviewclientsideaccess.aspx
- http://www.thescarms.com/dotnet/webdatagrid.aspx
这在标准的。net控件中是不可能的。您可以尝试Telerik winform套件或类似的,它控制允许使用HTML格式只突出显示文本的一部分。
你真的需要DataGridView
吗?如果您只使用它来显示数据,您也可以尝试使用WebBrowser
控件并在那里绘制html表。
你也应该重构你的搜索代码:
for(int i=0; i<11; i++)
{
if (row.Cells[i].Value.ToString().Contains(searchTxt.Text))
row.Cells[i].Style.ForeColor = Color.Red;
}