Advertisement
Guest User

Untitled

a guest
Sep 1st, 2015
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.43 KB | None | 0 0
  1. public bool DoUpdate(string query, string[] data) {
  2.  
  3. using (OleDbConnection conn = new OleDbConnection(this.ConnStr))
  4. {
  5. try
  6. {
  7. OleDbCommand cmd = new OleDbCommand(query, conn);
  8. DateTime tmp;
  9. for (int i = 0; i < data.Length; i++)
  10. {
  11. if (DateTime.TryParse(data[i], out tmp)) // Checks if valid date...
  12. cmd.Parameters.Add(new OleDbParameter("?", OleDbType.Date) { Value = tmp.ToString() });
  13. else
  14. cmd.Parameters.AddWithValue("?", data[i]);
  15. }
  16. conn.Open();
  17. cmd.ExecuteNonQuery();
  18. conn.Close();
  19. }
  20. catch (OleDbException ex)
  21. {
  22. MessageBox.Show(ex.ErrorCode.ToString() + "nn" + ex.Message + "nn" + query);
  23. if (conn.State == ConnectionState.Open)
  24. {
  25. conn.Close();
  26. return false;
  27. }
  28. }
  29. }
  30. return true;
  31. }
  32.  
  33. // [ time string is DateTime.Now.ToString("M/dd/yyyy h:mm:ss tt") ]
  34. if ( DB.DoUpdate("UPDATE Loads SET Customer='?', FinishTime=?, Carrier='?', Reference='?', Tags='?', Status='Received' WHERE LoadID = ?",
  35. new string[] { Item["Customer"], Item["FinishTime"], Item["Carrier"], Item["Reference"], Item["TagIDs"], Item["LoadID"] }) ) { ... }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement