public static void UpDataDB(string DB, DataTable DT) { string ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DB + ";User Id=admin;Password=;"; string SQL = "SELECT * FROM table1 WHERE ReadingID=0"; string INSERT = "INSERT INTO table1 (Column1, Column2, Column3, Column4) " + "VALUES (@Column1, @Column2, @Column3, @Column4)"; OleDbConnection OleConn = new OleDbConnection(ConnString); OleDbDataAdapter OleAdp = new OleDbDataAdapter(SQL, OleConn); OleAdp.InsertCommand = new OleDbCommand(INSERT); OleAdp.InsertCommand.Parameters.Add("@Column1", OleDbType.Integer, 8, "Meter1"); OleAdp.InsertCommand.Parameters.Add("@Column2", OleDbType.Integer, 8, "Meter2"); OleAdp.InsertCommand.Parameters.Add("@Column3", OleDbType.Integer, 8, "Meter3"); OleAdp.InsertCommand.Parameters.Add("@Column4", OleDbType.Integer, 8, "Meter4"); OleAdp.InsertCommand.Connection = OleConn; OleAdp.InsertCommand.Connection.Open(); OleAdp.Update(DT); OleAdp.InsertCommand.Connection.Close(); }
Tuesday, June 2, 2015
BULK COPY with oledb
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.