<asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 128px; POSITION: absolute; TOP: 56px"
runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderWidth="1px"
BorderStyle="Solid" CellPadding="3" GridLines="Vertical" ForeColor="Black" Height="120px">
<SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#000099"></SelectedItemStyle>
<AlternatingItemStyle BackColor="#CCCCCC"></AlternatingItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="White" BackColor="Black"></HeaderStyle>
<FooterStyle BackColor="#CCCCCC"></FooterStyle>
<Columns>
<asp:BoundColumn DataField="ProductID" HeaderText="ProductID"></asp:BoundColumn>
<asp:BoundColumn DataField="ProductName" HeaderText="ProductName"></asp:BoundColumn>
<asp:BoundColumn DataField="UnitPrice" HeaderText="UnitPrice"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="Discontinued">
<ItemTemplate>
<asp:CheckBox id="CheckBox1" runat="server" Checked='<%# DataBinder.Eval(Container.DataItem,"Discontinued") %>' >
</asp:CheckBox>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
<PagerStyle HorizontalAlign="Center" ForeColor="Black" BackColor="#999999"></PagerStyle>
</asp:DataGrid></form>
----------------------------------------------------------------
 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        Dim obcon As New SqlClient.SqlConnection("server=ws3;database=Northwind;uid=sa;pwd=sa")
        Dim da As New SqlClient.SqlDataAdapter("SET ROWCOUNT 10 select* from Products", obcon)
        Dim dt As New DataTable
        da.Fill(dt)
        DataGrid1.DataSource = dt
        DataGrid1.DataBind()


    End Sub