Hi Guys,

I want to know if there is any way to fetch a specific ROW from a DataSet(the DataSet has only one table).I am coding in c#.

Thanks and Regards,
Jhansi

__________________
Thanks and Regards,
Jhansi

Hi Jhansi,

You can use this perticular code

string var_Name = DS.Tables["DATASET_NAME"].Rows[0]["COLUMN_NAME"].ToString()

I hope this will work out for you

Well how do you know which row you need? If it's the sixth row for example then: --

Joe (Microsoft MVP - XML)

Thank u for ur immediate response...

But I want to fetch an entire row basing on a unique id...

Thanks and Regards,
Jhansi

You have a few options if you intend to locate the row outside of SQL.

//This will return an array of rows
RowArray myRowArray = dataset.Select("some_value = " + uniqueValue);

You could also use a dataview:
DataView view = new DataView(dataset.Tables[<table>]);
view.RowFilter = "some_value = " + uniqueValue;

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

Hi,

Ya...I used the RowFilter...I get only one row as the result...but then I am not able to move this Filtered Row into a DataRow....
Pls help..........


Thanks and Regards,
Jhansi

Hi,

I found the way out....

I could get the filtered row with

                view[0].row["ColumnName"]



Thanks and Regards,
Jhansi