OleDbParameter Example : OleDbParameter : ADO.Net C# Examples

    
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"  );
            }
        }

    }

}