string searchText = this.TextBox3.Text;
StringBuilder sb = new StringBuilder();
sb.Append("select * from UpLoad where Resourse_Title like '%");
sb.Append(searchText);
sb.Append("%'or Resourse_JianJie like '%");
sb.Append(searchText);
sb.Append("%'");
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider = sqloledb;Database=CHANGSHA-DB5D6B;Initial Catalog=User_Iformations;Integrated Security=True";
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter ada = new OleDbDataAdapter(sb.ToString(), conn);
ada.Fill(ds);
this.Repeater1.DataSource = ds;
this.Repeater1.DataBind();
conn.Close();
//怎么样把下面的连接语句改成SQL的,,,,,很急,求告诉解决
string strsql=string.Format ("select * from UpLoad where Resourse_Title like '%{0}%' or Resourse_JianJie like '%{1}%'",searchText,searchText);