SQL Delete Command??

[Darryn Ross]

Hi

I need to run a delete query from my application... is there a quick way of
doing this other than setting up an adapter and running the stored
procedure?? etc...

something like the VB6 database.Execute(SQLStatement) would be perfect... if
not i'll just do i the normal way.

Thanks
Regards

[Ansil MCAD]

hi
you can use DataAccessApplicationBlock Provided by microsoft .
It can be downloaded and used . It saves some code.

http://msdn.microsoft.com/library/de...ml/daab-rm.asp

regards
Ansil

Dimensions
Technopark
Trivandrum
an****@gmail.com
"Darryn Ross" wrote:

Hi

I need to run a delete query from my application... is there a quick way of
doing this other than setting up an adapter and running the stored
procedure?? etc...

something like the VB6 database.Execute(SQLStatement) would be perfect... if
not i'll just do i the normal way.

Thanks
Regards

[Manish.net]

Hi Darryn,

Yes sure u can excete delete query direct using command object.

'1. Create a connection
Dim myConnection as New SqlConnection("connectionString")

'2. Create the command object, passing in the SQL string
Const strSQL as String = "Delete ..."
Dim myCommand as New SqlCommand(strSQL, myConnection)

myConnection.Open()
myCommand.ExecuteScalar(CommandBehavior.CloseConne ction)
"Darryn Ross" wrote:

Hi

I need to run a delete query from my application... is there a quick way of
doing this other than setting up an adapter and running the stored
procedure?? etc...

something like the VB6 database.Execute(SQLStatement) would be perfect... if
not i'll just do i the normal way.

Thanks
Regards

[Kavvy]

"Darryn Ross" <da****@datawave.com.au> wrote in message
news:O9**************@TK2MSFTNGP12.phx.gbl...

Hi

I need to run a delete query from my application... is there a quick way of doing this other than setting up an adapter and running the stored
procedure?? etc...

something like the VB6 database.Execute(SQLStatement) would be perfect... if not i'll just do i the normal way.

Thanks
Regards

You need to set up a connection to your database, which here is referenced
by oleDbConnection1, this code is for an OLEDB connection but this can
easily be replaced by the SQL version.
string strDelete = "DELETE FROM [yourDatabase] WHERE [yourField] = '" +
yourArgument + "'";
OleDbCommand cmd = new OleDbCommand(strDelete, oleDbConnection1);
try
{
oleDbConnection1.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
oleDbConnection1.Close();
}