Using Stored Procedures With A SQLDataAdapter

With MUCH help from this site and its users, I now know how to link a SqlCommand to a stored procedure:

 What I don't know how to do, if it is possible, is to use a stored procedure with a SQLDataAdapter...

Here is the code as I am using, anyone have an idea on how to do this the right way?

' Define data objects

Dim conn As SqlConnection

Dim dataSet As New DataSet

Dim adapter As SqlDataAdapter

If ViewState("FooterDataSet") Is Nothing Then


' Read the connection string from Web.config

Dim connectionString As String = _

ConfigurationManager.ConnectionStrings( _

"Greensheet").ConnectionString

' Initialize connection

conn = New SqlConnection(connectionString)

' Create adapter

adapter = New SqlDataAdapter("SELECT * " & _






"FROM Table " & _






"WHERE (ID= " & intID & ")", conn)

' Fill the DataSet

adapter.Fill(dataSet, "Footer")

' Store the DataSet in view state

ViewState("FooterDataSet") = dataSet

Else


dataSet = ViewState("FooterDataSet")

End If

' Prepare the sort expression using the gridSortDirection and

' gridSortExpression properties

Dim sortExpression As String

If gridSortDirection = SortDirection.Ascending Then


sortExpression = gridSortExpression & " ASC"

Else


sortExpression = gridSortExpression & " DESC"

End If

' Sort the data

dataSet.Tables("Footer").DefaultView.Sort = sortExpression

' Bind the grid to the DataSet

footerGrid.DataSource = _

dataSet.Tables("Footer").DefaultView

footerGrid.DataBind()