Executing Transact SQL DELETE statement using SQLCommand
Following example displays us how to send a query using an SQLCommand. We execute a simple Transact-SQL DELETE statement to show all rows from database. I have used Nowthwind sample database for this sample.
<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
Sub Page_Load(Source as Object, E as EventArgs)
Dim cnn As New SQLConnection("server=LOCALHOST;User id=SA;password=;database=Northwind")
Dim UpdateCommand As SqlCommand = New SqlCommand()
UpdateCommand.Connection = cnn
Dim sql As String
sql = "Delete from categories WHERE CategoryID = @CatID"
UpdateCommand.CommandText = sql
UpdateCommand.Parameters.Add("@CatID", SqlDbType.Int).Value = 14
Try
cnn.Open()
UpdateCommand.ExecuteNonQuery()
Catch ex As Exception
response.Write(ex.ToString())
Finally
cnn.Close()
End Try
end sub
Comments:Only members can write comments.Please,
login /
register to write comment.
Best HTML5 Books
Here is the list of top HTML5:Â HTML5 For Web Designers , Â Introducing HTML5, Pro HTML5 Programming, Dive Into HTML5. Examples, frameworks, source codes and sample chapters can found at from original websites and directly download as e-book or order online
Getting the primary key value of the record
Often, we need to insert a new record in a table with an autonumber
variable as primary key, and get the value of the automatically
generated primary key back. For instance, when we start a new session
for a user, and we need the sessionID to insert as a foreign key into an
order table or so.
Simple PHP SOAP example
This post will show a simple example of how to interpretate a WSDL file and a very simple, yet quick example of how to extract information from this file through PHP.
In this example I assume that you've already have SOAP enabled in your PHP configuration because this is beyond the scope of this example. If you're not sure, you can check your phpinfo file.
Using an alternate JSON Serializer in ASP.NET Web API
The new ASP.NET Web API that Microsoft released alongside MVC 4.0 Beta
last week is a great framework for building REST and AJAX APIs. I've
been working with it for quite a while now and I really like the way it
works and the complete set of features it provides 'in the box'. It's
about time that Microsoft gets a decent API for building generic HTTP
endpoints into the framework.
How to Convert a PSD to XHTML
I continue to be amazed by how well Collis’s “Build a Sleek Portfolio
Site From Scratch” tutorial continues to perform. It’s been months, yet
it still posts strong numbers every week. Considering that fact, I
decided to create a screencast that shows you exactly how to convert a
PSD into perfect XHTML/CSS. (Read More)
Source Code
