Passing a Dataset to a Grid Control

[Stuart Marshall]

Hello

I was wondering if you could help me with my syntax below. I am trying to take data from a stored procedure(app_displaySites) select query in my SQL 2000 database (SITEDATABASE_01)and then pass that via a Dataset to my DataGrid Control.

I am using Visual Studio VB 2005.

----------------------------------------

Imports System.Data.SqlClient

Public Class frntScrn

Dim sqlConn As New SqlConnection("server=NAME Of PC;database=SITEDATABASE_01;User ID=xxx;Password=xxxxx")
Dim sqlDR As New SqlDataAdapter
Dim sqlcomm As New SqlCommand
Dim grddataset As New DataSet

Private Sub frntScrn_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
sqlConn.Open()
sqlcomm = New SqlCommand("exec app_displaySites", sqlConn)
sqlDR.SelectCommand = sqlcomm
sqlDR.Fill(grddataset)
Me.grdMain.DataSource = grddataset
Catch ex As Exception
MessageBox.Show(ex.ToString, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
End Sub
End Class
---------------------------------------------------

I would be so grateful for any help