Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Net;
- using System.Data.Odbc;
- namespace ConsoleApplication4
- {
- class Program
- {
- static void Main(string[] args)
- {
- var constr = @"Driver={Microsoft Text Driver (*.txt; *.csv)}; DBQ=C:\db";
- using (var con = new OdbcConnection(constr))
- {
- con.Open();
- var cmd = new OdbcCommand("insert into " +
- "offline.csv(id, item1, item2, item3, item4, item5) " +
- "values(?,?,?,?,?,?);", con);
- cmd.Parameters.AddWithValue("id", "00001");
- cmd.Parameters.AddWithValue("item1", "00001");
- cmd.Parameters.AddWithValue("item2", "00001");
- cmd.Parameters.AddWithValue("item3", "00001");
- cmd.Parameters.AddWithValue("item4", "00001");
- cmd.Parameters.AddWithValue("item5", "00001");
- cmd.ExecuteNonQuery();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement