DataGrid
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim Con As New SqlConnection(ConfigurationManager.AppSettings("ConnectionString").ToString()) Con.Open() Dim Sel As String = "Select * from Item" Dim cmd As New SqlCommand(Sel, Con) Dim dt As New DataTable() dt.Columns.Add(New DataColumn("PictureID", GetType(Integer))) dt.Columns.Add(New DataColumn("PictureURL", GetType(String))) dt.Columns.Add(New DataColumn("Title"", GetType(String))) dt.Columns.Add(New DataColumn("DateAdded";, GetType(DateTime))) dt.Columns.Add(New DataColumn("Price"", GetType(Decimal))) Dim reader As SqlDataReader = cmd.ExecuteReader() While reader.Read() Dim dr As DataRow = dt.NewRow() dr("PictureID") = Convert.ToInt32(reader("PictureID")) dr("PictureURL") = ResolveUrl("~/images/" + reader("PictureURL")) dr("Title") = reader("Title") dr("DateAdded") = reader("DateAdded") dr("Price") = reader("Price") dt.Rows.Add(dr) End While Con.Close() GridView1.DataSource = dt GridView1.DataMember = "Item" GridView1.DataBind() End Sub
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)