CREATE RDLC REPORT FIRST USING DATASET
.ASPX
<center>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt" Height="400px" Width="825px">
<LocalReport ReportPath="PrintRequestion.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
Name="RequestionPrint_printrequestion" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetData"
TypeName="RequestionPrintTableAdapters.printrequestionTableAdapter">
</asp:ObjectDataSource>
</center>
.CS
public void princhallan()
{
try
{
string namep = objcom.porjectname();
string firmname = objcom.firmname();
string aa = "select ITEMNAME,Qty,UNITNAME from printrequestion where Mvoucher=" + Request.QueryString["id"].ToString() + "";
DataSet ds = SqlHelper.ExecuteDataset(con, CommandType.Text, aa);
string date = "A";
string ddate = "a";
string narration = "a";
string worktime = "a";
string Name = "a";
string aa2 = "select * from printrequestion where Mvoucher=" + Request.QueryString["id"].ToString() + "";
SqlDataReader rd = SqlHelper.ExecuteReader(con, CommandType.Text, aa2);
if (rd.Read())
{
date = rd["Date"].ToString();
date = Convert.ToDateTime(date).ToString("dd/MM/yyyy");
ddate = rd["DelDate"].ToString();
ddate = Convert.ToDateTime(ddate).ToString("dd/MM/yyyy");
narration = rd["Remarks"].ToString();
worktime = rd["Worktime"].ToString();
Name = rd["Name"].ToString();
rd.Close();
}
ReportParameter[] param = new ReportParameter[9];
param[0] = new ReportParameter("Report_Parameter_0", firmname);
param[1] = new ReportParameter("Report_Parameter_1", System.DateTime.Now.ToString("dd/MM/yyyy"));
param[2] = new ReportParameter("Report_Parameter_2", namep);
param[3] = new ReportParameter("Report_Parameter_3", Request.QueryString["id"].ToString());
param[4] = new ReportParameter("Report_Parameter_4", date);
param[5] = new ReportParameter("Report_Parameter_5", ddate);
param[6] = new ReportParameter("Report_Parameter_6", narration);
param[7] = new ReportParameter("Report_Parameter_7", worktime);
param[8] = new ReportParameter("Report_Parameter_8", Name);
ReportViewer1.LocalReport.SetParameters(param);
ReportViewer1.LocalReport.DataSources.Clear();
ReportDataSource reportDSHeader = new ReportDataSource("RequestionPrint_printrequestion", ds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Add(reportDSHeader);
ReportViewer1.LocalReport.Refresh();
}
catch (Exception ex)
{
MessageBox(this, "Try Again");
}
finally { }
}
.ASPX
<center>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt" Height="400px" Width="825px">
<LocalReport ReportPath="PrintRequestion.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
Name="RequestionPrint_printrequestion" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetData"
TypeName="RequestionPrintTableAdapters.printrequestionTableAdapter">
</asp:ObjectDataSource>
</center>
.CS
public void princhallan()
{
try
{
string namep = objcom.porjectname();
string firmname = objcom.firmname();
string aa = "select ITEMNAME,Qty,UNITNAME from printrequestion where Mvoucher=" + Request.QueryString["id"].ToString() + "";
DataSet ds = SqlHelper.ExecuteDataset(con, CommandType.Text, aa);
string date = "A";
string ddate = "a";
string narration = "a";
string worktime = "a";
string Name = "a";
string aa2 = "select * from printrequestion where Mvoucher=" + Request.QueryString["id"].ToString() + "";
SqlDataReader rd = SqlHelper.ExecuteReader(con, CommandType.Text, aa2);
if (rd.Read())
{
date = rd["Date"].ToString();
date = Convert.ToDateTime(date).ToString("dd/MM/yyyy");
ddate = rd["DelDate"].ToString();
ddate = Convert.ToDateTime(ddate).ToString("dd/MM/yyyy");
narration = rd["Remarks"].ToString();
worktime = rd["Worktime"].ToString();
Name = rd["Name"].ToString();
rd.Close();
}
ReportParameter[] param = new ReportParameter[9];
param[0] = new ReportParameter("Report_Parameter_0", firmname);
param[1] = new ReportParameter("Report_Parameter_1", System.DateTime.Now.ToString("dd/MM/yyyy"));
param[2] = new ReportParameter("Report_Parameter_2", namep);
param[3] = new ReportParameter("Report_Parameter_3", Request.QueryString["id"].ToString());
param[4] = new ReportParameter("Report_Parameter_4", date);
param[5] = new ReportParameter("Report_Parameter_5", ddate);
param[6] = new ReportParameter("Report_Parameter_6", narration);
param[7] = new ReportParameter("Report_Parameter_7", worktime);
param[8] = new ReportParameter("Report_Parameter_8", Name);
ReportViewer1.LocalReport.SetParameters(param);
ReportViewer1.LocalReport.DataSources.Clear();
ReportDataSource reportDSHeader = new ReportDataSource("RequestionPrint_printrequestion", ds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Add(reportDSHeader);
ReportViewer1.LocalReport.Refresh();
}
catch (Exception ex)
{
MessageBox(this, "Try Again");
}
finally { }
}
No comments:
Post a Comment