Hi I have a problem on uploading microsoftreportviewer.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
roomno = Request.QueryString["RoomNo"];
id = Request.QueryString["id"];
this.ReportViewer1.LocalReport.DataSources.Clear();
DataSet1 ds = new DataSet1();
DataTable dt = new DataTable();
con.ConnectionString = conctn;
dt.TableName = "Print Advance Report";
dt = getAllOrders();
ds.Tables[0].Merge(dt);
Microsoft.Reporting.WebForms.ReportDataSource rptDataSource = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1_DataTable1", dt);
this.ReportViewer1.LocalReport.DataSources.Add(rptDataSource);
this.ReportViewer1.LocalReport.ReportPath = Server.MapPath("Checkout.rdlc");
this.ReportViewer1.LocalReport.Refresh();
}
}
public DataTable getAllOrders()
{
con.ConnectionString = conctn;
DataSet ds = null;
SqlDataAdapter adapter;
try
{
ds = new DataSet();
adapter = new SqlDataAdapter("select C.BillNo,dbo.GuestName(C.GuestID) as Name,convert(varchar(10),C.Date,103) as Date,convert(varchar(10),R.ArrivalDate,103) as ArrivalDate,R.ArrivalTime,convert(varchar(10),C.DepartureDate,103) as DepartureDate,C.DepartureTime,R.RoomRent,C.TotalRoomRent,C.RoomNo,E.NoOfPersons,C.LaundaryBill,C.FoodingBill,A.LuxuryTax,A.ServiceTax,A.ServiceCharges,A.AdvanceAmount,C.TotalDays,C.Refund,C.Total,C.GrandTotal,C.Discount,C.ExtraBedCharges,C.ExtraAmount from CheckOut C inner join Amount A on C.GuestID=A.GuestID inner join AllotRoom R on C.GuestID=R.GuestID inner join GuestEntry E on E.ID=C.GuestID where C.RoomNo='" + roomno + "' and C.GuestID='" + id + "'", con);
adapter.Fill(ds);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
con.Close();
}
return ds.Tables[0];
}
I am getting the following Error:
Not Found
The requested document was not found on this server.