Please help i am trying to display data between two dates using the report viewer as well an a jquery datepicker below is my code but it keeps throwing up the error message
Please what is wrong thanks
Chinedu Nwankwo
protected void Btnsearch_Click(object sender, EventArgs e)
{
try
{
// based on the scenerio of the check button disable the pinnumber button then call the various classes for the reports
IFormatProvider enGBDateFormat = new CultureInfo("en-GB").DateTimeFormat;
Convert.ToDateTime(txtstartdate.Text, enGBDateFormat);
Convert.ToDateTime(txtEndDate.Text, enGBDateFormat);
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbs"].ConnectionString);
con.Open();
SqlCommand cmd;
//SqlCommand cmd3;
String sql = "select * from BILLING_TAB where PIN_NUM LIKE '@pinnum' AND BILL_DAT between @startdate AND @enddate";
cmd = new SqlCommand(sql, con);
// cmd.CommandType = CommandType.StoredProcedure;
//string branchcode = drpbranch.SelectedValue;
cmd.Parameters.Add("@pinnum", SqlDbType.VarChar).Value = txtpin.Text;
cmd.Parameters.Add("@startdate", SqlDbType.DateTime).Value = Convert.ToDateTime(txtstartdate.Text, enGBDateFormat);
cmd.Parameters.Add("@enddate", SqlDbType.DateTime).Value = Convert.ToDateTime(txtEndDate.Text, enGBDateFormat).AddDays(1);
cmd.ExecuteNonQuery();
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds, "DataSet4");
DataTable dt = new DataTable();
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
lblmessage.Text = "Loading.....";
}
else
{
lblmessage.Text = "No records found...";
//btnUpload.Visible = false;
// ScriptManager.RegisterStartupScript(Page, Page.GetType(), "InvalidArgs", "alert('No record found ');", true);
}
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/BillingReport.rdlc");
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet4", ds.Tables[0]));
//ReportParameter startdate = new ReportParameter("startDate", Convert.ToDateTime(txtStartDate.Text, enGBDateFormat).ToString());
//tryBalancerpt.LocalReport.SetParameters(new ReportParameter[] { startdate });
//ReportParameter enddate = new ReportParameter("enddate", Convert.ToDateTime(txtEndDate.Text, enGBDateFormat).ToString());
//tryBalancerpt.LocalReport.SetParameters(new ReportParameter[] { enddate });
ReportViewer1.LocalReport.Refresh();
con.Close();
}
catch (Exception ex)
{
}
}
}
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
chinedu NwankwoPosted Feb 25, 2017, 2:40 PM
- An error occurred during local report processing.
- The report definition for report 'Report3' has not been specified
- Object reference not set to an instance of an object.
then i input the parameters ,pin_num , startdate and enddate and click search but i only get an empty reportNitin SontakkePosted Feb 25, 2017, 1:05 PM