Click here to Skip to main content
15,914,165 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionCursor position [modified] Pin
Jamal Abdul Nasir28-Apr-08 2:05
Jamal Abdul Nasir28-Apr-08 2:05 
GeneralRe: Cursor position Pin
John_Adams28-Apr-08 3:06
John_Adams28-Apr-08 3:06 
GeneralRe: Cursor position Pin
Luc Pattyn28-Apr-08 3:09
sitebuilderLuc Pattyn28-Apr-08 3:09 
GeneralTreeview control problem Pin
monafr8128-Apr-08 1:59
monafr8128-Apr-08 1:59 
QuestionDetecting prerequisites...! Pin
Jamal Abdul Nasir28-Apr-08 1:15
Jamal Abdul Nasir28-Apr-08 1:15 
GeneralRe: Detecting prerequisites...! Pin
Kschuler28-Apr-08 9:51
Kschuler28-Apr-08 9:51 
GeneralUnable to Capture Incoming Mail Event in Outlook Pin
narayanagvs28-Apr-08 0:07
narayanagvs28-Apr-08 0:07 
GeneralDataview and text binding help required. Pin
mickstar28-Apr-08 0:07
mickstar28-Apr-08 0:07 
Hi Experts,

I need help with a databinding in a text box, which draws a column from a dataview.

the sql statement used for the dataview is:

SELECT ArtistID, SUM(Popularity) from ArtistPopularity WHERE NOW >= PeriodStart AND NOW <= PeriodEnd GROUP BY ArtistID

The dataview is row filtered by artist id. The artist id can be selected through a combobox.

The crux of the issue is that not all artists will have a popularity, so this means there will be null values for some artists. So when you scroll through the artist id's in the combobox, only ones with popularities should come up in the dataview.

First i got an indexoutofrange exception, stating that there is no row at positiong 2, this is down to the fact that position 2 in the dataview does not have a value so i caught the exception like so:

Try

TextBox13.Text = oArtistPopularity3DT.Rows(TextBox1.Text).Item("Popularity")

Catch ex As Exception
End Try

But now the problem i face, is that the textbox does not update to the values inside of the datview now. It just remains the same as the last value, before it catches the index out of range.

How do i make it show the value in the textbox, when there is a value in the dataview.


Any help is much appreciated

thanks.
QuestionHelp with Crystal Reports Pin
Jats_4ru27-Apr-08 23:43
Jats_4ru27-Apr-08 23:43 
GeneralRe: Help with Crystal Reports Pin
Ariel Kazeed27-Apr-08 23:54
Ariel Kazeed27-Apr-08 23:54 
GeneralRe: Help with Crystal Reports Pin
Jats_4ru28-Apr-08 0:14
Jats_4ru28-Apr-08 0:14 
GeneralCrystal Report and visual basic Pin
monika_vasvani27-Apr-08 23:37
monika_vasvani27-Apr-08 23:37 
AnswerRe: Crystal Report and visual basic Pin
Smithers-Jones27-Apr-08 23:45
Smithers-Jones27-Apr-08 23:45 
AnswerRe: Crystal Report and visual basic Pin
Jamal Abdul Nasir28-Apr-08 4:06
Jamal Abdul Nasir28-Apr-08 4:06 
QuestionChange value of datagridview Pin
peterjc27-Apr-08 22:58
peterjc27-Apr-08 22:58 
GeneralRe: Change value of datagridview Pin
ilprincipe27-Apr-08 23:47
ilprincipe27-Apr-08 23:47 
QuestionRe: Change value of datagridview Pin
peterjc28-Apr-08 14:23
peterjc28-Apr-08 14:23 
AnswerRe: Change value of datagridview [modified] Pin
Jamal Abdul Nasir28-Apr-08 1:19
Jamal Abdul Nasir28-Apr-08 1:19 
GeneralNetwork broadcasting Pin
quark_cyber27-Apr-08 21:51
quark_cyber27-Apr-08 21:51 
GeneralRe: Network broadcasting Pin
Rajesh Anuhya27-Apr-08 22:03
professionalRajesh Anuhya27-Apr-08 22:03 
QuestionCreate PDF file in VB.NET? [modified] Pin
Jats_4ru27-Apr-08 19:58
Jats_4ru27-Apr-08 19:58 
GeneralRe: Create PDF file in VB.NET? Pin
Christian Graus27-Apr-08 21:07
protectorChristian Graus27-Apr-08 21:07 
QuestionScreen resolution changed Pin
Mohammad Al Hoss27-Apr-08 19:52
Mohammad Al Hoss27-Apr-08 19:52 
GeneralRe: Screen resolution changed Pin
MidwestLimey27-Apr-08 20:25
professionalMidwestLimey27-Apr-08 20:25 
GeneralRe: Screen resolution changed Pin
Mohammad Al Hoss27-Apr-08 20:41
Mohammad Al Hoss27-Apr-08 20:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.