public void Getallusers() { try { string sql = "SELECT * FROM gnrlusers"; con_db getusers = new con_db(); getusers.OpenConnection(); MySqlDataReader read = getusers.Readinfo(sql); while (read.Read()) { ListViewItem row = new ListViewItem(); row.SubItems.Add("" + read["usrname"]); row.SubItems.Add("" + read["usrpswrd"]); row.SubItems.Add("" + read["dob"]); row.SubItems.Add("" + read["gender"]); row.SubItems.Add("" + read["email"]); row.SubItems.Add("" + read["phone"]); row.SubItems.Add("G/User"); listView1.Items.Add(row); } getusers.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void Getadmins() { string sql = "SELECT * FROM admns"; con_db getadmns = new con_db(); getadmns.OpenConnection(); MySqlDataReader read = getadmns.Readinfo(sql); while (read.Read()) { ListViewItem row = new ListViewItem(); row.SubItems.Add("" + read["usrname"]); row.SubItems.Add("" + read["usrpswrd"]); row.SubItems.Add("" + read["dob"]); row.SubItems.Add("" + read["gender"]); row.SubItems.Add("" + read["email"]); row.SubItems.Add("" + read["phone"]); row.SubItems.Add("Admin"); listView1.Items.Add(row); //listBox2.Items.Add("" + read["usrname"]);// + " |" + read["email"]); //dataGridView1.Rows.Add(read["usrname"]); //listBox1.Items.Add(read["usrname"].ToString()); } getadmns.CloseConnection(); }
private void Getallcharts(string sql, bool decide = true) //Queries for all charts in the system { con_db getcharts = new con_db(); getcharts.OpenConnection(); MySqlDataReader readcharts = getcharts.Readinfo(sql); while (readcharts.Read()) { if (decide) { listCharts.Items.Add(readcharts["chart_number"]); } else { label11.Text = "" + readcharts["chart_number"]; label12.Text = "" + readcharts["st_code"]; //label13.Text= ""+ readcharts["date_digitized"]; label14.Text = "" + readcharts["season"]; string on = "" + readcharts["date_on"]; string off = "" + readcharts["date_off"]; label16.Text = "" + on; label18.Text = "" + off; DateTime don = Convert.ToDateTime(on).Date; DateTime doff = Convert.ToDateTime(off).Date; string diff = doff.Subtract(don).ToString(); label15.Text = "" + diff; } } getcharts.CloseConnection(); }
private void Getforchatrt(string sql) // Queries for a specific chart to display in chart area { con_db getcharts = new con_db(); getcharts.OpenConnection(); MySqlDataReader readcharts = getcharts.Readinfo(sql); chart1.Series["Series1"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line; while (readcharts.Read()) { //MessageBox.Show("Got point " + readcharts["X(actualcoord)"].ToString()+", "+ readcharts["Y(actualcoord)"].ToString()); //for testing MessageBox.Show("" + readcharts["st_code"] + ", " + readcharts["st_name"]); chart1.Series["Series1"].Points.AddXY(readcharts["X(actualcoord)"].ToString(), readcharts["Y(actualcoord)"].ToString()); } getcharts.CloseConnection(); }
private void login_Load(object sender, EventArgs e) { textBox1.Focus(); con_db atload = new con_db(); if (atload.OpenConnection()) { label3.ForeColor = Color.Blue; string codetail = atload.Getserverdetail(); label3.Text = "Connected to server at " + codetail; atload.CloseConnection(); } else { label3.ForeColor = Color.Red; label3.Text = "Connection to server Failed"; } }
private void getmyprofile() { string sql = "SELECT * FROM gnrlusers WHERE usrname='" + globals.usernamme + "' "; // MessageBox .Show(""+ sql ); //testing sql con_db populateprof = new con_db(); populateprof.OpenConnection(); MySqlDataReader read = populateprof.Readinfo(sql); while (read.Read()) { label1.Text = "" + read["usrname"].ToString(); label6.Text = "" + read["phone"].ToString(); label3.Text = "" + read["dob"].ToString(); label4.Text = "" + read["gender"].ToString(); label5.Text = "" + read["email"].ToString(); } populateprof.CloseConnection(); }
private void Populate() { try { string sql = "SELECT * FROM " + globals.tablescope + " WHERE usrname='" + globals.targetuser + "' "; // MessageBox .Show(""+ sql ); //testing sql con_db populateforedit = new con_db(); populateforedit.OpenConnection(); MySqlDataReader read = populateforedit.Readinfo(sql); while (read.Read()) { textusrername.Text = read["usrname"].ToString(); textpassword.Text = read["usrpswrd"].ToString(); textverify.Text = read["usrpswrd"].ToString(); textphone.Text = read["phone"].ToString(); //dateTimedob.Text = read["dob"].ToString(); combogender.Text = read["gender"].ToString(); textemail.Text = read["email"].ToString(); if (globals.tablescope == "admns") { textacceslevel.Text = "Administrator"; } else if (globals.tablescope == "gnrlusers") { textacceslevel.Text = "General User"; } globals.rowid = int.Parse(read["usrID"].ToString()); } populateforedit.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void Getallstations() { try { string sql = "SELECT * FROM stations"; con_db getstations = new con_db(); getstations.OpenConnection(); MySqlDataReader read = getstations.Readinfo(sql); while (read.Read()) { ListViewItem row = new ListViewItem(); row.SubItems.Add("" + read["st_name"]); row.SubItems.Add("" + read["st_code"]); listView1.Items.Add(row); } getstations.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button4_Click(object sender, EventArgs e) { button2.Visible = false; try { ListViewItem record = listView1.SelectedItems[0]; string sql = "SELECT * FROM stations WHERE st_code =" + record.SubItems[2].Text; con_db getstations = new con_db(); getstations.OpenConnection(); MySqlDataReader read = getstations.Readinfo(sql); while (read.Read()) { textBox2.Text = read["st_name"].ToString(); textBox3.Text = read["st_code"].ToString(); } button5.Visible = true; getstations.CloseConnection(); } catch (Exception) { MessageBox.Show("Please make a selecton first"); } }