在gridview中修改和显示数据库中的内容 [英] modiying and displaying the content from database in a gridview

问题描述

在数据库表中，如下所示

In database table present as below

ID     Items
100    tea
100    coffee
100    juice

我想在gridview中显示上表

I want to display above table in gridview as

ID     Items
100    tea
       coffee
       juice

推荐答案

Dim sadapt As New OleDbDataAdapter("SELECT [ID],[Items] FROM tablename", con)
        Dim ds As DataSet = New DataSet
        Dim prevID As Integer = 0
        dim intRows as integer
        sadapt.Fill(ds)
        dgvDetails.Rows.Clear()
        dgvDetails.RowCount = 1
        For intRow = 0 To ds.Tables(0).Rows.Count - 1
            If prevID <> ds.Tables(0).Rows(intRow).Item("ID").ToString Then
                dgvDetails.Rows(intRow).Cells("ID").Value = ds.Tables(0).Rows(intRow).Item("ID").ToString
                prevID = ds.Tables(0).Rows(intRow).Item("ID").ToString
            End If
            dgvDetails.Rows(intRow).Cells("Items").Value = ds.Tables(0).Rows(intRow).Item("Items").ToString
            dgvDetails.RowCount = dgvDetails.RowCount + 1
        Next

这里dgvdetails是datagridview。

和con是连接

here dgvdetails is datagridview.
and con is connection

这篇关于在gridview中修改和显示数据库中的内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！