Find row in datatable with specific id

Question

I have two columns in a datatable   ID  Calls     How do I find what the value of Calls is where ID   5   5 could be anynumber  its just for example  Each row has a unique ID

User · Answer

Hello just create a simple function that looks as shown below.. That returns all rows where the call parameter entered is valid or true.

 public  DataTable SearchRecords(string Col1, DataTable RecordDT_, int KeyWORD)
    {
        TempTable = RecordDT_;
        DataView DV = new DataView(TempTable);
        DV.RowFilter = string.Format(string.Format("Convert({0},'System.String')",Col1) + " LIKE '{0}'", KeyWORD);
        return DV.ToTable();
    }

and simply call it as shown below;

  DataTable RowsFound=SearchRecords("IdColumn", OriginalTable,5);

where 5 is the ID. Thanks..

User · Answer

Try avoiding unnecessary loops and go for this if needed   string SearchByColumn    ColumnName     value  DataRow   hasRows   currentDataTable Select SearchByColumn   if  hasRows Length    0          your logic goes here   else         your logic goes here     If you want to search by specific ID then there should be a primary key in a table

User · Answer

DataRow dataRow   dataTable AsEnumerable   FirstOrDefault r   gt  Convert ToInt32 r  ID       5   if  dataRow    null           code     If it is a typed DataSet   MyDatasetType MyDataTableRow dataRow   dataSet MyDataTable FirstOrDefault r   gt  r ID    5   if  dataRow    null           code

User · Answer

I could use the following code   Thanks everyone   int intID   5  DataTable Dt   MyFuctions GetData    Dt PrimaryKey   new DataColumn     Dt Columns  ID      DataRow Drw   Dt Rows Find intID   if  Drw    null  Dt Rows Remove Drw

User · Answer

Make a string criteria to search for  like this   string searchExpression    ID   5    Then use the  Select   method of the DataTable object  like this   DataRow   foundRows   YourDataTable Select searchExpression     Now you can loop through the results  like this   int numberOfCalls  bool result  foreach DataRow dr in foundRows           Get value of Calls here     result   Int32 TryParse dr  Calls    out numberOfCalls           Optionally  you can check the result of the attempted try parse here        and do something if you wish     if result                   Try parse to 32-bit integer worked            else                  Try parse to 32-bit integer failed

User · Answer

You can use LINQ to DataSet DataTable  var rows   dt AsEnumerable                   Where r  gt  r Field lt int gt   ID      5     Since each row has a unique ID  you should use Single SingleOrDefault which would throw exception if you get multiple records back    DataRow dr   dt AsEnumerable                   SingleOrDefault r  gt  r Field lt int gt   ID      5      Substitute int for the type of your ID field

User · Answer

You can try with method select  DataRow   rows   table Select  ID   7

User · Answer

try this code  DataRow foundRow   FinalDt Rows Find Value     but set at lease one primary key

[c#] Find row in datatable with specific id

Examples related to c#

Examples related to datatable

Examples related to datarow