find data on database table

Question

3.00/5 (2 votes)

See more:

hey friend. i have some project. i need get address to
lable when i enter name into textbox.my code is like this

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

unfortunatly its not work and i got this erro message
"invalied column name"
then i try search infomation by there age. its worked. but
i have no idea to get address when enter there names.
im using vb.net and sql server.
please help me . please

Posted 3-Feb-12 6:18am

Amal anjula

Updated 3-Feb-12 6:59am

theanil

v3

Add a Solution

Comments

Sridhar Patnayak 3-Feb-12 12:30pm

Repeated question , your answer at link http://www.codeproject.com/Questions/324507/bind-table-data-in-vb

Sridhar Patnayak 3-Feb-12 12:43pm

update your existing link

1 solution

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)

Christian Graus · Answer 1 · 2012-02-03T08:52:00

You should never do this. I'd fire anyone who wrote code like this, or asked this sort of question.

Your code makes it trivial for me to delete your database. You should never build SQL from concatenating strings.

Your variables have names like textbox1 which make it easy to get confused and are not self documenting.

Your error means what it says, you're trying to read a column that is not there.

You need to not ask the same question over and over. You need to abandon your current project, buy a beginners book and work through it.