private void salesmanfillreport()
{
if (txtfromDate.Text != "" && txttoDate.Text != "" && DDLSalesman.SelectedItem.Value != "")
{
string from = txtfromDate.Text.Split('/')[1] + "/" + txtfromDate.Text.Split('/')[0] + "/" + txtfromDate.Text.Split('/')[2];
string To = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2];
fdate = Convert.ToDateTime(from);
tdate = Convert.ToDateTime(To);
if (fdate > tdate)
{
MessageBox("From Date is Greater than ToDate");
txtfromDate.Focus();
}
else
{
try
{
DataTable dt = new DataTable();
dt = Specimen.Get_SalesmanWiseBooks(DDLSalesman.SelectedItem.Value.ToString(), Convert.ToDateTime(from), Convert.ToDateTime(To)).Tables[0];
ReportDocument CR = new ReportDocument();
CR.Load(Server.MapPath("Report/SalesmanWiseBooks.rpt"));
CR.SetDataSource(dt);
crystalreportviewer1.ReportSource = CR;
}
catch {}
}
}
}
