Fill GridView

[shapper]

Hello,

I am working on an Asp.Net 2.0 web site.
In have a GridView which I want to fill using a DataSource Function.
What data type should I use to how to get the data from the database?

Here is my DataSource function with "??????" on the 2 places where I am
having problems.

Function DataSource() As ??????

' Define connection
Dim connection As New
SqlClient.SqlConnection("MyConnectionString")

' Define command
Dim command As New SqlClient.SqlCommand
With command
.CommandText = "MyCommand"
.Connection = connection
.CommandType = CommandType.StoredProcedure
End With

' Execute the command
connection.Open()
???????????????
connection.Close()

End Function

Thanks,
Miguel

 

[David R. Longnecker]

The part you're missing is dropping it into a Dataset, table, or row (depending
on your expect returns) from the SqlDataAdapter.

--

Include System.Data
Include System.Data.SqlClient

Dim connection as New SqlConnection("MyConnectionString")
Dim command as New SqlCommand
Dim adapter as New SqlDataAdapter(command)

With command
.Command.Text = "MyCommand"
.Connection = connection
.CommandType = CommandType.StoredProcedure
End With

Dim ds as New DataSet()
adapter.fill(ds)

connection.Close()

GridView1.DataSource = ds
GridView1.DataBind()

--

Apologize in advance if some of the exact syntax is a bit off--trying to
convert from C# to VB (fun times).

-dl