Insert values to SQL Database using c# windows application
Check below Submit button code...........................
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("YOUR CONNECTION SET HERE");
con.Open();
SqlDataAdapter da = new SqlDataAdapter("insert into empdetails(empid, empname, empdept, empsalary)values('"+txtId.Text+"','"+txtName.Text+"','"+txtDep.Text+"','"+txtSalary.Text+"')",con);
DataSet ds = new DataSet();
da.Fill(ds);
MessageBox.Show("Record insert successful.....!");
txtName.Text="";
txtDep.Text="";
txtSalary.Text="";
}
0 comments:
Post a Comment