OleDbParameter Example : OleDbParameter « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. OleDbParameter

using System;
using System.Drawing;
using System.Collections;
using System.Data;
using System.Data.OleDb;

class MainClass{
  [STAThread]
  static void Main() 
  {
    string cstr = "provider=sqloledb;server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
    using ( OleDbConnection conn = new OleDbConnection( cstr ) )
    {
      conn.Open();

      string selstr = "select firstName from Employee where lastname = ?";
      OleDbCommand cmd = new OleDbCommand( selstr, conn );
      OleDbParameter name = cmd.Parameters.Add( "@name", OleDbType.VarChar, 15 );
      name.Value = "Tang";
      OleDbDataReader rdr = cmd.ExecuteReader();

      if ( rdr.Read() )
      {
        Console.WriteLine(rdr.GetString( 0 ) );
      }
      else
      {
        Console.WriteLine(" is not available yet" );
      }
    }

  }

}