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
}
}

How can we perform transactions in .net?

1060

---

What connected data?

962

---

How would you connect to a database by using .NET?

939

---

What are the disadvantages of using datalist?

1031

---

Which is faster ado.net or linq?

1026

---

What are the benefits of using of ADO.NET in .NET 4.0?

1072

---

What is basic use of data view?

1006

---

Explain what is datagrid with an example?

1098

---

Which ado.net object is very fast in getting data from the database?

1105

---

What is the difference between sqlcommand and sqldataadapter?

997

---

Which is faster datareader or dataadapter?

992

---

Give an example that shows how to execute a stored procedure in ado.net?

1071

---

What is ole access?

948

---

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

1055

---

Which method is used to sort the data in ADO.Net?

1978

---