public void BindDataset(string type, string date, string date2)
{
var objectDataSource = new Telerik.Reporting.ObjectDataSource();
//Getting Datasouce
SqlConnection con = new SqlConnection(Repository.Connection.DBConnectionString());
SqlCommand mySqlCommand = con.CreateCommand();
switch (type)
{
case "1":
mySqlCommand.CommandText = "Active_Percaptia_Search_sp";
mySqlCommand.Parameters.Add("@Mode", SqlDbType.NVarChar, 30).Value = "DOB";
mySqlCommand.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = Convert.ToDateTime(date);
mySqlCommand.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = Convert.ToDateTime(date2);
break;
case "2":
mySqlCommand.CommandText = "Active_Percaptia_N_sp";
break;
default:
mySqlCommand.CommandText = "Active_Percaptia_N_sp";
break;
}
mySqlCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
mySqlDataAdapter.SelectCommand = mySqlCommand;
DataTable dt = new DataTable();
con.Open();
mySqlDataAdapter.Fill(dt);
//Report
objectDataSource.DataSource = dt;
ReportPercapita Percapita = new ReportPercapita();
Percapita.DataSource = objectDataSource;
Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
reportSource.ReportDocument = Percapita;
ReportViewer1.ReportSource = reportSource;
}
protected void Page_Load(object sender, EventArgs e)
{
menu.GenerateMenu("Reports");
Submenu.GenerateMenu("Percapita-Active");
if (!IsPostBack)
{
Noreportlbl.Visible = false;
ReportPercapita report = new ReportPercapita();
ReportViewer1.Visible = true;
ReportViewer1.Report = report;
}
datelbl.Style["display"] = "none";
statuslbl.Style["display"] = "none";
datelbl2.Style["display"] = "none";
}
