Pages

Tuesday 3 January 2012

How to insert values into sql server database in asp.net?


SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\myData.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlCommand cmd = new SqlCommand("insert into tblMyTable(fldEmpId,fldName,fldAddress)values('" + txtEmpId.Text + "','" + txtName.Text + "','" + txtAddress.Text + "')");
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();

2 comments:

  1. Good article

    We can also submit our .net related article link on http://www.dotnettechy.com to increase the website traffic

    ReplyDelete