C#窗体应用程序中,怎样多个输入框只用一个查询按钮查询数据?
C#窗体应用程序中,怎样多个输入框只用一个查询按钮查询数据?已经写出一个输入框查询了
public void show(int pageIndex)
{
searchData = searchText.Text.Trim();
string SqlStr1 = string.Format(@"SELECT *
FROM IMOS_LO_Bin
where Material_Code like '%{0}%' or Material_Name like '%{0}%' or Material_Spec like '%{0}%'
", searchData);
DataSet ds1 = DataHelper.Fill(SqlStr1);
dgvWarning.DataSource = ds1.Tables[0];
dgvWarning.RowsDefaultCellStyle.BackColor = Color.LightCyan;
dgvWarning.AlternatingRowsDefaultCellStyle.BackColor = Color.White;
}
private void dgvWarning_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e)
{
e.Row.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
e.Row.HeaderCell.Value = string.Format("{0}", e.Row.Index + 1);
}
private void search_Click(object sender, EventArgs e)
{
show(1);
} |
免责声明:本内容仅代表回答会员见解不代表天盟观点,请谨慎对待。
版权声明:作者保留权利,不代表天盟立场。
|
|
|
|