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

What is DataReader Object?

1016

---

What are the uses of Stored Procedure?

1052

---

Which is faster entity framework or ado.net?

916

---

What is difference between sqldatareader and sqldataadapter?

919

---

How to check if the Dataset has records ?

982

---

what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

996

---

What is namespace in ado.net?

994

---

Define bubbled event?

905

---

How can we load multiple tables in a dataset?

1158

---

Is bulk insert faster than insert?

890

---

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

1048

---

What is ado and rdo?

888

---

What is acid in ado.net?

1005

---

Define ado.net?

1080

---

What is disconnected data?

1024

---