将数据从SQL表显示到HTML表 [英] Displaying data from a SQL table to HTML table

问题描述

我在sql数据库中有一个名为user的表。我尝试检索该表中的数据。但是当我使用文本框时，只检索到一个数据。所以我想检索html表中的数据，以便数据在列表中。 iam使用vb.net和visual studio 2003



我尝试过：

i have a table in sql database named user. i try to retrieve data in that table. but when i use textbox, only one data retrieved. so i would like to retrieve the data in a html table so that the data would be in a list. iam using vb.net and visual studio 2003

What I have tried:

Dim cnConnect As New SqlConnection
        cnConnect.ConnectionString = conn.ConnectionString
        cnConnect.Open()
        Dim cm As New SqlCommand
        cm.CommandText = "SELECT * FROM user "
        Dim connection As New SqlConnection(conn.ConnectionString)
        Dim dataadapter As New SqlDataAdapter(cm.CommandText, connection)
        Dim ds As New DataSet
        connection.Open()
        dataadapter.Fill(ds, "user")
        connection.Close()
        DataGrid1.DataSource = ds
        DataGrid1.DataMember = "user"
        cnConnect.Close()

推荐答案

不需要多个SqlConnection。

试试这个 -

Multiple SqlConnection not required.
Try this -

Dim cnConnect As New SqlConnection
        cnConnect.ConnectionString = conn.ConnectionString
        cnConnect.Open()
        Dim cm As New SqlCommand
        cm.CommandText = "SELECT * FROM user";
        Dim dataadapter As New SqlDataAdapter(cm.CommandText, cnConnect)
        Dim ds As New DataSet
        dataadapter.Fill(ds, "user")
        DataGrid1.DataSource = ds
        DataGrid1.DataMember = "user";
        cnConnect.Close()

参考：使用Windows窗体中的DataSet绑定/填充/填充DataGridView（WinForms）C＃和VB.Net中的应用程序 [ ^ ]



希望，它有帮助：）

Reference: Bind / Fill / Populate DataGridView with DataSet in Windows Forms (WinForms) Application in C# and VB.Net[^]

Hope, it helps :)

这篇关于将数据从SQL表显示到HTML表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！