How to use integer variable in OleDb query

[Tim Sprout]

How do I take a query like:

"string strOleDb = "Select * from ProjectTable WHERE ID = 4";

and pass in an integer variable for the ID, instead of the literal 4?

Thanks always,

-Tim Sprout

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

Hi,
"Tim Sprout" <tm**@ptialaska .netwrote in message
news:Oj******** ******@TK2MSFTN GP05.phx.gbl...

How do I take a query like:

"string strOleDb = "Select * from ProjectTable WHERE ID = 4";

and pass in an integer variable for the ID, instead of the literal 4?

Replace with the correct classes:

using (SqlConnection con = new
SqlConnection(C onfigOptions.Co nnectionString) )
{
con.Open();
using (SqlCommand com = new SqlCommand())
{
com.CommandText = "InsertOffe r";
com.CommandType = CommandType.Sto redProcedure;
com.Connection = con;

com.Parameters. Add("@offerID", SqlDbType.Int). Value =
offerId;

com.ExecuteNonQ uery();
}
}