Partial Public Class _Default
Inherits System.Web.UI.Page
Dim sqlCon As New SqlClient.SqlConnection
Dim sqlAdp As New SqlClient.SqlDataAdapter
Dim sqlCmd As New SqlClient.SqlCommand
'Dim ds As DataSet, dView As DataView
Dim ds As New DataSet
Dim ConnectionString As String
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
sqlCmd.Connection = sqlCon
sqlCon.ConnectionString = "XX"
sqlCmd.CommandText = "YY"
sqlCmd.CommandType = CommandType.StoredProcedure
sqlAdp.SelectCommand = sqlCmd
ds = New DataSet
sqlAdp.Fill(ds, "SuppliedFile")
GridView1.DataSource = ds.Tables("Suppliedfile")
GridView1.DataBind()
GridView1.Visible = True
end sub
end class
<asp:GridView ID="GridView1" runat="server" AllowSorting="True"
AutoGenerateColumns="False" BackColor="Red">
</asp:GridView>
