Killsoft Sugdok

how to view record in ms access using vb.net

Go down

how to view record in ms access using vb.net

Post by putayputay on Mon Mar 11, 2013 6:54 am

try
Dim SqlQuery As String = "SELECT * FROM FullNameTable"
Dim SqlCommand As New OleDbCommand
Dim SqlAdpter As New OleDbDataAdapter
Dim TABLE As New DataTable

With SqlCommand
.CommandText = SqlQuery
.Connection = conn
End With

With SqlAdpter
.SelectCommand = SqlCommand
.Fill(TABLE)
End With

For i = 0 To TABLE.Rows.Count - 1
With ListView1
.Items.Add(TABLE.Rows(i)("ID"))
With .Items(.Items.Count - 1).SubItems
.Add(TABLE.Rows(i)("FirstName"))
.Add(TABLE.Rows(i)("MiddleName"))
.Add(TABLE.Rows(i)("LastName"))
End With
End With
Next
Catch ex As Exception
MsgBox(ex.Message)
End Try

putayputay
Newbie
Newbie

Posts : 10
Join date : 2013-03-09

Back to top Go down

Re: how to view record in ms access using vb.net

Post by Admin on Mon Mar 11, 2013 7:14 am

Nice Share TS....

[You must be registered and logged in to see this image.]
avatar
Admin
Admin
Admin

Posts : 14
Join date : 2013-03-09

http://killsoft.1talk.net

Back to top Go down

Re: how to view record in ms access using vb.net

Post by fredo2503 on Fri Mar 22, 2013 7:52 am

can you post the search code ? Very Happy

fredo2503
Newbie
Newbie

Posts : 1
Join date : 2013-03-22

Back to top Go down

Re: how to view record in ms access using vb.net

Post by putayputay on Sat Mar 23, 2013 2:17 pm

fredo2503 wrote:can you post the search code ? Very Happy
this is also the code for searching record

putayputay
Newbie
Newbie

Posts : 10
Join date : 2013-03-09

Back to top Go down

Re: how to view record in ms access using vb.net

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum