SQL connection to Access database

[Wilfried Mestdagh]

Hi,

I wants to to something really simple, but dont succedd in C# :( I'm using
2005 beta version with .net 2 beta.

I wants to connect ot an Access database and do a query, and then in the
dataset a First() , Next() until Eof();

Also I want to access fields in the dataset (of course), but I cannot find
anything like 'fieldbyname' or something.. how access fiels ?

--
rgds, Wilfried
http://www.mestdagh.biz

[Wilfried Mestdagh]

Found it :)

OleDbConnection Conn = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " +
"Data
Source=C:\\test.mdb");
OleDbCommand SQL = new OleDbCommand("select * from Rx", Conn);
Conn.Open();
OleDbDataReader Reader = SQL.ExecuteReader();

int RXDT = Reader.GetOrdinal("RXDT");
int Sog = Reader.GetOrdinal("Sog");
while (Reader.Read()) {
Console.WriteLine(Reader.GetValue(Sog));
Console.WriteLine(Reader.GetValue(RXDT));
}
Reader.Close();
Conn.Close();

rgds, Wilfried

[Robert]

ADODB.ConnectionString=Provider=Microsoft.Jet.OLED B.4.0;User
ID=uzttkownik;Data Source=Scieszka_Plik;Mode=Share Deny None;Jet
OLEDB:Database Password=haslo;Jet OLEDB:Engine Type=5;Jet OLEDB:Database
Locking Mode=1

ADODB.Open() lub ADODB.Open("Provider=Microsoft.Jet.OLEDB.4.0;User
ID=uzttkownik;Data Source=Scieszka_Plik;Mode=Share Deny None;Jet
OLEDB:Database Password=haslo;Jet OLEDB:Engine Type=5;Jet OLEDB:Database
Locking Mode=1")

ADODB.Recordset.Open(sql,biezace_polaczenie(zwraca ne przez ADODB.Open),itd

if(!ADODB.Recordset.BOF) ADODB.Recordset.MoveNext();

if(!ADODB.Recordset.EOF) ADODB.Recordset.MoveFirst();

Adapter.Fill(DataSet, Recordset, NazwaTabeli)

[Robert]

ADODB.ConnectionString=Provider=Microsoft.Jet.OLED B.4.0;User
ID=user;Data Source=folder_file;Mode=Share Deny None;Jet
OLEDB:Database Password=password;Jet OLEDB:Engine Type=5;Jet OLEDB:Database
Locking Mode=1

ADODB.Open() or
ADODB.Open("ADODB.ConnectionString=Provider=Micros oft.Jet.OLEDB.4.0;User
ID=user;Data Source=folder_file;Mode=Share Deny None;Jet
OLEDB:Database Password=password;Jet OLEDB:Engine Type=5;Jet OLEDB:Database
Locking Mode=1")

ADODB.Recordset.Open(sql,current_connection(return by ADODB.Open),so

if(!ADODB.Recordset.BOF) ADODB.Recordset.MoveNext();

if(!ADODB.Recordset.EOF) ADODB.Recordset.MoveFirst();

Adapter.Fill(DataSet, Recordset, NazwaTabeli)

[Wilfried Mestdagh]

Hi Robert,

thanks but the compiler complains these members are not found in ADODB
namespce. Something I missing ?

[Robert]

you have to add references -> ADODB.dll from the solution Explorer

[Robert]

you have to add references -> ADODB.dll from the solution Explorer

private ADODB.Connection MDB = New ADODB.Connection();
private ADODB.Recordset Records = New ADODB.Recordset();
private OleDb.OleDbDataAdapter Adapter = New OleDb.OleDbDataAdapter();
priwate DataSet DS = new DataSet();

1. this.MDB.ConnectionString=Provider=Microsoft.Jet.O LEDB.4.0;User
ID=user;Data Source=folder_file;Mode=Share Deny None;Jet
OLEDB:Database Password=password;Jet OLEDB:Engine Type=5;Jet OLEDB:Database
Locking Mode=1

this.MDB.Open()

OR

2.
this.MDB.Open("ADODB.ConnectionString=Provider=Mic rosoft.Jet.OLEDB.4.0;User
ID=user;Data Source=folder_file;Mode=Share Deny None;Jet
OLEDB:Database Password=password;Jet OLEDB:Engine Type=5;Jet OLEDB:Database
Locking Mode=1")

this.Records.Open(sql,MDB,so

if(!this.Records.BOF) this.Records.MoveNext();

if(!this.Records.EOF) this.Records.MoveFirst();

this.Adapter.Fill(DS, this.Records, TableName)

[Wilfried Mestdagh]

thank you for this very complet answer

rgds, Wilfried