Csharp/C Sharp by API/System.Data.OleDb/OleDbParameter

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

OleDbParameter.Name

<source lang="csharp"> 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" );
     }
   }
 }

}

 </source>