How to read data using two parameters?

[ST Choong]

this.oleDbCommand1.CommandText = "SELECT Description, [Channel Number], Bit
FROM IO WHERE (Type = \'@Type\' AND Module = \'@Module\')";

this.oleDbCommand1.Connection = this.oleDbConnection1;

this.oleDbCommand1.Parameters.Add("@Type",
System.Data.OleDb.OleDbType.WChar, 50, e.Node.Parent.Text);

this.oleDbCommand1.Parameters.Add("@Module",
System.Data.OleDb.OleDbType.WChar, 50, e.Node.Text);

this.oleDbCommand1.Connection.Open();

System.Data.OleDb.OleDbDataReader myReader =
this.oleDbCommand1.ExecuteReader();

myReader.Close();

this.oleDbCommand1.Connection.Close();



I get error while executereader. Please help me.

Thanks.

 

[Ignacio Machin]

Hi,

What is the error you are getting? maybe the values of the parameters are
not the correct one. insert all the code in a try/catch block and see what
the exception Message says.

Cheers,