private void button2_Click(object sender, EventArgs e) { String scode = comboBox3.Text; if (scode.Equals("") || scode.Equals(null)) { MessageBox.Show("Please Enter/Select Teacher ID."); } else { MyDbCon mdb = new MyDbCon(); String sql = "select * from teacher where tid=" + comboBox3.Text + ""; MySqlDataReader reader = mdb.selectRow(sql); if (reader.HasRows) { reader.Read(); textBox1.Text = reader.GetString(1); textBox2.Text = reader.GetString(2); } else { MessageBox.Show("Teacher Dosen't Dosen't Exist."); } } }
private void SubAssignment_Load(object sender, EventArgs e) { MyDbCon mdb = new MyDbCon(); String sql = "select * from teacher"; MySqlDataReader reader = mdb.selectRow(sql); if (reader.HasRows) { while (reader.Read()) { comboBox2.Items.Add(reader.GetString(0)); } } else { MessageBox.Show("There is no branch."); } sql = "select * from subject"; MyDbCon md = new MyDbCon(); MySqlDataReader reader2 = md.selectRow(sql); if (reader2.HasRows) { while (reader2.Read()) { comboBox1.Items.Add(reader2.GetString(0)); } } listUser(); }
private void TimeTable_Load(object sender, EventArgs e) { MyDbCon md = new MyDbCon(); string sql = "select * from branch"; MySqlDataReader reader = md.selectRow(sql); if (reader.HasRows) { while (reader.Read()) { comboBox1.Items.Add(reader.GetString(0)); } } }
public string getShortName(int tid) { //string s; string sql = "select tshort from teacher where tid='" + tid + "'"; MyDbCon md = new MyDbCon(); MySqlDataReader rd = md.selectRow(sql); if (rd.HasRows) { rd.Read(); return(rd.GetString(0)); } return("NULL"); }
private void button1_Click_1(object sender, EventArgs e) { MyDbCon c = new MyDbCon(); String sql = "select * from `admin` where `username` = '" + textBox1.Text + "' and `password` = '" + textBox2.Text + "'"; MySqlDataReader reader = c.selectRow(sql); if (reader.HasRows) { ActiveForm.Hide(); Home h = new Home(); h.Show(); } else { MessageBox.Show(reader.HasRows + ": You have entered wrong id or password."); } }
private void button1_Click(object sender, EventArgs e) { MyDbCon md = new MyDbCon(); String sql = "select ttid from timetable where bcode = '" + comboBox1.Text + "' and bshift = '" + comboBox3.Text + "' and years = '" + comboBox2.Text + "'"; MySqlDataReader rd = md.selectRow(sql); if (rd.HasRows) { ShowTimeTable adt = new ShowTimeTable(int.Parse(comboBox1.Text), int.Parse(comboBox2.Text), int.Parse(comboBox3.Text)); this.Hide(); adt.Show(); } else { MessageBox.Show("Time Table Doesn't Exist!! \nClick on Create to create the time table."); } }
private void button2_Click(object sender, EventArgs e) { MyDbCon md = new MyDbCon(); String sql = "select ttid from timetable where bcode = '" + comboBox1.Text + "' and bshift = '" + comboBox2.Text + "' and years = '" + comboBox3.Text + "'"; MySqlDataReader rd = md.selectRow(sql); if (rd.HasRows) { MessageBox.Show("Time Table already exists!! \nClick to show for update."); } else { AddTT adt = new AddTT(int.Parse(comboBox1.Text), int.Parse(comboBox2.Text), int.Parse(comboBox3.Text)); this.Hide(); adt.Show(); } }
private void DeleteSubject_Load(object sender, EventArgs e) { MyDbCon mdb = new MyDbCon(); String sql = "select * from subject"; MySqlDataReader reader = mdb.selectRow(sql); if (reader.HasRows) { while (reader.Read()) { comboBox1.Items.Add(reader.GetString(0)); } } else { MessageBox.Show("There is no branch."); } }
private void EditTeacher_Load(object sender, EventArgs e) { MyDbCon mdb = new MyDbCon(); String sql = "select * from teacher"; MySqlDataReader reader = mdb.selectRow(sql); if (reader.HasRows) { while (reader.Read()) { comboBox3.Items.Add(reader.GetString(0)); } } else { MessageBox.Show("There is no Teacher."); } }
private void EditBranch_Load(object sender, EventArgs e) { MyDbCon mdb = new MyDbCon(); String sql = "select * from branch where bcode = " + branch + ""; MySqlDataReader reader = mdb.selectRow(sql); if (reader.HasRows) { reader.Read(); textBox1.Text = reader.GetString(0); textBox2.Text = reader.GetString(1); textBox3.Text = reader.GetString(2); textBox4.Text = reader.GetString(3); } else { MessageBox.Show("There is no branch."); } }
private void ShowTimeTable_Load(object sender, EventArgs e) { label85.Text = "BRANCH CODE : " + branch; label86.Text = "YEAR : " + year; label87.Text = "SHIFT : " + shift; String sql = "select * from timetable where bcode='" + branch + "' and years='" + year + "' and bshift='" + shift + "' "; MyDbCon mdb = new MyDbCon(); MySqlDataReader reader = mdb.selectRow(sql); if (reader.HasRows) { reader.Read(); L11.Text = reader.GetString(4); T11.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L12.Text = reader.GetString(4); T12.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L13.Text = reader.GetString(4); T13.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L14.Text = reader.GetString(4); T14.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L15.Text = reader.GetString(4); T15.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L16.Text = reader.GetString(4); T16.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L21.Text = reader.GetString(4); T21.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L22.Text = reader.GetString(4); T22.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L23.Text = reader.GetString(4); T23.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L24.Text = reader.GetString(4); T24.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L25.Text = reader.GetString(4); T25.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L26.Text = reader.GetString(4); T26.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L31.Text = reader.GetString(4); T31.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L32.Text = reader.GetString(4); T32.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L33.Text = reader.GetString(4); T33.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L34.Text = reader.GetString(4); T34.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L35.Text = reader.GetString(4); T35.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L36.Text = reader.GetString(4); T36.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L41.Text = reader.GetString(4); T41.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L42.Text = reader.GetString(4); T42.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L43.Text = reader.GetString(4); T43.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L44.Text = reader.GetString(4); T44.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L45.Text = reader.GetString(4); T45.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L46.Text = reader.GetString(4); T46.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L51.Text = reader.GetString(4); T51.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L52.Text = reader.GetString(4); T52.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L53.Text = reader.GetString(4); T53.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L54.Text = reader.GetString(4); T54.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L55.Text = reader.GetString(4); T55.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L56.Text = reader.GetString(4); T56.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L61.Text = reader.GetString(4); T61.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L62.Text = reader.GetString(4); T62.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L63.Text = reader.GetString(4); T63.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L64.Text = reader.GetString(4); T64.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L65.Text = reader.GetString(4); T65.Text = getShortName(int.Parse(reader.GetString(5))); reader.Read(); L66.Text = reader.GetString(4); T66.Text = getShortName(int.Parse(reader.GetString(5))); } }