Click here to Skip to main content
15,903,201 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: how can you open an internet explorer browser? Pin
jedskie_a14-Feb-05 22:44
jedskie_a14-Feb-05 22:44 
GeneralRe: how can you open an internet explorer browser? Pin
Dave Kreskowiak15-Feb-05 4:14
mveDave Kreskowiak15-Feb-05 4:14 
GeneralRe: how can you open an internet explorer browser? Pin
Christian Graus15-Feb-05 9:26
protectorChristian Graus15-Feb-05 9:26 
GeneralRe: how can you open an internet explorer browser? Pin
jedskie_a15-Feb-05 18:10
jedskie_a15-Feb-05 18:10 
GeneralRe: how can you open an internet explorer browser? Pin
rwestgraham16-Feb-05 12:32
rwestgraham16-Feb-05 12:32 
GeneralRe: how can you open an internet explorer browser? Pin
rwestgraham15-Feb-05 12:41
rwestgraham15-Feb-05 12:41 
GeneralScripting Resource File Development Pin
SQL2kGuy14-Feb-05 9:42
SQL2kGuy14-Feb-05 9:42 
Generalnull field into Listview Pin
Jaydeanster14-Feb-05 8:24
Jaydeanster14-Feb-05 8:24 
Hello all,

How do I supplement the code below so that when a subitem is null from the database, the field in the listview is populated with a string; such as "n/a"?

There will be occasions when a field(s) corresponding to a subitem(s) might be null.

/////////////////////
Public Sub FillListView()

Dim fieldCtr As Short
Dim rdlv As SqlDataReader

rdlv = sqlCmd.ExecuteReader

Do While rdlv.Read
lvItems = New ListViewItem
lvItems.Text = Trim(rdlv(0))

For fieldCtr = 1 To rdlv.FieldCount() - 1
If rdlv.IsDBNull(fieldCtr) Then
lvitems.SubItems.Add("")
Else
lvitems.SubItems.Add(rdlv.GetString(1))
lvitems.SubItems.Add(rdlv.GetString(2))
lvitems.SubItems.Add(rdlv.GetString(3))
lvitems.SubItems.Add(rdlv.GetString(4))
lvitems.SubItems.Add(rdlv.GetString(5))
lvitems.SubItems.Add(rdlv.GetString(6))
lvitems.SubItems.Add(rdlv.GetDateTime(7))
'lvItems.SubItems.Add(rdlv.GetDateTime(8))
End If

Next fieldCtr

Me.lvSearchProperty.Items.Add(lvItems)

Loop

Me.btnSubmit.Enabled = False

End Sub
////////////////

Thanks a bunch,

Jaydeanster

Ben, is that you?
GeneralChanging Backcolor of Tabcontrol Pin
OneBad34714-Feb-05 8:15
OneBad34714-Feb-05 8:15 
GeneralRe: Changing Backcolor of Tabcontrol Pin
Dave Kreskowiak15-Feb-05 3:53
mveDave Kreskowiak15-Feb-05 3:53 
GeneralCannot create a child list for field property Pin
Jaydeanster14-Feb-05 7:51
Jaydeanster14-Feb-05 7:51 
GeneralRe: Cannot create a child list for field property Pin
Virus Detecter14-Feb-05 20:01
Virus Detecter14-Feb-05 20:01 
GeneralRe: Cannot create a child list for field property Pin
Anonymous15-Feb-05 5:46
Anonymous15-Feb-05 5:46 
QuestionHow To Send Images Over a Network Pin
saber_sri14-Feb-05 7:23
saber_sri14-Feb-05 7:23 
AnswerRe: How To Send Images Over a Network Pin
Virus Detecter14-Feb-05 20:12
Virus Detecter14-Feb-05 20:12 
GeneralRe: How To Send Images Over a Network Pin
Gavin Jeffrey15-Feb-05 4:55
Gavin Jeffrey15-Feb-05 4:55 
GeneralRe: How To Send Images Over a Network Pin
Virus Detecter15-Feb-05 20:01
Virus Detecter15-Feb-05 20:01 
Generalproblem in vcd cutter software Pin
mm_chanakaya14-Feb-05 6:55
mm_chanakaya14-Feb-05 6:55 
GeneralRe: problem in vcd cutter software Pin
Dave Kreskowiak14-Feb-05 7:09
mveDave Kreskowiak14-Feb-05 7:09 
GeneralRe: problem in vcd cutter software Pin
mm_chanakaya14-Feb-05 7:54
mm_chanakaya14-Feb-05 7:54 
Generallittle problem with strings Pin
Stephan Wright14-Feb-05 6:39
Stephan Wright14-Feb-05 6:39 
GeneralRe: little problem with strings Pin
rwestgraham14-Feb-05 12:05
rwestgraham14-Feb-05 12:05 
GeneralRe: little problem with strings Pin
Stephan Wright14-Feb-05 21:08
Stephan Wright14-Feb-05 21:08 
GeneralRe: little problem with strings Pin
rwestgraham15-Feb-05 13:02
rwestgraham15-Feb-05 13:02 
GeneralRe: little problem with strings Pin
Stephan Wright15-Feb-05 21:04
Stephan Wright15-Feb-05 21:04 

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.