Accessing Access DataBase

[aPerfectCircle]

I'm tryin to find online a sample of a Windows code on how to access an Access DataBase,how to retreive and dispaly Data from different tables, and also how to update that database, all my online search hits were samples on Sql server . aPerfectTool

[Kodanda Pani]

Hi, Try using the following code. OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Samples\Test.mdb; Mode=Share Deny None;Persist Security Info=False;Jet OLEDB:System database=C:\SYSTEM.MDW;"); conn.Open(); OleDbDataAdapter da = new OleDbDataAdapter(); OleDbCommand command = new OleDbCommand(); command.Connection = conn; command.CommandText = "select * from person" ; da.SelectCommand = command; DataSet ds = new DataSet(); da.Fill(ds); Thanks and Regards Pani

[Navas M]

//insert the data into table using the access connection //that is table having the two field string name = t1.text; int regno = t2.text //stud is ur table name //ur declare this variable as varchar in ur table then using '"++"'between //the varible string query = "insert into stud values('"+name+"','"+regno+"'); OleDbConnection con = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB4.0; Password = ; User id=Admin;Data Source =d:\table\stud.mdb"); con.Open(); OleDbCommand cmd=new OleDbCommand(query,con); cmd.ExecuteNonQuery(); con.Close();