how to display data in HTML table in asp.net vb.net

Question

I have a table in database named user. The columns are id, name, phone and address. I put a textbox as a search box so when the user search using the search box, it will display list of users related. I want to retrieve the list of data in a HTML table because I want to add an edit button for each line retrieved. I tried this code but it has a problem with ForEach function. When I separate as ForEach, it says For must end with Next.

<TABLE style="Z-INDEX: 113; POSITION: absolute; TOP: 368px; LEFT: 592px" id="Table1" border="1" cellSpacing="1" cellPadding="1" width="300">
<% for each(DataRow row in ds.Tables[0].Rows) { %>
  <TR>
     <td><%= row["columnName"] %></td>
   </TR><% } %>
</TABLE>

I already retrieved my data into SQLDataAdapter with this code:

Dim Adpt As New SqlDataAdapter(cm.CommandText, cnConnect)
Dim ds As New DataSet

I suggest that you use a GridView.

Aethan
– Aethan

2016-09-28 06:56:29 +00:00
Commented Sep 28, 2016 at 6:56 — Aethan
– Aethan, Commented Sep 28, 2016 at 6:56

balexandre · Accepted Answer · 2016-09-28 07:08:05Z

2

In ASP.NET, you have HTML Controls, such as <asp:panel>, <asp:button>, etc... and one of those controls is probably the most powerful (and complex) <asp:GridView> that allows you to bind data to the control and it will take care of display and editing.

The best way to know it, it's by example, and if you search youtube for asp gridview you will find several... give it a try, so you will be able to do something like:

<asp:GridView ID="my_gv" Runat="server"
              DataSourceID="myDataSource" DataKeyNames="id"
              AutoGenerateColumns="True"
              AllowPaging="True" />

There is plenty things to use with this control, try using the Visual Studio UI, as it will allow you to select some options...

(image from web article)

answered Sep 28, 2016 at 7:08

balexandre

75.4k47 gold badges240 silver badges352 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vijay chaudhary · Accepted Answer · 2016-09-28 10:53:12Z

Use this code in aspx page(form)

<asp:Repeater ID="rptCustomers" runat="server">
    <HeaderTemplate>
        <table cellspacing="0" rules="all" border="1">
            <tr>
                <th scope="col" style="width: 80px">
                    Customer Id
                </th>
                <th scope="col" style="width: 120px">
                    Customer Name
                </th>
                <th scope="col" style="width: 100px">
                    Country
                </th>
            </tr>
    </HeaderTemplate>
    <ItemTemplate>
        <tr>
            <td>
                <asp:Label ID="lblCustomerId" runat="server" Text='<%# Eval("CustomerId") %>' />
            </td>
            <td>
                <asp:Label ID="lblContactName" runat="server" Text='<%# Eval("ContactName") %>' />
            </td>
            <td>
                <asp:Label ID="lblCountry" runat="server" Text='<%# Eval("Country") %>' />
            </td>
        </tr>
    </ItemTemplate>
    <FooterTemplate>
        </table>
    </FooterTemplate>
</asp:Repeater>

and use this code in code behind means aspx.cs page

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.BindRepeater();
    }
}

private void BindRepeater()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT TOP 10 * FROM Customers", con))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
            {
                DataTable dt = new DataTable();
                sda.Fill(dt);
                rptCustomers.DataSource = dt;
                rptCustomers.DataBind();
            }
        }
    }
}

i use visual studio .net 2003.'configurationManager' does not work in this version

Collectives™ on Stack Overflow

how to display data in HTML table in asp.net vb.net

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related