4,816
社区成员
发帖
与我相关
我的任务
分享
SqlConnection myConn = new SqlConnection(ConfigurationManager.AppSettings["SQLConnectionString"]);
SqlDataAdapter myda = new SqlDataAdapter("it_JDX_ponovouchersp", myConn);
myda.SelectCommand.Parameters.AddWithValue("@vend_num", this.TextBox1.Text);
myda.SelectCommand.Parameters.AddWithValue("@item", this.TextBox2.Text);
myda.SelectCommand.Parameters.AddWithValue("@end_date", DateTime.Now.ToString());
myda.SelectCommand.Parameters.AddWithValue("@flag", 1);
myda.SelectCommand.Parameters.AddWithValue("@location", this.TextBox1.Text);
myda.SelectCommand.Parameters.AddWithValue("@printer", this.TextBox2.Text);
myda.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet myds = new DataSet();
myConn.Open();
myda.Fill(myds);
myConn.Close();
ReportViewer1.Visible = true;
ReportDataSource rds = new ReportDataSource("DataSet1po1", myds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.Refresh();