首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >如何在自举表中查看mySql中的数据?

问如何在自举表中查看mySql中的数据?
EN

Stack Overflow用户
提问于 2019-01-09 23:30:52
回答 1查看 168关注 0票数 0

实际上我已经开始使用VB.NET和ASPX了,我会把我的数据库中的数据添加到我的引导表中,实际上这是一个静态表的代码,其中<'td'>的值应该从数据库中获取,并从数据库中为每一项创建<'tr'>。

代码语言:javascript
复制
<div class="col-md-12">
                    <div class="card strpied-tabled-with-hover">
                        <div class="card-header ">
                            <h4 class="card-title">Realco App</h4>
                            <p class="card-category">Qui sono presentit tutte le versioni dell'App Realco</p>
                        </div>
                        <div class="card-body table-full-width table-responsive">
                            <table class="table table-hover table-striped">
                                <thead>
                                    <th>Software</th>
                                    <th>Versione</th>
                                    <th>Release Data</th>
                                    <th>Download</th>
                                </thead>
                                <tbody>
                                    <tr>
                                        <td>App2</td>
                                        <td>0.9.0</td>
                                        <td>02/01/2019</td>
                                        <td><a href="#" aria-disabled="true"  data-version="App2.apk">Download</a></td>
                                    </tr>
                                    <tr>
                                        <td>App</td>
                                        <td>0.2.3</td>
                                        <td>02/01/2019</td>
                                        <td><a href="#" aria-disabled="true" data-version="App.apk">Download</a></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>

虽然这里是我连接到DB并从clienti_sw表中获取数据的VB.NET部分,但现在我需要一些关于如何将这些数据添加到表中的建议。

代码语言:javascript
复制
   Dim SQLConnect As String = ConfigurationManager.ConnectionStrings("myConnectionString").ConnectionString

    Dim con As New MySqlConnection(SQLConnect)
    Dim cmd As New MySqlCommand

    cmd.Connection = con
    con.Open()

    cmd.CommandText = "SELECT * FROM clienti_sw"



    con.Close()
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2019-01-10 05:10:03

行内注释

代码语言:javascript
复制
Private Sub OPCode()
    Dim SQLConnect As String = ConfigurationManager.ConnectionStrings("myConnectionString").ConnectionString
    'This is where you collect the downloaded data
    Dim dt As New DataTable
    'The using block insures that your database objects are closed and disposed releasing any
    'unmanaged resources
    Using con As New MySqlConnection("Your connection string")
        'You can pass the command text and the connection to the constructor
        'of the command
        Using cmd As New MySqlCommand("SELECT * FROM clienti_sw", con)
            con.Open()
            dt.Load(cmd.ExecuteReader)
        End Using
    End Using
    'In a WinForms app the datatable can be bound
    DataGridView1.DataSource = dt
    'Not sure how this is done in asp
    GridView1.DataSource = dt
    GridView1.DataBind()
End Sub
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/54113431

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档