Public cnn2 As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TSA-RMS\TSA-RMS\database\tsaDb.mdb") Public acc As String Public da As New OleDb.OleDbDataAdapter Public objcommand As New OleDb.OleDbCommand Public ds As New DataSet Public temp As String
Database : MS Access
Database Name : tsaDB.mdb
Table Name : dailyIncome
Datagrid Name : dgvDailyInc
Can you give me a sample?
By the way. How am I going to make my program locate the database even I transfer my database on other drives? I am having a hard time debugging the program after transferring my program to laptop. Database error always occur after transferring.
This post has been edited by k3nnt0ter0: 10 October 2011 - 10:27 PM