Insert data into sql database

Question

Hi..
I have two textboxes with submit button.
I want to insert the values entered in these textboxes into ms sql database.

I tried googling around,but i cant find any appropriate one.
Any tutorial suggestions guys?

sam · Answer

Simple step by step easy to understand tutorial : http://www.fissionit.co.uk/forum/showthread.php?p=10325

ajay raju · Answer

hi friend use this code name spaces using System.Data; using System.Data.SqlClient; code under submit button click SqlConnection cn = new SqlConnection ( user id=sa; password=123; database=emp ); string str = insert into emp values (' + TextBox1.Text +  ''  + TextBox2.Text + ') ; SqlDataAdapter da = new SqlDataAdapter (strcn); DataSet ds = new DataSet (); SqlCommandBuilder cb = new SqlCommandBuilder (da); da.Fill(ds em ); Response.Write( Record saved into Database ); If it is helps you please mark as accept answer Thanks