Code666 (代码贴、代码片段)

[C#] 使用OLEConn连接数据库 →→→→→进入此内容的聊天室

来自 , 2021-04-02, 写在 C#, 查看 151 次.
URL http://www.code666.cn/view/51594de1
  1. using System;
  2. using System.Data;
  3. using System.Data.OleDb;
  4.  
  5. class TestADO
  6. {
  7. static void Main(string[] args)
  8. {
  9. string strDSN = Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:\test.mdb;
  10. string strSQL = SELECT * FROM employee ;
  11.  
  12. OleDbConnection conn = new OleDbConnection(strDSN);
  13. OleDbDataAdapter cmd = new OleDbDataAdapter( strSQL, conn );
  14.  
  15. conn.Open();
  16. DataSet ds = new DataSet();
  17. cmd.Fill( ds, employee );
  18. DataTable dt = ds.Tables[0];
  19.  
  20. foreach( DataRow dr in dt.Rows )
  21. {
  22. Console.WriteLine(First name: + dr[FirstName].ToString() + Last name: + dr[LastName].ToString());
  23. }
  24. conn.Close();
  25. }
  26. }
  27.  
  28. //csharp/1137

回复 "使用OLEConn连接数据库"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666