phattrienweb

Asp.net

var persons = new DataTable();
 
string lastName = string.Empty;
 
DataRow[] foundRows = persons.Select("Person_Id = 100");
if (foundRows.Length == 1)
{
    lastName = foundRows[0]["Last_Name"].ToString();
}

        
public static T GetFirstResultValue(DataTable table,string colToSearch, string colToReturn, TY searchValue) where TY: IComparable
{
    T ret = default(T);
 
    IEnumerable rows = from row in table.AsEnumerable()
                                        where row.Field(colToSearch).CompareTo(searchValue) == 0
                                        select row;
 
    if (rows.Count() == 1)
    {
        ret = (T) rows.First()[colToReturn];
    }
 
    return ret;
}