VB SQL Help

[Brett Baisley]

Its been a while since I used VB and I'm new to VB.net. I set up an
sqlConnection, sqlCommand and sqlDataAdapter (by dragging the controls to
the form) to query a local database. I set up a text box to display the
length of the sqldataadapter by doing this:
sqldataadapter.defaultsourcetablename.length and it returns 5 (which is
correct, there should be 5 records in there).

The query should return the ArtistName and AlbumName fields.

What I can't figure out is how to add each record to a listbox? I know its
listbox1.items.add(...) but what do I call? I want to store ArtistName in
one list box and AlbumName in the other.

Can someone finish this off for me? Thanks!

Brett

[Enforcer]

Brett,

This tutorial is great i have learnt so much from in the
past 2 weeks. I did not know anything on what i was
doing. But i have now made a full VB frontend to an SQL
database.

Good luck.

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dndotnet/html/usingadonet.asp

-----Original Message-----
Its been a while since I used VB and I'm new to VB.net. I set up ansqlConnection, sqlCommand and sqlDataAdapter (by dragging the controls tothe form) to query a local database. I set up a text box to display thelength of the sqldataadapter by doing this:
sqldataadapter.defaultsourcetablename.length and it returns 5 (which iscorrect, there should be 5 records in there).

The query should return the ArtistName and AlbumName fields.
What I can't figure out is how to add each record to a listbox? I know itslistbox1.items.add(...) but what do I call? I want to store ArtistName inone list box and AlbumName in the other.

Can someone finish this off for me? Thanks!

Brett
.

[Cor]

Hi Brett,

Did you configure the dataadapter and make afterwards a dataset?

You do that by rigthclicking on the dataadapter icoon that is situated below
in your form.

It sounds not, because I hear you not talking about the dataset and that is
used in the way you are using to get the information.

I set up an sqlConnection, sqlCommand and sqlDataAdapter (by dragging the controls >to the form) to query a local database. I set up a text box to
display thelength of the sqldataadapter by doing this:
sqldataadapter.defaultsourcetablename.length and it returns 5 (which is
correct, there should be 5 records in there).

I hope this helps you a little bit.

Cor

[Brett Baisley]

No, I don't have a dataset. I'll look into that and if I still have
problems, I'll get back to you. Thanks!

"Cor" <no*@non.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi Brett,

Did you configure the dataadapter and make afterwards a dataset?

You do that by rigthclicking on the dataadapter icoon that is situated below in your form.

It sounds not, because I hear you not talking about the dataset and that is used in the way you are using to get the information.

I set up an sqlConnection, sqlCommand and sqlDataAdapter (by dragging the

controls >to the form) to query a local database. I set up a text box to
display the

length of the sqldataadapter by doing this:
sqldataadapter.defaultsourcetablename.length and it returns 5 (which is
correct, there should be 5 records in there).

I hope this helps you a little bit.

Cor

[Brett Baisley]

I got it working with SQLDataReader. It seems to do what I need so far.
"Cor" <no*@non.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi Brett,

Did you configure the dataadapter and make afterwards a dataset?

You do that by rigthclicking on the dataadapter icoon that is situated below in your form.

It sounds not, because I hear you not talking about the dataset and that is used in the way you are using to get the information.

I set up an sqlConnection, sqlCommand and sqlDataAdapter (by dragging the

controls >to the form) to query a local database. I set up a text box to
display the

length of the sqldataadapter by doing this:
sqldataadapter.defaultsourcetablename.length and it returns 5 (which is
correct, there should be 5 records in there).

I hope this helps you a little bit.

Cor

[Cor]

Very good Brett,

But it is a totaly different approach, there are so many ways you can do
things with VB.net

Cor