5.19数据库

 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();
        }

    }

查询之后，girdview显示，同时在执行sql脚本的时候选对数据库