Easy Steps to Insert Data into SQL Server using ASP.Net(c#)

Try{ SqlConnection con=new SqlConnection();con.ConnectionString=ConfigurationManager.ConnectionStrings['con1'].ToString();SqlDataAdapter adp=new SqlCommand("insert into abc (name,fname) values('" + TextBox1.Text + "','" + TextBox1.Text + "')", con);label1.Text="inserted successfully';}catch(Exception e1) Label1.Text=e1.Message();}

Thanks but I got an error "the name 'textbox id'does not exist in the current context"

thanks

you can save your connection string in web.config file . so you can use it on any page without writing it again and again.and one more advantage is that when you have to change conection string, go to web config file and change it there only. otherwise you have to change it gain and again

thank u

i got with this ok,

Connection String="data source=WEBDEV1-PC; Initial Catalog=srinu ; user Id=sa; password=pftec;"

protected void btn_save(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=WEBDEV1-PC;Initial Catalog=srinu;User Id=sa;Password=Pftec"); SqlCommand cmd = new SqlCommand("insert into Test12213 values('" textBox1.Text "','" textBox2.Text "')", con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }