public DataTable ExecuteProcedure(ISqlComunicator SqlComunicator) { using (SqlConnection connection = CreateSQLConnection()) { SqlCommand command = new SqlCommand(SqlComunicator.ProcedureName, connection); command.CommandType = CommandType.StoredProcedure; if (SqlComunicator.ParamList != null) { foreach (SqlParameter param in SqlComunicator.ParamList) { command.Parameters.Add(param); } } SqlDataReader reader = command.ExecuteReader(); try { resultTable = new DataTable(); resultTable.Load(reader); if (resultTable.Columns[0].ColumnName == "Succes") { MessageBox.Show(resultTable.Rows[0][0].ToString()); } else if (resultTable.Columns[0].ColumnName == "Error") { MessageBox.Show(resultTable.Rows[0][0].ToString()); } } finally { reader.Close(); } } return(resultTable); }
public DataTable ModifyData(ISqlComunicator SqlComunicator) { SqlComunicator.ModifyData(); return(ExecuteProcedure(SqlComunicator)); }
public DataTable AddData(ISqlComunicator SqlComunicator) { SqlComunicator.AddData(); return(ExecuteProcedure(SqlComunicator)); }