private void Export_Load(object sender, EventArgs e)
{
dtpfromdate.Value = DateTime.Now;
dtptodate.Value = DateTime.Now;
cbbusname.Items.Clear();
string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["BUS"].ConnectionString.ToString();
SqlConnection conn = new SqlConnection(connstring);
conn.Open();
//string qry = "select * FROM BusMaster";
string qry = "SELECT '__All__' AS Name UNION Select Name FROM BusMaster ORDER BY Name";
SqlDataAdapter da = new SqlDataAdapter(qry, conn);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
int rowcount = ds.Tables[0].Rows.Count;
if (rowcount == 0)
{
MessageBox.Show("No Driver Record Found");
}
else
{
for (int count = 0; count < rowcount; count++)
{
cbbusname.Items.Insert(count, Convert.ToString(ds.Tables[0].Rows[count]["Name"]).Trim());
}
cbbusname.SelectedIndex = 0;
}
DriverReport dr = new DriverReport();
}
private void driverReportToolStripMenuItem_Click(object sender, EventArgs e)
{
DriverReport newMDIChild = new DriverReport();
newMDIChild.MdiParent = this;
newMDIChild.Show();
}
private void frmBusTripReport_Load(object sender, EventArgs e)
{
dtpfromdate.Value = DateTime.Now;
dtptodate.Value = DateTime.Now;
int trip = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["MAX_TRIP"]);
for (int i = 1; i <= trip; i++)
{
string[] numbers = { i.ToString() };
cbtrip.Items.AddRange(numbers);
}
cbtrip.SelectedIndex = 0;
cbbusname.Items.Clear();
string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["BUS"].ConnectionString.ToString();
SqlConnection conn = new SqlConnection(connstring);
conn.Open();
string qry = "select * FROM BusMaster";
SqlDataAdapter da = new SqlDataAdapter(qry, conn);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
int rowcount = ds.Tables[0].Rows.Count;
if (rowcount == 0)
{
MessageBox.Show("No Driver Record Found");
}
else
{
for (int count = 0; count < rowcount; count++)
{
cbbusname.Items.Insert(count, Convert.ToString(ds.Tables[0].Rows[count]["Name"]).Trim());
}
cbbusname.SelectedIndex = 0;
}
DriverReport dr = new DriverReport();
}
