Answer Posted / kamalakannan.a

I think the above answer is correct.Another one method is

DataTable dt=new DataTable();
DataRow[] dr=dt.Select("Filter Expression","Sort
expression");

Here Sort expression is , for eg.Address is one of the
field in dt.

Then DataRow[] dr=dt.Select("","Address ASC");

But in this method is have the Datarow array.So you can use
another one method,I explain below.

DataView dv=new DataView(Datatable,Filter Exp,Sort
Exp,Dataviewrowstate)


Eg is

DataView dv=new DataView(dt,"","Address
ASC,DataViewVowState.CurrentRows);


Here we can copy this Dataview to datatable or use this
same dataview instead of datatable.

Kamal....

Does executenonquery return a value?

958

---

How can we perform transactions in .net?

1061

---

Define partial class?

979

---

What is a string variable?

920

---

differance between ADO vs ADO.Net?

1065

---

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

1016

---

how Sequence to connect and retrieve data from database using dataset?

1296

---

How to pass values into a datatable?

1141

---

How to connect and retrieve data from database using dataset

1057

---

What is difference between entity framework and ado.net?

931

---

Is ado.net dead?

1015

---

What are the advantages of oledb compared with other classes?

2797

---

What is ado.net in vb net?

927

---

What is ado oledb and odbc?

945

---

Does ado.net use odbc?

956

---