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") + "','" + Convert.ToDateTime(row[2].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "','" + row[3].ToString() + "','" + row[4].ToString() + "')"; } else { datas = datas + ",('" + row[0].ToString() + "','" + Convert.ToDateTime(row[1].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "','" + Convert.ToDateTime(row[2].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "','" + row[3].ToString() + "','" + row[4].ToString() + "')"; } updateQueries += "UPDATE equipment_list SET equipment_list.current_status = '2' WHERE equipment_list.equipment_id = '" + row[0].ToString() + "';\n"; i++; } string res = DBManager.InsertIntoMaintainanceRequest(datas); if (!res.Contains("Success")) { myMessageBox mm = new myMessageBox("Invalid Data Type found. Check your data again.", "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 Successfully", "Success", "OK", 0); mm.ShowDialog(); //MessageBox.Show("Data Added Succesfully", "Successfully Added", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); } } catch (Exception ex) { // } }