learning ado.net

[Jordi Maycas]

Hello!! I'm doing the following using vc#.net 2005. I've got not compiler
nor linker errors, but I don't know if there is another way to do the same
more clear.

ADODB.Connection cn=new ADODB.Connection();

ADODB.Recordset res=new ADODB.Recordset();

object objAffected;

string strStatement="Select * from prueba";

string cnStr;

string fichero = "c:\\prueba.mdb ";

try

{

cnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fichero;

cn.Open(cnStr, null, null, 0);

cn.Execute(strStatement, out objAffected, 0);

}

finally

{

cn.Close();

}