附上代码:
private void bind()
{
SqlConnection conn = new SqlConnection("server=localhost;user id=sa;pwd=;Database=");
SqlDataAdapter myadapter = new SqlDataAdapter("Select * from News", conn);
conn.Open(); DataSet myset = new DataSet();
myadapter.Fill(myset);
GridView1.DataSource = myset;
GridView1.DataBind();
conn.Close();
}protected void Btn_submit_Click(object sender, EventArgs e) //单击查询按钮
{
SqlConnection conn = new SqlConnection("server=localhost;user id=sa;pwd=;Database="); string Sqlstr = "select New_topic,New_come from News";
if (Tbx_topic.Text != "")
{
Sqlstr += "where New_topic like '%"+Tbx_topic.Text+"%' ";
}
if (Tbx_come.Text != "")
{
Sqlstr += "and New_come like '%"+ Tbx_come.Text +"%'";
}
SqlDataAdapter myadapter = new SqlDataAdapter(Sqlstr, conn);
conn.Open(); DataSet myset = new DataSet();
myadapter.Fill(myset); GridView1.DataSource = myset;
GridView1.DataBind(); conn.Close();
}
private void bind()
{
SqlConnection conn = new SqlConnection("server=localhost;user id=sa;pwd=;Database=");
SqlDataAdapter myadapter = new SqlDataAdapter("Select * from News", conn);
conn.Open(); DataSet myset = new DataSet();
myadapter.Fill(myset);
GridView1.DataSource = myset;
GridView1.DataBind();
conn.Close();
}protected void Btn_submit_Click(object sender, EventArgs e) //单击查询按钮
{
SqlConnection conn = new SqlConnection("server=localhost;user id=sa;pwd=;Database="); string Sqlstr = "select New_topic,New_come from News";
if (Tbx_topic.Text != "")
{
Sqlstr += "where New_topic like '%"+Tbx_topic.Text+"%' ";
}
if (Tbx_come.Text != "")
{
Sqlstr += "and New_come like '%"+ Tbx_come.Text +"%'";
}
SqlDataAdapter myadapter = new SqlDataAdapter(Sqlstr, conn);
conn.Open(); DataSet myset = new DataSet();
myadapter.Fill(myset); GridView1.DataSource = myset;
GridView1.DataBind(); conn.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货