private void button2_Click(object sender, EventArgs e) { button2.BackColor = Color.LightSkyBlue; string user = textBox1.Text; string password = pass1.Text; string userdb, passworddb; returnclass rc = new returnclass(); userdb = rc.scalarReturn("select count(ad_id) from administator where ad_name='" + user + "'"); if (userdb.Equals("0")) { MessageBox.Show("Invalid user name!"); } else { passworddb = rc.scalarReturn("select ad_password from administator where ad_name='" + user + "'"); if (passworddb.Equals(password)) { fk_ad = rc.scalarReturn("select ad_id from administator where ad_name='" + user + "'"); Dashboard f = new Dashboard(); f.Show(); } else { MessageBox.Show("Invalid Password!"); } } }
private void button1_Click(object sender, EventArgs e) { student s = new student(); // s.sfk = Form1.fk_ad; s.sfk = "1"; s.sdate = System.DateTime.Now.ToShortDateString(); s.sname = textBox1.Text; s.sfname = textBox2.Text; if (radioButton1.Checked == true) { s.sgender = "male"; } else if (radioButton2.Checked == true) { s.sgender = "female"; } else { MessageBox.Show("Please select gender!"); } s.saddress = richTextBox1.Text; MessageBox.Show(i.insert_srecord(s)); student_status sa = new student_status(); sa.year = System.DateTime.Now.Year.ToString(); sa.class_id = Convert.ToInt16(comboBox1.SelectedValue.ToString()); sa.status_student_id = Convert.ToInt32(r.scalarReturn("select max(std_id) from student")); i.insert_StudentStatus(sa); textBox5.Text = r.scalarReturn("select max(std_id) from student"); textBox4.Text = textBox5.Text; } //submit tbn ends
private void button1_Click(object sender, EventArgs e) { button1.BackColor = Color.LightGreen; q = "select s.std_id as 'id',s.std_name as 'Name',s.std_fname AS 'Father name',s.std_gender as 'Gender',s.std_address as 'Address',s.std_admissiondate as 'Admission Date' ,a.ad_name as 'Admin Name' from student s inner join administator a on a.ad_id=s.std_ad_fk_id where s.std_id=" + textBox2.Text; dataGridView1.DataSource = vc.showrecord(q); returnclass rc = new returnclass(); string pathquerry = rc.scalarReturn("select img_path from student_img where img_fk=" + textBox2.Text); if (pathquerry == " ") { pictureBox1.Image = Image.FromFile(@"C:\Users\salman\documents\visual studio 2013\Projects\WindowsFormsApplication4\WindowsFormsApplication4\Resources\profile.jpg"); } else { pictureBox1.Image = Image.FromFile(pathquerry); } pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; }
private void textBox3_KeyUp(object sender, KeyEventArgs e) { textBox1.Text = " "; textBox2.Text = " "; radioButton1.Checked = false; radioButton2.Checked = false; richTextBox1.Text = " "; SqlConnection connection = new SqlConnection(connstring); string sql = "select std_name,std_fname,std_gender,std_address,student_status from student where std_id=" + textBox3.Text; try { connection.Open(); SqlCommand cmd = new SqlCommand(sql, connection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader.GetValue(4).ToString().Equals("0")) { MessageBox.Show("Student Left!"); } else if (reader.GetValue(4).ToString().Equals("1")) { textBox1.Text = reader.GetValue(0).ToString(); textBox2.Text = reader.GetValue(1).ToString(); if (reader.GetValue(2).ToString().Equals("male")) { radioButton1.Checked = true; } else { radioButton2.Checked = true; } richTextBox1.Text = reader.GetValue(3).ToString(); // for image returnclass rc = new returnclass(); string pathquerry = rc.scalarReturn("select img_path from student_img where img_fk=" + textBox3.Text); if (pathquerry != " ") { pictureBox1.Image = Image.FromFile(pathquerry); pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; } else { // pictureBox1.Image = Image.FromFile(@"C:\Users\Nida\Desktop\Passportsizephoto.JPG"); pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; } button1.Enabled = true; } } connection.Close(); } catch (Exception ex) { MessageBox.Show("No RECORDS WERE FOUND!"); } }
private void button1_Click(object sender, EventArgs e) { button1.BackColor = Color.LightSteelBlue; SqlConnection connection = new SqlConnection(connstring); string sql = "select s.std_id,s.std_name,sa.SA_ID,SA_Class_id,sa.sa_year,c.classname,c.fees from student s inner join STUDENT_STATUS sa on sa.SA_ST_ID=s.std_id inner join classes c on c.class_id=sa.SA_Class_id where sa.sa_year='" + System.DateTime.Now.Year + "' and s.std_id=" + textBox1.Text; try { label2.Text = " "; label3.Text = " "; label4.Text = " "; label5.Text = " "; connection.Open(); SqlCommand cmd = new SqlCommand(sql, connection); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { button2.Enabled = true; while (reader.Read()) { label2.Text = reader.GetValue(1).ToString(); label3.Text = reader.GetValue(5).ToString(); label4.Text = reader.GetValue(6).ToString(); label5.Text = reader.GetValue(2).ToString(); } string pathquerry = rc.scalarReturn("select img_path from student_img where img_fk=" + textBox1.Text); if (pathquerry == " ") { pictureBox1.Image = Image.FromFile(@"C:\Users\salman\documents\visual studio 2013\Projects\WindowsFormsApplication4\WindowsFormsApplication4\Resources\profile.jpg"); } else { pictureBox1.Image = Image.FromFile(pathquerry); } pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; string s = rc.scalarReturn("select count(fee_id) from fees where fee_fk_st_id=" + textBox1.Text + " and monthx='" + System.DateTime.Now.Month.ToString() + "'"); if (s.Equals("0")) { button2.Enabled = true; label10.Text = "Unpaid!"; label10.ForeColor = System.Drawing.Color.Red; } else { label10.Text = "paid!"; button2.Enabled = false; label10.ForeColor = System.Drawing.Color.Green; } } else { MessageBox.Show("no records were found! "); button2.Enabled = false; } connection.Close(); } catch (Exception ex) { MessageBox.Show("No RECORDS WERE FOUND!"); } }