problem with odbc

[TomislaW]

This is the code:

OdbcConnection conn = new OdbcConnection(m_ConnectionString);

OdbcDataAdapter adapter = new OdbcDataAdapter();

adapter.SelectCommand = new OdbcCommand("spUser", conn);

OdbcParameter par = new OdbcParameter("@User",OdbcType.VarChar,20);

par.Value=user;

adapter.SelectCommand.Parameters.Add(par);

adapter.Fill(dsUser);

This is the error:

"ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure
'spUser' expects parameter '@User', which was not supplied."

What is wrong here

[Martin Marinov]

Try in this way

OdbcConnection conn = new OdbcConnection( m_ConnectionString );
OdbcDataAdapter adapter = new OdbcDataAdapter();
OdbcCommand command = new OdbcCommand();
OdbcParameter par = new OdbcParameter("@User", OdbcType.VarChar, 20 );
par.Value = user;
command.Parameters.Add ( par );
adapter.SelectCommand = command;

adapter.Fill ( dsUser );

Regards
Martin

"TomislaW" <to*********@hotmail.com> wrote in message
news:Oo**************@TK2MSFTNGP09.phx.gbl...

This is the code:

OdbcConnection conn = new OdbcConnection(m_ConnectionString);

OdbcDataAdapter adapter = new OdbcDataAdapter();

adapter.SelectCommand = new OdbcCommand("spUser", conn);

OdbcParameter par = new OdbcParameter("@User",OdbcType.VarChar,20);

par.Value=user;

adapter.SelectCommand.Parameters.Add(par);

adapter.Fill(dsUser);

This is the error:

"ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure
'spUser' expects parameter '@User', which was not supplied."

What is wrong here