Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public bool DoUpdate(string query, string[] data) {
- using (OleDbConnection conn = new OleDbConnection(this.ConnStr))
- {
- try
- {
- OleDbCommand cmd = new OleDbCommand(query, conn);
- DateTime tmp;
- for (int i = 0; i < data.Length; i++)
- {
- if (DateTime.TryParse(data[i], out tmp)) // Checks if valid date...
- cmd.Parameters.Add(new OleDbParameter("?", OleDbType.Date) { Value = tmp.ToString() });
- else
- cmd.Parameters.AddWithValue("?", data[i]);
- }
- conn.Open();
- cmd.ExecuteNonQuery();
- conn.Close();
- }
- catch (OleDbException ex)
- {
- MessageBox.Show(ex.ErrorCode.ToString() + "nn" + ex.Message + "nn" + query);
- if (conn.State == ConnectionState.Open)
- {
- conn.Close();
- return false;
- }
- }
- }
- return true;
- }
- // [ time string is DateTime.Now.ToString("M/dd/yyyy h:mm:ss tt") ]
- if ( DB.DoUpdate("UPDATE Loads SET Customer='?', FinishTime=?, Carrier='?', Reference='?', Tags='?', Status='Received' WHERE LoadID = ?",
- new string[] { Item["Customer"], Item["FinishTime"], Item["Carrier"], Item["Reference"], Item["TagIDs"], Item["LoadID"] }) ) { ... }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement