Answer Posted / reply2anwar

public SqlConnection con = new SqlConnection("server=anwar;uid=sa; pwd=s;database=Employee;");
public SqlCommand cmd;
public SqlDataAdapter da;

private void RetriveData()
{
cmd = new SqlCommand("select * from empdetails", con)
DataSet ds = new DataSet();
using(da = new SqlDataAdapter(cmd))
{

da.Fill(ds, "empdetails");
foreach(DataRow dr in ds.Tables["empdetails"].Rows)
{
txtempname.Text = dr["name"].ToString();
txtdob.Text = dr["dob"].ToString();
txtstreetname.Text = dr["street"].ToString();
} // foreach
}
}

Does dapper use ado.net?

1071

---

What are two important objects of ADO.Net?

1061

---

What is the use of SqlCommandBuilder?

1251

---

What is Data Provider?

1091

---

Define isolation?

1021

---

What is the difference in record set and dataset?

1065

---

How to load multiple tables into a dataset?

1120

---

What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1105

---

Explain the namespaces in which .net has the data functionality class.

1152

---

How does entity framework work?

968

---

What is fill method in ado.net?

1028

---

How can we load multiple tables in a dataset?

1236

---

What is difference between connected and disconnected architecture in ado.net?

1201

---

What are the differences between OLEDB and SQLClient Providers?

1240

---

What is a string variable?

974

---