>>>Hi,
>>>
>>>I have ASP.NET Grid View on ASPX page bound to a dataset/table. I need to find a value of one column by the value of another column. For example, say Grid View has columns Order_no and Customer_Name. I have the customer name "ABC" and need to find the Order_no corresponding to this Customer; basically find this row. I found examples online of scanning through the Grid View. Is this the only approach? Or you can actually Search for the desired row?
>>>
>>>TIA
>>
>>You can SELECT :-)
>
>You mean from the DB? Or how to use SELECT in the ASP.NET Grid View?
No, from DataTable :-)
Something like:
DataRow[] drws = DataTable.Select(...);
if(drws.Length==0)
{
}
I'm sure that there is LINQ way to do this.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.