private void Print_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
frmBusFeeReceipt frm = new frmBusFeeReceipt();
RptBusFeePaymentReceipt rpt = new RptBusFeePaymentReceipt();
//The report you created.
NpgsqlConnection myConnection = default(NpgsqlConnection);
NpgsqlCommand MyCommand = new NpgsqlCommand();
NpgsqlDataAdapter myDA = new NpgsqlDataAdapter();
//ERPS_DBDataSet myDS = new ERPS_DBDataSet();
//The DataSet you created.
//myConnection = new NpgsqlConnection(SQLCONN.DBcon);
//MyCommand.Connection = myConnection;
//MyCommand.CommandText = "select * from BusFeePayment,Student,Transportation,BusHolders where Student.AdmissionNo=BusHolders.AdmissionNo and BusFeePayment.AdmissionNo=Student.AdmissionNo and Transportation.SourceLocation=BusHolders.SourceLocation and FeePaymentID= '" + FeePaymentID.Text + "'";
//MyCommand.CommandType = CommandType.Text;
//myDA.SelectCommand = MyCommand;
//myDA.Fill(myDS, "BusFeePayment");
//myDA.Fill(myDS, "Transportation");
//myDA.Fill(myDS, "BusHolders");
//myDA.Fill(myDS, "Student");
//rpt.SetDataSource(myDS);
//frm.crystalReportViewer1.ReportSource = rpt;
//frm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}