Problem to get DataAdapter to work in .Net
517804Jun 12 2006 — edited Jul 6 2006Hi
Im trying to ad the DataAdapter to my project but i got the following message
'System.ComponentModel.Component' is defined in an assembly that is not referenced. You must add a reference to assembly 'System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
There is a reference to System version 2.0.0.0 in my project
Im using the following code
using Oracle.Lite.Data;
try {
dsn = "dsn=" + UserName + "_" + "cabamob;uid=system;pwd=" + Password;
lConn = new LiteConnection(dsn);
lConn.Open();
LiteCommand cmd = (LiteCommand) lConn.CreateCommand();
cmd.CommandText = "SELECT table_name FROM all_tables";
cmd.Prepare();
LiteDataAdapter lApdapter = new LiteDataAdapter(cmd);
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message);
}
The first part works - its the : LiteDataAdapter lApdapter = new LiteDataAdapter(cmd);
that trigger the error