Dim DS As DataSet Dim MyConnection As New SqlConnection Dim MyCommand As SqlDataAdapter Private SqlCn As New SqlConnection(GetDBConnectionString) MyCommand = New SqlDataAdapter(strSQL, SqlCn) DS = New DataSet("MyProductDS") MyCommand.Fill(DS, "Product") grdProducts.DataSource = DS.Tables("Product").DefaultView Me.DataBind() MyConnection.Close()HTML grid tag (if it matters ... )
<asp:DataGrid id="grdProducts" runat="server" BackColor="#DEBA84" BorderStyle="None" AllowSorting="True" AllowPaging="True" HorizontalAlign="Justify" CellSpacing="1" CellPadding="1" BorderWidth="1px" BorderColor="#DEBA84"> <EditItemStyle Wrap="False"></EditItemStyle> <Columns> <mbrsc:RowSelectorColumn Visible="False" AllowSelectAll="True"></mbrsc:RowSelectorColumn> <asp:EditCommandColumn ButtonType="PushButton" UpdateText="Update" CancelText="Cancel" EditText="Add"> </asp:EditCommandColumn> <asp:ButtonColumn Text="Remove" ButtonType="PushButton" CommandName="Delete"></asp:ButtonColumn> <asp:TemplateColumn HeaderText="Qty"> <ItemTemplate> <asp:TextBox id="txtQty" runat="server" Width="22px">1</asp:TextBox> </ItemTemplate> </asp:TemplateColumn> </Columns> <PagerStyle VerticalAlign="Middle" HorizontalAlign="Center" ForeColor="#8C4510" Position="TopAndBottom" Wrap="False" Mode="NumericPages"></PagerStyle> </asp:DataGrid></TD>My humble thanks in advance,
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams