protected void search_Click(object sender, EventArgs e)
{
string barid = TextBox1.Text.ToString();
string conStr = @"Data Source=BCSJYWJMBD5SOEP\SQL2005;Initial Catalog=longgukuang;Persist Security Info=True;User ID=sa;Password=longgukuang";
SqlConnection connection = new SqlConnection(conStr);
connection.Open();
SqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "select B.id as 运输计划ID,B.shift 班次,A.Code as 条形码,C.MaterialName as 物料名称 from TransportPlan B,TransportUnit A,MaterialPlan C where A.PlanID=B.id and A.PlanID=C.iD and A.id='" + barid + "'";
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
// DataTable dt = ds.Tables["Table"];
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
ClientScript.RegisterStartupScript(GetType(), null, "<script language=\"javascript\">alert('没有该条记录!');</script>");
}
else
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
{
string barid = TextBox1.Text.ToString();
string conStr = @"Data Source=BCSJYWJMBD5SOEP\SQL2005;Initial Catalog=longgukuang;Persist Security Info=True;User ID=sa;Password=longgukuang";
SqlConnection connection = new SqlConnection(conStr);
connection.Open();
SqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "select B.id as 运输计划ID,B.shift 班次,A.Code as 条形码,C.MaterialName as 物料名称 from TransportPlan B,TransportUnit A,MaterialPlan C where A.PlanID=B.id and A.PlanID=C.iD and A.id='" + barid + "'";
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
// DataTable dt = ds.Tables["Table"];
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
ClientScript.RegisterStartupScript(GetType(), null, "<script language=\"javascript\">alert('没有该条记录!');</script>");
}
else
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
查询之后,girdview显示,同时在执行sql脚本的时候选对数据库