report绑定数据库

 private void Form_report_Load(object sender, EventArgs e)
        {
            ///
            //绑定数据库数据源：
            //第一步：新建数据集，列名需与数据库表字段名一致
            //第二步：连接、查询数据库，查询结果填充数据集中数据表
            //第三步：设置本地报表，使程序与之前所建的.rdlc报表文件进行绑定。
            ///
            SqlConnection con = new SqlConnection(Class_sqlConnectString._sqlConnectString);
            //*****************************************************************************
            string strcmd = "select * from Table_1";
            //string strcmd = "select * from Table_20170330";
            //string strcmd = "select * from";
            //strcmd += Class_data.tableName;
            DataTable dt = new DataTable();
            try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand(strcmd, con);
                SqlDataAdapter ada = new SqlDataAdapter(cmd);
                ada.Fill(dt);//查询结果填充数据表
            }   
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString(), "错误提示");
                return;
            }
            finally
            {
                con.Close();//关闭连接
            }
            //*************************************************************************
            string strcmd0 = "select * from Table_pressInformation where 轴号 = '";
            strcmd0 += Class_dataGridViewSelect.zhouHao + "'";
            //string strcmd = "select * from Table_20170330";
            //string strcmd = "select * from";
            //strcmd += Class_data.tableName;
            DataTable dt0 = new DataTable();
            try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand(strcmd0, con);
                SqlDataAdapter ada = new SqlDataAdapter(cmd);
                ada.Fill(dt0);//查询结果填充数据表
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString(), "错误提示");
                return;
            }
            finally
            {
                con.Close();//关闭连接
            }
            //*************************************************************************
            //设置本地报表，使程序与之前所建的testReport.rdlc报表文件进行绑定。
            reportViewer1.LocalReport.ReportPath = "Report.rdlc";
            reportViewer1.LocalReport.DataSources.Clear();
            reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("pressureAndPosition", dt));
            reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("information", dt0));
            reportViewer1.RefreshReport();
        }