Read Access DB

[Smile]

hi
any one can tell me how can i Read Access Data base Using C#.net
windows
which refrence i hav to use , ConnectionString , reader
and all
actualy i want to append DAta from Access (Pickup.mdb) File to SQL
SERVER
i dont know how can i connect to access db through C#.net
Help me out
Regards
Smile

[Bindas]

h

[M_Lahlouh]

using System.Data.OleDb;
using System.Data;

private System.Data.OleDb.OleDbConnection dbconnection;
private OleDbCommand command;
String databaseConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\\ffa.mdb;Persist Security Info=False";

dbconnection = new OleDbConnection(databaseConnection);
dbconnection.Open();
public DataSet GetEmp()
{
dbconnection = new OleDbConnection(databaseConnection);
dbconnection.Open();
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM emp",
databaseConnection);
DataSet ds = new DataSet();
da.Fill(ds, "emp");

return ds;
}

[shayhk]

Hi

using System.Data.Odbc;

OdbcConnection con = new OdbcConnection("<connection
string>");
OdbcCommand com = new OdbcCommand("select * from TableX",
con);
OdbcDataAdapter da = new OdbcDataAdapter(com);
DataSet ds = new DataSet();

da.Fill(ds,"New");

DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables["New"];


you can get the connection string from:
http://www.connectionstrings.com/