hi,
i have a windows form in which i have some combo boxes and check box and 2 date time picker.the data should be taken from combobox and filter according to check box and datetimepicker dates.how should i write stored procedure for this fields and pass it to crystal reports. any one help me out. my c# code is:
HTML Code:
private void button1_Click(object sender, EventArgs e)
{
ReportDocument rpt = new ReportDocument();
//crtestreport rpt = new crtestreport();
SqlCommand cmdcsp_workorder = new SqlCommand("sp_testspworkorder", con);
cmdcsp_workorder.CommandType = CommandType.StoredProcedure;
//cmdcsp_workorder.Parameters.Add
//cmdcsp_workorder.Parameters.Add("@customername", SqlDbType.NVarChar, 50) = "";
cmdcsp_workorder.Parameters.Add("@customername", SqlDbType.NVarChar, 50).Value = "APGB";
cmdcsp_workorder.Parameters.Add("@regionname", SqlDbType.NVarChar, 50).Value = "APGB KADAPA";
cmdcsp_workorder.Parameters.Add("@location", SqlDbType.NVarChar, 50).Value = "ANANTAPUR ";
cmdcsp_workorder.Parameters.Add("@system", SqlDbType.NVarChar, 50).Value = "SAS";
//cmdcsp_workorder.Parameters.Add("@district ", SqlDbType.NVarChar, 50).Value = cmbdistrict.SelectedValue;
//cmdcsp_workorder.Parameters.Add("@engineer", SqlDbType.NVarChar, 50).Value = cmbengname.SelectedValue;
//cmdcsp_workorder.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = dtpfromdate.Text ;
//cmdcsp_workorder.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = dtptodate.Text ;
//cmdcsp_workorder.Parameters.Add("@Branch", SqlDbType.VarChar, 50).Value = DDL_BranchName.SelectedValue;
cmdcsp_workorder.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmdcsp_workorder);
//DataSet ds = new DataSet(DataSetworkorder);
//DBForSafetySystemsDataSet ds = new DBForSafetySystemsDataSet();
DataSet ds = new DataSet();
DataTable workorderdt = new DataTable();
da.SelectCommand = cmdcsp_workorder;
da.Fill(ds , "workorderdt");
int rowcount = ds.Tables[0].Rows.Count;
if (rowcount != 0)
{
//string reportPath = Server.MapPath("C:\\Documents and Settings\\Administrator.POSITIVE\\Desktop\\shivani\\MasterPage(30)\\MasterPage\\crtestreport.rpt");
//string reportPath = Microsoft.SqlServer.Server.MapPath("..//crtestreport.rpt");
rpt.Load("c:\\Users\\Mohan\\Desktop\\MasterPage(30)\\MasterPage\\crtestreport.rpt");
//rpt.DataDefinition.FormulaFields["username"].Text = "'" + System.Environment.UserName.ToString() + "'";
rpt.SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Visible = true;
//crystalReportViewer1.DataBind();
//crystalReportSource1.DataBind();
crystalReportViewer1.ReportSource = rpt;
//CrystalReportViewer1.ShowAllPageIds = true;
}
its urgent plz any one rectify my error and send.