Finding a DataRow

Question

Hi everybody!! I want to know how to find a specific Row of a Table from a value. e.g. I've the string value of myStringValue how to know which row (RowIndex) of myTable is having myStringValue in Column1? I there a simple method for this? Any Idea? Can somebody helps me? Thanx in advance. Carlos

Carlos Sanchez · Answer

Ok thank you very much.

p.jones · Answer

Start by specifying why you need to know the DataRow's position in the DataTable's collection of DataRows. It may be there is a better design solution to the functional requirement. If you use Visual Studio -> Help -> Search -> DataRow members you'll see what can be done with a DataRow object ditto for DataTable and it doesn't seem that you can get a property that is the position of the DataRow in the DataTable's collection thereof.

Carlos Sanchez · Answer

Sorry my question wasn't so clear. I want to know the Index Row inside the DataTable. I want to retreieve an int value. Is this possible? Thanx.

mkvisaka · Answer

Hi You can use the 'Select' Method of the datatable.