Member Avatar for roymrinal123

How we can show data from acess database in datagrid

please help me about the code

  • 2 Contributors
  • 1 Reply
  • 82 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

>How we can show data from acess database in datagrid

First of all you need to use System.Data.OleDB provider classes to have database connection and select statement result.

Dim CnStr as String="Connnection_string_here"
Dim Sql as String="Select * from tableName"
Dim Adp as new OleDBDataAdapter(sql,CnStr)
Dim Dt as new DataTable

Adp.Fill(Dt)

DataGridView1.DataSource=Dt
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.