i want 2 pass values(enterd in textbox)to table in sql
server without using stored procedure in c#.plz tell me
code with an example.
- 5 Answers
- 13704 Views
- Softcon, Tecra, I also Faced
- E-Mail Answers
Answer Posted / sandeep singh shekhawat
Solution1:
SqlConnection con=new SqlConnection("Data Source=./SqlExpress;Database=Test;Integrated Security= true;")
SqlDataAdapter adp=new SqlDataAdapter("insert into employee values(@Id,@Name)",con);
dap.SelectCommand.Parameters.AddwithValue("@Id",TextBox1.Text);
dap.SelectCommand.Parameters.AddWithValue("@Name",TextBox2.Text);
for this sql Connection define globally and after that all code write on button click event.
Solution2
SqlConnection con=new SqlConnection("Data Source=./SqlExpress;Database=Test;Integrated Security= true;")
SqlCommand cmd=new SqlCommand("insert into emp values(@Id,@Name)",con)
cmd.Parameter.AddWithValue("@Id",TextBox1.Text);
cmd.Parameter.AddwithValue("@Name",TextBox2.Text);
if(con.State==ConnectionState.Closed)
con.Open();
cmd.ExecuteNonQuery();
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are the core objects of ADO.NET?
What are the parameters that control most of connection pooling behaviours?
Explain the architecture of ado.net?
What is ado code?
Explain the two fundamental objects in ado.net?
What is disconnected scenario in entity framework?
What do you know about ado.net's methods?
Can we load multiple tables in a dataset?
What is ado and dao?
What is difference between executenonquery and executequery?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What is difference between dataset and datatable?
describe the dataset object in ado.net.
What is fill method in ado.net?
Which database is the ado.net sql connection object designed for?
