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);
        }


苦咖
浏览 1213回答 3
3回答
打开App,查看更多内容
随时随地看视频慕课网APP