i need to insert data into sql server table emp through textboxes txtname and t

i need to insert data into sql server table emp through
textboxes txtname and txtsalary using c# code. Please help

Question Posted / crprajan

1 Answers
4264 Views
I also Faced
E-Mail Answers

i need to insert data into sql server table emp through textboxes txtname and txtsalary using c# co..

Answer / suresh

open the Sqlconnection and write the connection string dere
and take one sqldata Adapter and also take one datatable
write the following code.

sqlconnection con=new sqlconnection("server=.; user Id=sa;
Password=sa123; Database=emp");
sqlDataAdapter da;
DataTable dt;

In Button Click Event you write this code

da=new sqlDataAdapter("insert into Emp(EmpID,Ename) values
('"+textbox1.Text+"','"+textbox2.Text+"'",con);
dt=new DataTable();
da.Fill(dt);

That's it you entered the Data into SQL Server

Is This Answer Correct ?

5 Yes

1 No

Post New Answer