Deleting records

[kriti]

How to delete the records from a sql table in VB.NET when a button is clicked.The records from the table in the database should be deleted.

[GremlinSA]

SQL CODE:::: Stored procedure

CREATE PROCEDURE [dbo].[Del_From_Table]

@id int

DELETE
FROM [Table]
WHERE
[id] = @id

and in VB .. Dim sqlConn As New SqlConnection([ConnectionString])
Dim cmd As New SqlCommand
Dim dr As SqlDataReader

Try
sqlConn.Open()
With cmd
.Connection = sqlConn
.CommandType = CommandType.StoredProcedure
.CommandText = "Del_from_Table"
.Parameters.AddWithValue("@id", id)
.Connection = sqlConn
dr = .ExecuteReader()

End With

Catch ex As Exception
'Log an error here.....
End Try
It's that easy ...

Gremmy...

[kriti]

SQL CODE:::: Stored procedure

CREATE PROCEDURE [dbo].[Del_From_Table]

@id int

DELETE
FROM [Table]
WHERE
[id] = @id

and in VB .. Dim sqlConn As New SqlConnection([ConnectionString])
Dim cmd As New SqlCommand
Dim dr As SqlDataReader

Try
sqlConn.Open()
With cmd
.Connection = sqlConn
.CommandType = CommandType.StoredProcedure
.CommandText = "Del_from_Table"
.Parameters.AddWithValue("@id", id)
.Connection = sqlConn
dr = .ExecuteReader()

End With

Catch ex As Exception
'Log an error here.....
End Try
It's that easy ...

Gremmy...

can i have a method instead of a stored procedure????i just want to empty out the contents of the table...

[GremlinSA]

Okay that's not so difficult ..

Dim sqlConn As New SqlConnection([ConnectionString])
Dim cmd As New SqlCommand
Dim dr As SqlDataReader

Try
sqlConn.Open()
With cmd
.Connection = sqlConn
.CommandText = "DELETE FROM [Table] WHERE [id] = @id"
.Parameters.AddWithValue("@id", id)
.Connection = sqlConn
dr = .ExecuteReader()

End With

Catch ex As Exception
'Log an error here.....
End Try

Now you have a method ...

Gremmy...