private void button2_Click(object sender, EventArgs e)
{
try
{
string img_path;
File.Copy(openFileDialog1.FileName, wanted_path + "\\student_image\\" + pwd + ".jpg");
con.Open();
mdi_user mu = new mdi_user();
img_path = "student_image\\" + pwd + ".jpg";
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into student_info values ('" + textBox1.Text + "','" + img_path.ToString() + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "')";
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted Successfully");
//mu.Show();
this.Close();
//this.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void button1_Click(object sender, EventArgs e)
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from library_person where username='******' and password='******'";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
count = Convert.ToInt32(dt.Rows.Count.ToString());
if (count == 0)
{
MessageBox.Show("Username Password Doesnt match");
}
else
{
this.Hide();
mdi_user mu = new mdi_user();
mu.Show();
}
}
