protected void Button1_Click(object sender, EventArgs e)
{
string sql = "select * from Vodinfo where vodname like '%" + TextBox1.Text + "%' and class = '" + DropDownList1.SelectedValue + "'";
//这里是class对应的是你动作片,喜剧片,科幻片的数据库字段
DataSet ds = new DataSet();
SqlConnection Conn = new SqlConnection("这里写数据库连接字符串");
Conn.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, Conn);
da.Fill(ds);
DataList1.DataSource = ds;
DataList1.DataBind();
Conn.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货