Compile Error: The type or namespace name 'SQLDataSetCommand' could not be found

[Matthew Louden]

using System.Data;
using System.Data.SqlClient;
//etc...

SqlConnection conn = new SqlConnection(connString);
SQLDataSetCommand myCmd = new SQLDataSetCommand("select * from Test;",
conn);
DataSet ds = new DataSet();
myCmd.FillDataSet(ds, "test");

Compile Error:
The type or namespace name 'SQLDataSetCommand' could not be found (are you
missing a using directive or an assembly reference)?

The type or namespace name 'myCmd' could not be found (are you missing a
using directive or an assembly reference)?
any ideas??

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

A very clear one, SQLDataSetCommand does not exist :)
Try SqlCommand instead ;)

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Matthew Louden" <ma*******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

using System.Data;
using System.Data.SqlClient;
//etc...

SqlConnection conn = new SqlConnection(connString);
SQLDataSetCommand myCmd = new SQLDataSetCommand("select * from Test;",
conn);
DataSet ds = new DataSet();
myCmd.FillDataSet(ds, "test");

Compile Error:
The type or namespace name 'SQLDataSetCommand' could not be found (are you
missing a using directive or an assembly reference)?

The type or namespace name 'myCmd' could not be found (are you missing a
using directive or an assembly reference)?
any ideas??

[Marco Martin]

Matthew,

the class name is SQLCommand not SQLDatasetCommand.

Hope this helps

Marco
"Matthew Louden" <ma*******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

using System.Data;
using System.Data.SqlClient;
//etc...

SqlConnection conn = new SqlConnection(connString);
SQLDataSetCommand myCmd = new SQLDataSetCommand("select * from Test;",
conn);
DataSet ds = new DataSet();
myCmd.FillDataSet(ds, "test");

Compile Error:
The type or namespace name 'SQLDataSetCommand' could not be found (are you
missing a using directive or an assembly reference)?

The type or namespace name 'myCmd' could not be found (are you missing a
using directive or an assembly reference)?
any ideas??