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(); }