D
Dave
How do you form a datatable programatically, the following does not work,
OleDbConnection conn = new OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source="c:\\Test.mdb");
conn.Open();
OleDbDataAdapter dadp = new OleDbDataAdapter("SELECT Company.Company_No,
Company.Company_Name], Company.Address
"FROM Company", conn);
DataTable m_datatable= new DataTable();
dadp.Fill(m_datable,"newdata");
The last line fails, why?
OleDbConnection conn = new OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source="c:\\Test.mdb");
conn.Open();
OleDbDataAdapter dadp = new OleDbDataAdapter("SELECT Company.Company_No,
Company.Company_Name], Company.Address
"FROM Company", conn);
DataTable m_datatable= new DataTable();
dadp.Fill(m_datable,"newdata");
The last line fails, why?