First Post:
Populating DataGridView using MSAccess Database
Shown in 3ways
-using Dataset
-using DataReader
-binding the DataGridView to a dataset
Important points to learn:
OleDBConnection
OleDBCommand
OleDBAdapter
Dataset
DataReader
DataTable
Using My.Settings to save the database path
Program will search for the database if not found;
Sample code has comments as to how it is done
Post further questions if necessary:
Basic Steps:
Create a project:
Add a form:
Add this to the forms top most code
"Imports System.Data.OleDb"
Add the DataGridView
For non databound grid,
add the necessary columns using the datagridview designer (when selected; click the [>] button on the top rigth of the grid)
Follow the code provided
the file
ericVBNETAccess.rar
contains the design for the application series i wanted to construct for this thread
you will notice, walang pop windows, nasa tab page lang ang forms.
stay tuned to know how it is done.
UPDATED! - loading data into listview.
Updated SQL Server Sample
http://www.symbianize.com/attachment.php?attachmentid=369167&stc=1&d=1310119089
check also thee links
http://www.symbianize.com/showpost.php?p=8292447&postcount=2560
http://www.symbianize.com/showpost.php?p=8292571&postcount=2561
http://www.symbianize.com/showpost.php?p=8292709&postcount=2562