Improve company productivity with a Business Account.Sign Up

x
?
Solved

DataTable select method, how to select with a variable?

Posted on 2004-09-24
9
Medium Priority
?
440 Views
Last Modified: 2008-02-01
Hi,

I have a dataTable, and I would like to select a column by using the string come from my Textbox.

 Dim dt As DataTable = dsDataSet.Tables("CustomerTable")
 Dim row As DataRow = dt.Select("Name =  txtMyTextBox.Text")(0)

However it gives me error for the second line as it is a wrong expression.
I would like to know how to do it properly?

I tried:
= dt.Select("Name =  'txtMyTextBox.Text' ")(0)
= dt.Select("Name =  {txtMyTextBox.Text}")(0)
= dt.Select("Name = " & txtMyTextBox.Text)(0)

but I guess its all wrong........

Please could you tell me the correct method? Many thanks.
0
Comment
Question by:staines
  • 5
  • 4
9 Comments
 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 12140889
Sorry but dt.select doesn't return a column but a row

What are you trying to achieve exactly?
0
 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 12141042
this works though


Dim dr As DataRow = ds.Tables(0).Select("Firstname = '" textbox1.text & "'")(0)
msgbox dr.item("lastname")
0
 

Author Comment

by:staines
ID: 12144055
Thankyou for your reply.

Dim dr As DataRow = ds.Tables(0).Select("Firstname = '" textbox1.text & "'")(0)

I tried, but couldn't compile it as there is an error ,it said " Comma,')', or valid expression continuation expected" ?

perhaps i should explain abit better?

I want to get the Text from the textBox i created (called "txtMyTextBox"), and look into the dataset table called "CustomerTable", in column called "Name".

Once it found and select that row, i want it to return the item on column say "Lastname" as u did " msgbox dr.item("lastname") "

At the moment i can select the item in the column ONLY if i know what the item is called.
e.g. Dim row As DataRow = dt.Select("Name =  'John' ")(0)
but instead of John, i want the string to be pass from txtMyTextBox.Text

How to do that?

Thanks in advance.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 12144342
Hi Staines,

could you post your code

because I tested this and it worked. so maybe there is a small typo in your code

0
 

Author Comment

by:staines
ID: 12144762
Dim dr As DataRow = dsDataSet.Tables("CustomerTable").Select("Name= '" txtMyTextBox.Text & "'")(0)

There is a blue underline on "txtMyTextBox", and when u point ur mouse to the blue underline it saids "Comma,')', or valid expression continuation expected"

the rest of code is fine.
0
 
LVL 25

Accepted Solution

by:
RonaldBiemans earned 200 total points
ID: 12144833
oeps, this is correct

Dim dr As DataRow = dsDataSet.Tables("CustomerTable").Select("Name= '" & txtMyTextBox.Text & "'")(0)
0
 

Author Comment

by:staines
ID: 12144837
and also how to avoid program being crash if Select couldn't find the string from txtMyTextBox.Text ?
0
 

Author Comment

by:staines
ID: 12144858
YEP, I see. ! Thank you so much!!!!!
0
 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 12144954
just check

if isnothing(dr) then
  msgbox("not found")
else
  msgbox("found")
end if
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
An ASP.NET Web Form User Control is not newly introduced in ASP.NET. In fact, it was an old technology yet still playing a role to generate web content, especially when we want to use it to have a better and easy way to control part of the web conte…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

584 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question