protected void btn_load_report_Click(object sender, EventArgs e)
{
//string QN = txtQuote_No.Text;
if (txtQuote_No.Text == "")
{
Response.Write("<script>alert('Please enter Quotation Number')</script>");
}
else
{
//LoadTicketsReport();
//ViewReport();
DataTable dt = GetReport();
ReportViewer1.Visible = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("/Report/Pavsquotation.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
}
}
private DataTable GetReport()
{
DataTable ResultTable = new DataTable();
string connstr = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlConnection conn = new SqlConnection(connstr);
SqlCommand cmd = new SqlCommand("QuotationMaster", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@QuotationNo", txtQuote_No.Text);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ResultTable);
return ResultTable;
}