private void cmbSourceLocation_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
RptBusHoders rpt = new RptBusHoders();
//The report you created.
SqlConnection myConnection = default(SqlConnection);
SqlCommand MyCommand = new SqlCommand();
SqlDataAdapter myDA = new SqlDataAdapter();
ERPS_DBDataSet myDS = new ERPS_DBDataSet();
//The DataSet you created.
myConnection = new SqlConnection(cs.DBcon);
MyCommand.Connection = myConnection;
MyCommand.CommandText = "select distinct BusHolders.AdmissionNo, BusHolders.SourceLocation, BusHolders.StartingDate, Student.AdmissionNo AS Expr1, Student.EnrollmentNo, Student.StudentName, Student.FatherName, Student.MotherName,Student.FatherCN, Student.PermanentAddress, Student.TemporaryAddress, Student.ContactNo, Student.EmailID, Student.DOB, Student.Gender, Student.AdmissionDate, Student.Session, Student.Caste,Student.Religion, Student.Status, Student.Nationality, Student.Class, Student.Section, Student.SchoolID FROM BusHolders INNER JOIN Student ON BusHolders.AdmissionNo = Student.AdmissionNo where SourceLocation= '" + cmbSourceLocation.Text + "' order by Studentname ";
MyCommand.CommandType = CommandType.Text;
myDA.SelectCommand = MyCommand;
myDA.Fill(myDS, "BusHolders");
myDA.Fill(myDS, "Student");
rpt.SetDataSource(myDS);
crystalReportViewer5.ReportSource = rpt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void txtSourceLocation_TextChanged(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
RptBusHoders rpt = new RptBusHoders();
//The report you created.
SqlConnection myConnection = default(SqlConnection);
SqlCommand MyCommand = new SqlCommand();
SqlDataAdapter myDA = new SqlDataAdapter();
ERPS_DBDataSet myDS = new ERPS_DBDataSet();
//The DataSet you created.
myConnection = new SqlConnection(cs.DBcon);
MyCommand.Connection = myConnection;
MyCommand.CommandText = "select * from BusHolders,Student where Student.AdmissionNo=BusHolders.AdmissionNo and SourceLocation Like '" + txtSourceLocation.Text + "%' order by Studentname ";
MyCommand.CommandType = CommandType.Text;
myDA.SelectCommand = MyCommand;
myDA.Fill(myDS, "BusHolders");
myDA.Fill(myDS, "Student");
rpt.SetDataSource(myDS);
crystalReportViewer5.ReportSource = rpt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RptBusHoders rpt = new RptBusHoders();
rpt.Site = this.Site;
return(rpt);
}
private void button5_Click(object sender, EventArgs e)
{
try
{
if (cmbclass.Text == "")
{
MessageBox.Show("Please select class", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbclass.Focus();
return;
}
if (cmbSection.Text == "")
{
MessageBox.Show("Please select Section", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbSection.Focus();
return;
}
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
RptBusHoders rpt = new RptBusHoders();
//The report you created.
SqlConnection myConnection = default(SqlConnection);
SqlCommand MyCommand = new SqlCommand();
SqlDataAdapter myDA = new SqlDataAdapter();
ERPS_DBDataSet myDS = new ERPS_DBDataSet();
//The DataSet you created.
myConnection = new SqlConnection(cs.DBcon);
MyCommand.Connection = myConnection;
MyCommand.CommandText = "select * from BusHolders,Student where Student.AdmissionNo=BusHolders.AdmissionNo and StartingDate between @date1 and @date2 and Class= '" + cmbclass.Text + "'and Section='" + cmbSection.Text + "' order by Studentname ";
MyCommand.Parameters.Add("@date1", SqlDbType.DateTime, 30, "StartingDate").Value = Date_from.Value.Date;
MyCommand.Parameters.Add("@date2", SqlDbType.DateTime, 30, "StartingDate").Value = Date_to.Value.Date;
MyCommand.CommandType = CommandType.Text;
myDA.SelectCommand = MyCommand;
myDA.Fill(myDS, "BusHolders");
myDA.Fill(myDS, "Student");
rpt.SetDataSource(myDS);
crystalReportViewer1.ReportSource = rpt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
