Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

SqlCommand and SqlConnection Objects

For a Stored Procedure¶

conn.Open()

Dim cmd As New SqlCommand() 
cmd.CommandTimeout = 180
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection = conn
cmd.CommandText = "dbo.usp_MyStoredProcedure"
cmd.Parameters.AddWithValue("@param1", comm)

Dim da as SqlDataAdapter = new SqlDataAdapter(cmd)
Dim dt As DataTable = New DataTable()
da.Fill(dt)

conn.Close()