private void btnSave_Click(object sender, EventArgs e)
{
if (Validation())
{
byte[] images = null;
FileStream fileStream = new FileStream(imgLocation, FileMode.Open, FileAccess.Read);
BinaryReader brs = new BinaryReader(fileStream);
images = brs.ReadBytes((int)fileStream.Length);
conn.Open();
string sql = "INSERT INTO Profile(Name,Email,JobTitle,ContactNo,Image) VALUES ('" + txtboxName.Text + "','" + txtboxEmail.Text + "','" + txtboxJobTitle.Text + "','" + txtboxContactNumber.Text + "',@images)";
cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@images", images));
int N = cmd.ExecuteNonQuery();
conn.Close();
Thread.Sleep(1000);
MessageBox.Show("Data Saved Successfully!", "Profile", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
EContact eContact = new EContact();
eContact.Show();
}
}
