Code666 (代码贴、代码片段)

[C#] 用ADO添加数据到数据库中 →→→→→进入此内容的聊天室

来自 , 2020-04-12, 写在 C#, 查看 108 次.
URL http://www.code666.cn/view/5118af07
  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 = INSERT INTO Employee(FirstName, LastName) VALUES('FirstName', 'LastName') ;
  11.  
  12. // create Objects of ADOConnection and ADOCommand
  13. OleDbConnection conn = new OleDbConnection(strDSN);
  14. OleDbCommand cmd = new OleDbCommand( strSQL, conn );
  15. try
  16. {
  17. conn.Open();
  18. cmd.ExecuteNonQuery();
  19. }
  20. catch (Exception e)
  21. {
  22. Console.WriteLine(Oooops. I did it again:\n{0}, e.Message);
  23. }
  24. finally
  25. {
  26. conn.Close();
  27. }
  28. }
  29. }
  30.  
  31. //csharp/1140

回复 "用ADO添加数据到数据库中"

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

captcha

贴代码片段 - Code666