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()