//To Populate ComboBox cmbYear public void getYear() { DBFunctions s = new SQLFunctions(path); List<string> year = s.cmbboxYear(); foreach (var y in year) { cmbYear.DataSource = year; cmbYear.DisplayMember = y; } }
//To Populate ComboBox cmbMonth public void getMonth() { DBFunctions s = new SQLFunctions(path); //return month List<string> month = s.cmbboxMonth(); foreach (var y in month) { cmbMonth.DataSource = month; cmbMonth.DisplayMember = y; } }
private void btnSubmit_Click(object sender, EventArgs e) { bool result=txtValidate(this.txtUsage); if(result==false) { errorProvider1.SetError(txtUsage, "Please enter a valid number"); } else { errorProvider1.Clear(); string mon = cmbMonth.Text; int year = Convert.ToInt32(cmbYear.Text); int usage = Convert.ToInt32(txtUsage.Text); Stopwatch stp = new Stopwatch(); if (rdbSql.Checked == true) //To Execute SQL { DBFunctions s = new SQLFunctions(path); frmUsage f = new frmUsage(); stp.Start(); List<string> name = s.retrieveData(mon, year, usage); stp.Stop(); GridView(name); stopwatch2.Text = Convert.ToString(stp.ElapsedMilliseconds)+"ms"; } else //To Execute LINQ { DBFunctions s = new LINQFunctions(conStr); frmUsage f = new frmUsage(); stp.Start(); List<string> name = s.retrieveData(mon, year, usage); stp.Stop(); GridView(name); stopwatch1.Text = Convert.ToString(stp.ElapsedMilliseconds)+"ms"; } } }