5 replies to this topic

[elizabethmwashuma]

hi everyone,

i need help....i want a code that connects to a database and directly opens the database...

thanks in advance.

regards.

[BuckAMayzing]

at the top you need to have:

using System.Data.ODBC;

then you can use SQL-like method to connect to the database. For an example, let's say you have a windows form with a DataGridView control called "dgvTable" in it:

OdbcConnection conn = new OdbcConnection("YOUR CONNECTION STRING GOES HERE. GOOGLE "ACCESS CONNECTION STRING" TO FIND IT");
OdbcQuery query = conn.CreateCommand();
query.CommandText = "select COLUMN1,COLUMN2,COLUMN3 from TABLE1 where COLUMN1 = 'someval'"; 
Dataset ds = new DataSet();
OdbcDataAdpater adapter = new OdbcDataAdapter(query);
adapter.Fill(ds);
dgvTable.DataSource = ds.Tables[0];

Of course, there are TONS of ways to do this, and this is a very simple example. But as far as I know, access supports basic SQL syntax.

[elizabethmwashuma]

what is the main difference btween odbc and oledb.....i tried the code you gave me....has got errors

[Davide]

Some searching wouldn't hurt anyone: http://forum.codecal...p-access-c.html
This thread was posted less then a week ago.

[Davide]

Some searching wouldn't hurt anyone: http://forum.codecal...p-access-c.html
This thread was posted less then a week ago.

[BuckAMayzing]

I meant Oledb anyway. The code is the same, just replace Odbc with Oledb.