Visual Basic

9-Jul-07 12:27

Hi,

I am trying to insert selected items from a listbox into a label, the listbox is fillby a database query, the problem is all I get is this System.Data.DataRowView it works fine when I dont use a database query and just text in the listbox, but need to use a database query.

Can anyone help on a solution for this??

Dim i As Integer<br />
For i = 0 To ListBoxUpgrade.Items.Count - 1<br />
If ListBoxUpgrade.Items(i) Then<br />
LabelSum.Text = LabelSum.Text & Space(6) & ListBoxUpgrade.SelectedItem(i) & vbCrLf<br />
End If<br />
Next i

Thanks in advance!
Stefan.

"All answers have a question? All code has an end."

Luc Pattyn9-Jul-07 12:38

9-Jul-07 12:38

smguc wrote:
ListBoxUpgrade.SelectedItem(i)

try ListBoxUpgrade.SelectedItem(i).Text instead

without .Text the ToString() method gets called, which by default returns a string
naming the type.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

smguc9-Jul-07 12:58

9-Jul-07 12:58

Hi Luc,

Thanks for that, but doesn't accept the .text after the ListBoxUpgrade.SelectedItem(i) so frustrading it works in 'VB6' which is where I have upgraded from to 'VB2005' all because of 'Vista', many different rules and changes.

What I am trying to achieve, is there is a list of items in a listbox which you can multi select and from there show only those selected items in a label as a summary 'like a report'.

Any more suggestions would be much appreciated!

Thanks,

Stefan.

"All answers have a question? All code has an end."

Luc Pattyn9-Jul-07 13:13

9-Jul-07 13:13

I missed that you missed an 's'

try ListBoxUpgrade.SelectedItems(i).Text instead

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

smguc9-Jul-07 13:27

9-Jul-07 13:27

Hmmm...

No still no luck! Doesn't like the .text after it.
Sometimes makes me think I should go back to VB6, haha. Was like my second lanugage!

This is the code for VB6, which works fine the only difference is that the 'i' was declare as a variant, but VB2005 wants it as a object, which didn't work so changed it to a Integer.

<br />
Dim i As Variant<br />
      For i = 0 To ListBoxUpgrade.ListCount - 1<br />
        If ListBoxUpgrade.Selected(i) Then<br />
           LabelSum = LabelSum & Space(6) & ListBoxUpgrade.List(i, 3) & vbCrLf<br />
        End If<br />
      Next i

Do you have any more ideas or a better way to write the code??
Or go back to VB6... lol

Thanks,
Stefan.

"All answers have a question? All code has an end."

Luc Pattyn9-Jul-07 13:32

9-Jul-07 13:32

Dont go back to VB6, if anything show your current VB.NET code here.
And tell exactly what the current result is and what it should be.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

TwoFaced9-Jul-07 13:38

TwoFaced

9-Jul-07 13:38

The listbox contains objects which could be anything. ListBoxUpgrade.SelectedItem(i) will return whatever text the ToString method returns. For most objects this is the type of object it is. Because you've bound your listview you actually have a listview full of DataRowView objects. This is why the ToString method is returning System.Data.DataRowView. If you want to get the corresponding text of the item (the text being displayed in the listbox) you can use the GetItemText method.

For Each obj As Object In ListBox1.SelectedItems
    Console.WriteLine(ListBox1.GetItemText(obj))
Next

Luc Pattyn9-Jul-07 13:41

9-Jul-07 13:41

Hi, that looks great. Never knew VB code could look so clean.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

smguc9-Jul-07 13:56

9-Jul-07 13:56

Excellent!

Thank you very much!

You would not believe the amount of books I have, and read that doesn't even state the 'GetItemText' method, Have only just made the transistion in VB2005 a few weeks now.

Great help!

Thanks again. Smile | :)

Stefan.

"All answers have a question? All code has an end."

Loading sql record into a variable

TwoFaced9-Jul-07 14:00

TwoFaced

9-Jul-07 14:00

That's what IntelliSense is for Smile | :)

Also the MSDN library is a big help.

tazbird9-Jul-07 11:28

tazbird

9-Jul-07 11:28

Hi all!

I'm sure there’s a commonly well known way to do this, but after days of googling and googling I can't seem to find a procedure.

I have an application the works with a SQL database, I want it to work with the data in a specific field, and then return that value to the database.

Where I'm stuck is that I can't figure out how to set a variable = to the data in a specific field.

Can someone please outline what I need to do, or point me to a specific tutorial?

Thanks for any help!

--Derek

Luc Pattyn9-Jul-07 11:52

9-Jul-07 11:52

instead of googling for days, spend a couple of hours reading some of the
excellent articles here on CodeProject (I am not saying they are all
excellent, but there are some bloody good ones !). There is a search facility
at the top of most pages on CodeProject.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

MidwestLimey9-Jul-07 12:49

MidwestLimey

9-Jul-07 12:49

I think you forgot something ...

finally { appropriateForum.Post(message); }

I'm largely language agnostic  
     After a while they all bug me  

Luc Pattyn9-Jul-07 13:09

9-Jul-07 13:09

no no, finally block gets executed no matter what, and that is not required once
you found a solution somewhere.

Furthermore it would exceed the allowed 500 char maximum for a sig.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

MidwestLimey10-Jul-07 4:45

MidwestLimey

10-Jul-07 4:45

I realised the second I posted it. Shame, in english it sounds good. C# not so much.

I'm largely language agnostic  
     After a while they all bug me  

MidwestLimey9-Jul-07 12:51

MidwestLimey

9-Jul-07 12:51

Well, strickly speaking it shouldn't be finally but I had a geek attack. End of the day.

I'm largely language agnostic  
     After a while they all bug me  

tazbird9-Jul-07 13:58

tazbird

9-Jul-07 13:58

I appericate your reply, but I don't ask questions on formums unless I've done my research

Luc Pattyn9-Jul-07 14:53

9-Jul-07 14:53

Hi,

I did not intend to offend you, but so many questions seem to be asked because
asking looks simpler than searching...

I am not a database programmer (nor fluent in VB), this is a pattern (in C#) that
I encountered in many articles and discussions (I do read a lot of them):

for a DataSet ds the j-th field in row i can be accessed (read/written) by
ds.Tables["tableName"].Rows[i].ItemArray[j]

I am confident you know how to translate it to VB syntax.

I have never used it, but I do hope this helps. If not, maybe you should
post a new question, this time in the SQL/ADO.NET forum ...

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }