private void DBConn_Load(object sender, EventArgs e) { try { DBSqlConn.DBServer = Global_DBServer; DBSqlConn.DBName = Global_DBName; DBSqlConn.DBUser = Global_DBUser; DBSqlConn.DBUserPwd = Global_DBUserPwd; DataSet ds; string Query = "SELECT TOP 20 DATETIME_STAMP as Fecha, ALARM as Descripcion, NOINS as Id FROM Logs ORDER BY DATETIME_STAMP DESC;"; ds = DBSqlConn.Exec(Query); dgv_meters.DataSource = ds.Tables[0]; } catch (Exception error) { MessageBox.Show("Error: " + error); } }
private void btnEliminar_Click(object sender, EventArgs e) { try { DBSqlConn.DBServer = Global_DBServer; DBSqlConn.DBName = Global_DBName; DBSqlConn.DBUser = Global_DBUser; DBSqlConn.DBUserPwd = Global_DBUserPwd; string Query = "DELETE Logs WHERE NOINS='{0}';"; Query = string.Format(Query, "00007844-3"); DBSqlConn.Exec(Query); MessageBox.Show("Info: Registro Eliminado Correctamente"); DBConn_Load(sender, e); } catch (Exception error) { MessageBox.Show("Error: " + error); } }
private void btnEditar_Click(object sender, EventArgs e) { try { DBSqlConn.DBServer = Global_DBServer; DBSqlConn.DBName = Global_DBName; DBSqlConn.DBUser = Global_DBUser; DBSqlConn.DBUserPwd = Global_DBUserPwd; string Query = "UPDATE Logs SET ALARM='{0}' WHERE NOINS='{1}';"; Query = string.Format(Query, "Alerta de Prueba Editada", "00007844-3"); DBSqlConn.Exec(Query); MessageBox.Show("Info: Registro Modificado Correctamente"); DBConn_Load(sender, e); } catch (Exception error) { MessageBox.Show("Error: " + error); } }
private void btnAgregar_Click(object sender, EventArgs e) { try { DBSqlConn.DBServer = Global_DBServer; DBSqlConn.DBName = Global_DBName; DBSqlConn.DBUser = Global_DBUser; DBSqlConn.DBUserPwd = Global_DBUserPwd; string Query = "INSERT INTO Logs ( DATETIME_STAMP, ALARM, NOINS ) VALUES ( CONVERT(datetime,'{0}',102), '{1}', '{2}' );"; Query = string.Format(Query, "2019-08-21 08:00:01.000", "Alerta de Prueba", "00007844-3"); DBSqlConn.Exec(Query); MessageBox.Show("Info: Registro Creado Correctamente"); DBConn_Load(sender, e); } catch (Exception error) { MessageBox.Show("Error: " + error); } }