Examen

EXEC DBO.SELECT1 1 , 2
GO

ALTER PROCEDURE DBO.SELECT1 (@ID1 INTEGER,@ID2 INTEGER)
AS
BEGIN
SELECT * FROM MONEDAS WHERE MO_ID IN (@ID1, @ID2)
END

public DataSet SelectSql(string consulta){DataSet Nom_ds = new DataSet();

try{
using (SqlConnection connection = new SqlConnection("DataSecurity=True"))
{
connection.Open();SqlDataAdapter adapter = new SqlDataAdapter(consulta, connection);
adapter.Fill(Nom_ds, "TableName");
return Nom_ds;
}
}catch (Exception ex)
{
return null;
}

}

public bool InsertSql(string consulta)
{
try
{using (SqlConnection connection = new SqlConnection("Dataxouers "))
{

SqlCommand command = new SqlCommand(consulta, connection);connection.Open();
command.ExecuteNonQuery();
command.Dispose();

}
return true;
}
catch{
return false;
} }



public bool TransaccionSQL(string consulta) {
using (SqlConnection connection = new SqlConnection("Data Source=;"))
{
connection.Open();

SqlCommand command = connection.CreateCommand();
SqlTransaction transaction = default(SqlTransaction);transaction = connection.BeginTransaction("SampleTransaction");
command.Connection = connection;
command.Transaction = transaction;try
{
command.CommandText = consulta;
command.ExecuteNonQuery();
transaction.Commit();
return...