Da.fill(ds); --error

[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 ();

 

[Nicholas Paldino [.NET/C# MVP]]

Ok, so what is the error?

 

[Jon Skeet [C# MVP]]

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 ();

Okay, now what's the error?

 

[Guest]

error An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll

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 ();

Okay, now what's the error?

 

[Guest]

error --An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll

Ok, so what is the error?


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

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 ();

 

[Sahil Malik]

Look at this ---
c:\\\\G_Drive_Entitlements_STM_2005.xls;"

Even in C# that would mean C:\\G_Drive_Entit...

If fixing that doesn't help, can we see your XLS? Also I assume that your
error is at Da.Fill .

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

 

[Jon Skeet [C# MVP]]

error An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll

And what's the message in the exception object?

See http://www.pobox.com/~skeet/csharp/complete.html for a good way of
getting answers to problems quickly, rather than requiring several
rounds of question and answer.

 

[Sahil Malik]

See http://www.pobox.com/~skeet/csharp/complete.html for a good way of

getting answers to problems quickly, rather than requiring several
rounds of question and answer.

<--- Couldn't agree more !!

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik