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