Consultor Eletrônico

Status: Unverified

GOAL:

How do I do parameterized SQL queries in .NET?

GOAL:

How do I do parameterized SQL queries in C#?

FACT(s) (Environment):

Windows
OpenEdge 10.x

FIX:

The following sample C# program shows how to build a parameterized query against an ODBC connection:


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Odbc;

namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
OdbcConnection conn = new OdbcConnection("DSN=S2K;UID=abc;PWD=def;");
OdbcCommand cmd = conn.CreateCommand();

conn.Open();

cmd.CommandText = "SELECT CustNum, Name FROM PUB.Customer WHERE CustNum > ? AND Balance > ?";

cmd.Parameters.Add("@Num", OdbcType.Int);
cmd.Parameters.Add("@Bal", OdbcType.Int);

cmd.Parameters["@Num"].Value = 2;
cmd.Parameters["@Bal"].Value = 500;

OdbcDataReader reader = cmd.ExecuteReader();

while (reader.Read())
{
Console.WriteLine("CustNum and Name: {0} {1}", reader.GetValue(0), reader.GetValue(1));
}

reader.Close();

conn.Close();

Console.ReadLine();
}
}
}