protected void Bind() //绑定
    {
        SqlConnection tcon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        string sql = "select top 10 creat_dt,bod_cd,bod_id,mate_name,med_name,specifi,pdt_place,qtyperpack,med_id,bod_type_id,bod_status_id,";
        sql = sql + "mate_id dtl_id,bat_cd,valid_dt,qty,price,amot,sta_id ";
        sql = sql + "from vi_report where  bod_cd like '%" + bodcd.Text + "%' and bod_type_id=2 and bod_status_id=1 ";
        sql = sql + "and creat_dt>'2015-1-1' and sta_id= '" + Label1.Text + "' order by bod_cd,pdt_place";
        tcon.Open();
        SqlCommand cmd = new SqlCommand(sql, tcon);
        SqlDataReader reader = cmd.ExecuteReader();
        this.GridView1.DataSource = reader;
        this.GridView1.DataBind();
        tcon.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Bind();
    }