What is your database SQL Server, or MS Access, etc
- How much do you know of Sql & Ole connection objects, and datasets.
- Use Sql objects for SQL Server and Ole Objects for MS Access & others.
Typical script (Sql Server): (Connect, open and fills dataset)
dim dsSql as new DataSet("My Data")
dim sqlConn as new SqlConnection("user id=yourid;password=yourpwd;initial catalog=yourdatabase;data source=yourSQLServername")
dsSql.Tables.Add("MyTable") 'Add a new table
sqlConn.Open() 'opens your connection
dim sqlCmd as string="SELECT * FROM YourTable"
dim daSql as new SqlDataAdapter(cmdSql,sqlConn)
daSql.Fill(dsSql.Tables("MyTable")
sqlConn.Close() 'close connection ..if no more work
Now your table is filled into 'MyTable' datatable in your dataset.
Access your data by acessing your datatable, if you don't know how, look at the help doc or MSDN at
www.msdn.microsoft.com
Use OleDataConnetion and OleDataAdapter, you need to find out the connection string as it is different from Sql Server, seach on 'ConnectionString' in help doc or MSDN.
You can d/l ODBC.Net from MSDN and use ODBC instead for both.
Hope I am being help to you, good luck..
Kasie