bind table data in vb

Question

0.00/5 (No votes)

See more:

I need get address to lable when I enter name into textbox. My code is like this

VB

ds.clear
da=new sqldataadapter("SELECT * FROM members WHERE name=" & textbox1.text &"", dbconn)
try
da.fill(ds,"members")
bind()
catch ex as exception
exit sub
end try

sub bind()
lable1.databindings.add("text",ds,"members.memname")
end sub

Unfortunately its not working. Otherwise I can't see eny errors.

Then i try search infomation by there age. its worked. but I have no idea to get address when emter there names.
im using vb.net and sql server.

Posted 3-Feb-12 2:50am

Amal anjula

Updated 3-Feb-12 5:36am

Chris Maunder773.6K

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Simon_Whale · Answer 1 · 2012-02-03T04:38:00

Couple of things!

1. Look at parameterised Queries it will protect you against SQL Injection

Read / Example : SQL Parameterised query example[^]

2. you have a Try Catch block, but you just exit the sub! as others have stated you need to, if any errors are trapped do something with the error.

3. Have a try of this

VB

 dim dt as Datatable = ds.table(0)
 dim dr as Datarow = dt.rows(0)

'I have assumed that the values you are after are in column 1, it is considered better practice to replace the ordinal number with its name
 Label1.text = dr(0).toString()

Raimis9 · Answer 2 · 2012-02-03T03:00:00

Solution 2

Put the code and you will see the error ;)

VB

catch ex as exception
messagebox.show(ex.message)
end try

Posted 3-Feb-12 3:00am

Raimis9

v2