Answer Posted / a.anwar sadat

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

cmd = new SqlCommand("select * from empdetails", con);

da = new SqlDataAdapter(cmd);
ds = new DataSet();
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

The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

1967

---

What is the functionality of data provider in ado.net?

867

---

What is the use of adodc?

938

---

What is row state?

924

---

Explian About DataAdapters

968

---

What is ole in excel?

897

---

What is the meaning of executenonquery?

961

---

Describe connection object in ado.net

980

---

Why do we need ado.net?

908

---

What does ado stand for in ado.net?

1002

---

What are the ado.net connection pooling parameters?

905

---

Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

959

---

Explain the difference between sqlcommand object and command behavior object?

1007

---

Which database is the ado.net?

914

---

What is serialization and de-serialization in .net?

877

---