Re: Why can't i find a row in a dataset?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paul Custance (paul_at_sendmeanemail.net)
Date: 03/17/05 

Date: Thu, 17 Mar 2005 16:04:58 +0000

OK I feel like a total idiot now, I stared at it that long that I couldn't see that I had made such a silly mistake!

Cheers VJ much appreciated

Paul Custance

VJ wrote:
> See below
>
> "Paul Custance" <paul@sendmeanemail.net> wrote in message
> news:%23A6O2gwKFHA.4092@tk2msftngp13.phx.gbl...
>
>>Hi,
>>
>>Currently had a Dataset that has information from the Northwind database,
>>Customers table in it.
>>
>>I have created my update and select commands and they work fine.
>>
>>When I go to update a row in the data set I use this
>>
>>//Get the datarow to edit
>>DataRow[] adrEdit = ds.Tables["Customers"].Select("CustomerID =
>>'txtCustomerID.Text'");
>
>
> - Replace with
>
> DataRow[] adrEdit = ds.Tables["Customers"].Select("CustomerID = '" +
> txtCustomerID.Text + "'");
>
>
>
>>However this returns nothing, but if I do it explicitly like this
>>
>>//Get the datarow to edit
>>DataRow[] adrEdit = ds.Tables["Customers"].Select("CustomerID = 'ALFKI'");
>>
>>It works fine, why when I enter ALFKI in txtCustomerID.Text is it not
>>making a match in the Dataset?
>>
>>any help appreciated
>>
>>Paul Custance
>
>
>