RE:insertar y borrar registros con sql
Hola espero te sirva:
****
Dim Message as String
Dim myConnection as SqlConnection
Dim mySqlCommand as SqlCommand
Dim mySqlCleanup as SqlCommand
myConnection = new SqlConnection("server=(local)\NetSDK;Trusted_Connection=yes;database=northwind")
mySqlCommand = new SqlCommand("INSERT INTO Customers (CustomerId, CompanyName, ContactName, ContactTitle, Address) Values ('ABC','ABC Company', 'John Smith', 'Owner','One My Way')", myConnection)
mySqlCleanup = new SqlCommand("DELETE FROM Customers WHERE CustomerId = 'ABC'", myConnection)
try
myConnection.Open()
mySqlCleanup.ExecuteNonQuery() mySqlCommand.ExecuteNonQuery()
Message = "Se ha insertado un registro nuevo en la tabla Customers de Northwind."
catch myException as Exception
Message= "No se pudo insertar el registro: " + myException.ToString()
finally
myConnection.Close()
end try
Console.Write(Message)