Da.fill(ds); --error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is my code
string Conn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
c:\\\\G_Drive_Entitlements_STM_2005.xls;" +
"Extended Properties=Excel 8.0;";
OleDbConnection dbConn = new OleDbConnection(Conn);
dbConn.Open ();
OleDbCommand Cmd = new OleDbCommand("Select * From [Sheet1$]", dbConn);
OleDbDataAdapter Da = new OleDbDataAdapter();
Da.SelectCommand = Cmd;
DataSet Ds = new DataSet();
Da.fill(Ds);
dg.DataSource = Ds.Tables[0];
dbConn.Close ();
 
freddy said:
Here is my code
string Conn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
c:\\\\G_Drive_Entitlements_STM_2005.xls;" +
"Extended Properties=Excel 8.0;";
OleDbConnection dbConn = new OleDbConnection(Conn);
dbConn.Open ();
OleDbCommand Cmd = new OleDbCommand("Select * From [Sheet1$]", dbConn);
OleDbDataAdapter Da = new OleDbDataAdapter();
Da.SelectCommand = Cmd;
DataSet Ds = new DataSet();
Da.fill(Ds);
dg.DataSource = Ds.Tables[0];
dbConn.Close ();
Click to expand...

Okay, now what's the error?
 
error An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll

Jon Skeet said:
freddy said:
Here is my code
string Conn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
c:\\\\G_Drive_Entitlements_STM_2005.xls;" +
"Extended Properties=Excel 8.0;";
OleDbConnection dbConn = new OleDbConnection(Conn);
dbConn.Open ();
OleDbCommand Cmd = new OleDbCommand("Select * From [Sheet1$]", dbConn);
OleDbDataAdapter Da = new OleDbDataAdapter();
Da.SelectCommand = Cmd;
DataSet Ds = new DataSet();
Da.fill(Ds);
dg.DataSource = Ds.Tables[0];
dbConn.Close ();
Click to expand...

Okay, now what's the error?
Click to expand...
 
error --An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll

Nicholas Paldino said:
Ok, so what is the error?


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

freddy said:
Here is my code
string Conn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
c:\\\\G_Drive_Entitlements_STM_2005.xls;" +
"Extended Properties=Excel 8.0;";
OleDbConnection dbConn = new OleDbConnection(Conn);
dbConn.Open ();
OleDbCommand Cmd = new OleDbCommand("Select * From [Sheet1$]", dbConn);
OleDbDataAdapter Da = new OleDbDataAdapter();
Da.SelectCommand = Cmd;
DataSet Ds = new DataSet();
Da.fill(Ds);
dg.DataSource = Ds.Tables[0];
dbConn.Close ();
Click to expand...
Click to expand...
 
Back
Top