鍦ˋSP.NET涓娇鐢∣leDbCommand锛屾偍闇€瑕佹寜鐓т互涓嬫楠よ繘琛屾搷浣滐細

1. 鍒涘缓涓€涓狾leDbConnection瀵硅薄锛屽苟璁剧疆杩炴帴瀛楃涓层€傝繛鎺ュ瓧绗︿覆涓簲鍖呮嫭鏁版嵁搴撶殑鐩稿叧淇℃伅锛屼緥濡傛暟鎹簱绫诲瀷銆佹湇鍔″櫒鍚嶇О銆佹暟鎹簱鍚嶇О绛夈€傚涓嬫墍绀猴細

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb");

2. 鎵撳紑杩炴帴锛?/li>

conn.Open();

3. 鍒涘缓涓€涓狾leDbCommand瀵硅薄锛屽苟浼犲叆SQL鏌ヨ鎴栧瓨鍌ㄨ繃绋嬬殑鍛戒护鏂囨湰浠ュ強杩炴帴瀵硅薄銆傚涓嬫墍绀猴細

OleDbCommand cmd = new OleDbCommand("SELECT * FROM MyTable", conn);

4. 濡傛灉闇€瑕佹墽琛岀殑鏄瓨鍌ㄨ繃绋嬶紝鎮ㄥ彲浠ヨ缃瓹ommandType灞炴€т负CommandType.StoredProcedure锛屽苟灏嗗懡浠ゆ枃鏈缃负瀛樺偍杩囩▼鐨勫悕绉帮細

cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "MyStoredProcedure";

5. 濡傛灉鏈夐渶瑕侊紝鎮ㄥ彲浠ユ坊鍔犲弬鏁板埌OleDbCommand瀵硅薄涓€備緥濡傦紝鍙互浣跨敤AddWithValue鏂规硶娣诲姞涓€涓弬鏁帮紝骞舵寚瀹氬弬鏁扮殑鍚嶇О鍜屽€硷細

cmd.Parameters.AddWithValue("@ParameterName", value);

6. 鎵ц鏌ヨ鎴栧瓨鍌ㄨ繃绋嬶紝骞惰幏鍙栫粨鏋溿€傛牴鎹渶瑕侊紝鍙互浣跨敤ExecuteReader銆丒xecuteScalar鎴朎xecuteNonQuery鏂规硶鏉ユ墽琛岀浉搴旂殑鎿嶄綔銆備緥濡傦紝浣跨敤ExecuteReader鏂规硶鎵ц鏌ヨ锛屽苟浣跨敤DataReader鏉ヨ鍙栫粨鏋滐細

OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
// 澶勭悊鏌ヨ缁撴灉
}
reader.Close();

7. 鍏抽棴杩炴帴锛?/li>

conn.Close();

璇锋敞鎰忥紝浠ヤ笂浠ｇ爜浠呬负绀轰緥锛屾偍闇€瑕佹牴鎹嚜宸辩殑鍏蜂綋闇€姹傝繘琛岀浉搴旂殑淇敼鍜岃皟鏁淬€?/p>