ÇëÎÊasp.net°´Ìõ¼þ²éѯÔõôд£¿

C# code:

string str = System.Configuration.ConfigurationManager.AppSettings["strconn"];
SqlConnection conn = new SqlConnection(str);

SqlDataAdapter sdr=new SqlDataAdapter("select * from CustomerInfo where"+Drpselect.SelectedValue+" like '%"+txtSelect.Text.ToString()+"%'",conn);
DataSet ds = new DataSet();
try
{
//ÕâÀïÒªÔõôд°¡ £¿ÎÒ²»»á£¬²éѯ³öÀ´µÄ¶«Î÷°ó¶¨µ½ grdviewÉÏÃæ
£ý
catch (Exception ex)
{

}

---

C# code:

try
{
//ÕâÀïÒªÔõôд°¡ £¿ÎÒ²»»á£¬²éѯ³öÀ´µÄ¶«Î÷°ó¶¨µ½ grdviewÉÏÃæ
sdr.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}

---

C# code:

string str = System.Configuration.ConfigurationManager.AppSettings["strconn"];
SqlConnection conn = new SqlConnection(str);

SqlDataAdapter sdr=new SqlDataAdapter("select * from CustomerInfo where"+Drpselect.SelectedValue+" like '%"+txtSelect.Text.ToString()+"%'",conn);