private void insertButton_Click(object sender, RoutedEventArgs e) { int i = 0; string datas = ""; string updateQueries = ""; try { foreach (DataRow row in values.Rows) { if (i == 0) { datas = "('" + row[0].ToString() + "','" + Convert.ToDateTime(row[1].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "','" + row[2].ToString() + "')"; } else { datas = datas + ",('" + row[0].ToString() + "','" + Convert.ToDateTime(row[1].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "','" + row[2].ToString() + "')"; } updateQueries += "UPDATE equipment_list SET equipment_list.current_status = '7' WHERE equipment_list.equipment_id = '" + row[0].ToString() + "';\n"; i++; } string res = DBManager.InsertIntoServiceRequest(datas); if (!res.Contains("Success")) { myMessageBox mm = new myMessageBox("Invalid Data Found. Check your Data!", "Error", "OK", 1); mm.ShowDialog(); // MessageBox.Show("Invalid Data Type Found. Check your data again", "Error Occured", MessageBoxButton.OK, MessageBoxImage.Error); } else { DBManager.UpdateDatabaseQuery(updateQueries); myMessageBox mm = new myMessageBox("Data Added Succefully", "Success", "OK", 0); mm.ShowDialog(); // MessageBox.Show("Data Added Succesfully", "Successfully Added", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); } } catch (Exception ex) { // } }