Question

帮忙看下DataGridView数据库模糊查询的怎么写方法。一个txt和一个Button。要求把查询的结果加载到dgv中

public void loadData(string condition)
{
DBSQL sql = new DBSQL();
try
{
if (dgvDepartment.Rows.Count > 0)
dgvDepartment.Rows.Clear();
System.Data.DataTable dt = new System.Data.DataTable();
if (condition.Trim() == "")
{
dt = sql.dbToDS("select dNumber,dName,dPhone,dMemo,dHeader from [Department]", "temp").Tables["temp"];
for (int i = 0; i < dt.Rows.Count; i++)
{
i = dgvDepartment.Rows.Add();
dgvDepartment.Rows[i].Cells["colDpNumber"].Value = dt.Rows[i]["dNumber"].ToString().Trim();
// ........
System.Data.DataTable uN = sql.dbToDS("select uName from vw_TeacherUsers where tNumber='" + dt.Rows[i]["dHeader"].ToString().Trim() + "'", "temp").Tables["temp"];
if (uN.Rows.Count>0)
dgvDepartment.Rows[i].Cells["colDpHeader"].Value = uN.Rows[0]["uName"].ToString().Trim();
else
dgvDepartment.Rows[i].Cells["colDpHeader"].Value = "";
}
}
else
{......}

Answer 1

数据库模糊搜索是用SQL中的where条件中使用Like关键字，比如：select A1,A2 from Table where A1 like '123%'，其中'123%'可以用参数代替，C#中怎么用我不清楚，你可以查一下帮助文档。