Member Avatar for nesnes

just want to know how will i able to display the info description in my list view but the one that appears in the database is its id(using vb.net)

  • 2 Contributors
  • 1 Reply
  • 205 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by poojavb
Member Avatar for poojavb

just want to know how will i able to display the info description in my list view but the one that appears in the database is its id(using vb.net)

The id value must be having some description in ur table right??
if yes then use the below code. I quess it will help

'Database connection
Dim strSQL As String = "SELECT distinct ID,Name FROM TableName"
Dim da As New OleDbDataAdapter(strSQL, Connection)
Dim ds As New DataSet
da.Fill(ds, "TableName")
        With ListViewName
            .DataSource = ds.Tables("TableName")
            .DisplayMember = "Name"
            .ValueMember = "ID"
        End With
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.