Advertisement
Guest User

Untitled

a guest
Jul 31st, 2015
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. using System.Net;
  7. using System.Data.Odbc;
  8.  
  9. namespace ConsoleApplication4
  10. {
  11. class Program
  12. {
  13. static void Main(string[] args)
  14. {
  15. var constr = @"Driver={Microsoft Text Driver (*.txt; *.csv)}; DBQ=C:\db";
  16. using (var con = new OdbcConnection(constr))
  17. {
  18. con.Open();
  19. var cmd = new OdbcCommand("insert into " +
  20. "offline.csv(id, item1, item2, item3, item4, item5) " +
  21. "values(?,?,?,?,?,?);", con);
  22.  
  23. cmd.Parameters.AddWithValue("id", "00001");
  24. cmd.Parameters.AddWithValue("item1", "00001");
  25. cmd.Parameters.AddWithValue("item2", "00001");
  26. cmd.Parameters.AddWithValue("item3", "00001");
  27. cmd.Parameters.AddWithValue("item4", "00001");
  28. cmd.Parameters.AddWithValue("item5", "00001");
  29.  
  30. cmd.ExecuteNonQuery();
  31. }
  32. }
  33. }
  34.  
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement