Csharp/CSharp Tutorial/ADO.Net/OleDbParameter
OleDbParameter Example
<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>