Add data to datagrid (VB.net) : DataGrid « Asp Control « ASP.Net






  1. ASP.Net
  2. Asp Control
  3. DataGrid

Add data to datagrid (VB.net)

<%@ Page Language=VB Debug=true %>
<%@ Import Namespace="System.Data" %>
<script runat=server>
Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs)
    If Not IsPostBack Then
        Dim MyDT As New DataTable
        Dim MyRow As DataRow
        MyDT.Columns.Add(New DataColumn("EmployeeID", _
            GetType(Int32)))
        MyDT.Columns.Add(New DataColumn("EmployeeFirstName", _
            GetType(String)))
        MyDT.Columns.Add(New DataColumn("EmployeeLastName", _
            GetType(String)))
        MyDT.Columns.Add(New DataColumn("BirthDate", _
            GetType(Date)))
        MyDT.Columns.Add(New DataColumn("Salary", _
            GetType(Single)))
        MyRow = MyDT.NewRow()
        MyRow(0) = 1
        MyRow(1) = "A"
        MyRow(2) = "M"
        MyRow(3) = "5/15/65"
        MyRow(4) = "40000"
        MyDT.Rows.Add(MyRow)
        MyRow = MyDT.NewRow()
        MyRow(0) = 2
        MyRow(1) = "J"
        MyRow(2) = "F"
        MyRow(3) = "7/22/75"
        MyRow(4) = "73050"
        MyDT.Rows.Add(MyRow)
        MyRow = MyDT.NewRow()
        MyRow(0) = 3
        MyRow(1) = "L"
        MyRow(2) = "S"
        MyRow(3) = "12/8/71"
        MyRow(4) = "62500"
        MyDT.Rows.Add(MyRow)
        MyRow = MyDT.NewRow()
        MyRow(0) = 4
        MyRow(1) = "S"
        MyRow(2) = "M"
        MyRow(3) = "3/15/54"
        MyRow(4) = "43222"
        MyDT.Rows.Add(MyRow)
        MyRow = MyDT.NewRow()
        MyRow(0) = 5
        MyRow(1) = "J"
        MyRow(2) = "P"
        MyRow(3) = "3/12/47"
        MyRow(4) = "52825"
        MyDT.Rows.Add(MyRow)

        dg1.DataSource = MyDT
        dg1.DataBind()
    End If
End Sub
</SCRIPT>
<HTML>
<HEAD>
<TITLE>DataGrid 1 Control Sample Page</TITLE>
</HEAD>
<BODY >
<form runat="server">
<Font Face="Tahoma">
<ASP:DataGrid 
    id="dg1" 
    runat="server"
/>

</Font>
</Form>
</BODY>
</HTML>








Related examples in the same category

1.BorderColor, CellPadding, CellSpacing for ASP:DataGrid (VB.net)
2.Font-Name, Font-Size for ASP:DataGrid (VB.net)
3.ForeColor, BackColor for ASP:DataGrid (VB.net)
4.AlternatingItemStyle-ForeColor, AlternatingItemStyle-BackColor for ASP:DataGrid (VB.net)
5.AlternatingItemStyle-Font-Name, AlternatingItemStyle-Font-Italic (VB.net)
6.HeaderStyle-BackColor, HeaderStyle-Font-Bold (VB.net)
7.Add button to asp:DataGrid (VB.net)
8.Add hyperlink a asp:datagrid (VB.net)
9.Add hyperlink to asp:datagrid table column (VB.net)
10.Add navigator to asp:datagrid (VB.net)
11.Set item style, header style and alternating item style for the asp datagrid (C#)