Re: Why can't i find a row in a dataset?
From: VJ (vijaybalki_at_yahoo.com)
Date: 03/17/05
- Next message: Alvin Bruney [ASP.NET MVP]: "Re: Why can't i find a row in a dataset?"
- Previous message: Paul Custance: "Why can't i find a row in a dataset?"
- In reply to: Paul Custance: "Why can't i find a row in a dataset?"
- Next in thread: Paul Custance: "Re: Why can't i find a row in a dataset?"
- Reply: Paul Custance: "Re: Why can't i find a row in a dataset?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 17 Mar 2005 09:47:32 -0600
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
- Next message: Alvin Bruney [ASP.NET MVP]: "Re: Why can't i find a row in a dataset?"
- Previous message: Paul Custance: "Why can't i find a row in a dataset?"
- In reply to: Paul Custance: "Why can't i find a row in a dataset?"
- Next in thread: Paul Custance: "Re: Why can't i find a row in a dataset?"
- Reply: Paul Custance: "Re: Why can't i find a row in a dataset?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|