Answer Posted / ranjeet kumar panda

SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;
SQlDataAdapter da;
string sqlstr;

Connection String......

//using DataReader

sqlstr="insert into tablename(Colname) values
("+textBox1.Text+")";
if(con.state==ConnectionState.Open)
con.Close();
cmd.CommandText=sqlstr;
con.Opem();
cmd.ExecuteNonQuery();

//using DataSet

.........
........
da.Fill(ds,"tablename");
DataRow drw=ds.Tables[0].NewRow();
drw[0]=textBox1.Text;
ds.Table[0].Rows.Add(drw);
SqlCommandBuilder cb=new SqlCommandBuilder(da);
da.Update(ds,"tablename");


//Using LinqToSql (.Net 3.5)

DataContextName dc=new DataContextName();
//Lets a Control to bind the data
DataGridView1.DataSource=dc.GetTable<tablename>;
//create an object of class(i.e table)
tablename obj=new tablename();
obj.colname=textBox1.Text;
dc.tablenames.InsertOnSubmit(obj);//'s' in tablenames
//is essential
dc.SubmitChanges();

What is the difference between executequery and executenonquery?

691

---

What is different between sqlcommand object and command behavior object?

717

---

What is ambient transaction?

674

---

How can we load multiple tables in a dataset?

761

---

How can I retrieve two tables of data at a time by using data reader?

697

---

Explain how do you connect to sql server database without using sqlclient?

682

---

What is namespace in ado.net?

665

---

What are the benefits of using ado.net?

696

---

Is it possible to load multiple tables in a Dataset?

728

---

How to retrieve the user id which is provided while windows authentication?

795

---

What are the different methods by which we can populate a dataset?

914

---

Is datareader faster than datatable?

699

---

What is the difference between SqlCommand and SqlCommandBuilder?

769

---

Explain the advantages and disadvantages of using datalist?

779

---

What provider ado.net use by default? Explain the role of data provider in ado.net?

716

---