How to used AddParameter method to add parameter?

[Benny Ng]

Now I'm used MS Enterprise Library to insert data into DataGrid.

But an statement error in AddParameter in the following:

Database db = DatabaseFactory.CreateDatabase("Database Instance NorthWind");
string sqlCommand = "Select CustomerID, CompanyName, ContactName From
Customers";
DBCommandWrapper dbCommandWrapper =
db.GetSqlStringCommandWrapper(sqlCommand);
//dbCommandWrapper.AddParameter("@CustomerID","FRANK ") ; <--Error

But how to used this method? seems many parameter should be insert into
this. in this case, i want to search the datas where CustomerID="FRANK", and
return it.

How to solve it?

Any suggestion are appreciated. Thanks.

[DBC User]

Just curious, how would the AddParameter know @CustomerID is string?

[DBC User]

Here is what I was reffering to

dbCommandWrapper.AddInParameter("@CategoryID", DbType.Int32, Category);

[Benny Ng]

Oh,Yes!

Problem solved!

At first, I misunderstand that the AddInParameter is only for
StoreProcedure. But just now when I try to used this for run SQL statement.
Successed it.

Thank you!!

Benny Ng
"DBC User" <db*****@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

Here is what I was reffering to

dbCommandWrapper.AddInParameter("@CategoryID", DbType.Int32, Category);