To Create Table and report how many rows affected executing NonQuery Method

Posted Date: 07 Jul 2009	Resource Type: Code Snippets	Category: Visual Studio
Author: R.Vijayaragavan	Member Level: Gold
Rating:	Points: 3

Abstract:
Create and Delete table and Count no of Lines affected using Nonquery method.

Description:
To Create and Delete table and Count no of Lines affected using Nonquery method.

Code:

Imports System
Imports System.Data
Imports System.Data.SqlClient

Public class CreateTable

Shared Sub Main()
Dim thisConnection As New SqlConnection("server=(local)\SQLEXPRESS;" & _
"integrated security=sspi;database=MYDataBase")

'Create Command object
Dim nonqueryCommand As SqlCommand = thisConnection.CreateCommand()

Try
' Open Connection
thisConnection.Open()
Console.WriteLine ("Connection is Open")

' Execute NonQuery To Create Table
nonqueryCommand.CommandText = "CREATE TABLE Table_Name (ID integer)"
Console.WriteLine("Executing {0}", nonqueryCommand.CommandText)
Console.WriteLine("Number of rows affected : {0}", nonqueryCommand.ExecuteNonQuery())

' Execute NonQuery To Drop Table
nonqueryCommand.CommandText = "DROP TABLE Table_Name"
Console.WriteLine("Executing {0}", nonqueryCommand.CommandText)
Console.WriteLine("Number of rows affected : {0}", nonqueryCommand.ExecuteNonQuery())

Catch ex As SqlException
' Display error
Console.WriteLine ("Error: " & ex.ToString())
Finally
' Close Connection
thisConnection.Close()
Console.WriteLine ("Connection Closed")

End Try
End Sub
End Class

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

To Create Table and report how many rows affected executing NonQuery Method .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Types of Msgbox
	Previous Resource: Create An Database using SQL Connection
	Return to Discussion Resource Index
	Post New Resource
	Category: Visual Studio

Post resources and earn money!

More Resources