How to use integer variable in OleDb query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim Sprout - 28 Jun 2007 14:57 GMT

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

Reply to this Message

Jon Skeet [C# MVP] - 28 Jun 2007 14:58 GMT

> 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?

See the example in the OleDbParameter class documentation.

Jon

Reply to this Message

Ignacio Machin ( .NET/ C# MVP ) - 28 Jun 2007 15:31 GMT

Hi,

> 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(ConfigOptions.ConnectionString))
{
con.Open();
using (SqlCommand com = new SqlCommand())
{
com.CommandText = "InsertOffer";
com.CommandType = CommandType.StoredProcedure;
com.Connection = con;

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

com.ExecuteNonQuery();
}
}

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...