DataSet orderNumbers = new DataSet("OrderNumbers"); SqlDataAdapter da = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand("SELECT WorkOrderNumber, LineNumber FROM WorkOrder WHERE WorkOrderNumber = " + workordernumberTextBox.Text); cmd.CommandType = CommandType.Text; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["LConnection"].ToString()); da.SelectCommand = cmd; da.Fill(orderNumbers, "OrderNumbers"); ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("OrderNumbers", orderNumbers.Tables[0])); ReportViewer1.LocalReport.Refresh();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)