sql里的参数传递的简单例子

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

namespace sqlcanshu {
    class Program {
        public static OleDbConnection condb() {
            return new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=db1.MDB");
        }
        static void Main(string[] args) {
            OleDbConnection mycon = condb();
            OleDbCommand mycom = new OleDbCommand();
            mycom.Connection = mycon;
            mycon.Open();
            mycom.CommandText = "select * from table1 where id = @id";
            OleDbParameter mypara = new OleDbParameter("@id",SqlDbType.Int);
            mypara.Value = 2;
            mycom.Parameters.Add(mypara);
            ///com的
            //OleDbDataReader mydr = mycom.ExecuteReader();
            //while (mydr.Read()) {
            //    Console.WriteLine(mydr["name"].ToString());
            //}
            ///ds的
            OleDbDataAdapter da = new OleDbDataAdapter(mycom);
            DataSet ds = new DataSet();
            da.Fill(ds);
            Console.WriteLine(ds.Tables[0].Rows[0]["name"].ToString());
            mycon.Close();
            Console.Read();
        }
    }
}

 

有待扩展