|
-
December 4th, 2008, 06:46 AM
#4
Re: Deleting records
Okay that's not so difficult ..
Code:
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...
Articles VB6 : Break the 2G limit - Animation 1, 2 VB.NET : 2005/8 : Moving Images , Animation 1 , 2 , 3 , User Controls
WPF Articles : 3D Animation 1 , 2 , 3
Code snips: VB6 Hex Edit, IP Chat, Copy Prot., Crop, Zoom : .NET IP Chat (V4), Adv. ContextMenus, click Hotspot, Scroll Controls
Find me in ASP.NET., VB6., VB.NET , Writing Articles, My Genealogy, Forum
All VS.NET: posts refer to VS.NET 2008 (Pro) unless otherwise stated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|