如何在一个文本框中显示多个值以从数据库中获取它们 [英] how to display multiple values in one textbox getting them from a database

问题描述

按钮get_email

Button get_email

Dim objt As New List(Of Email)
        Dim objbus As New Email
        objt = objbus.Get_Email()
        If objt.Count <> 0 Then
            For Each objbus In objt
                TxtTo.Text = objbus.Emaill
            Next
        End If

类电子邮件

Class Email

Public Function Get_Email() As List(Of Email)
        Dim objtela As New CData
        Dim objfem As New List(Of Cparameter)
        Dim objda As New List(Of Email)
        Dim dr As IDataReader
        dr = objtela.executespreturndr("E_Stud", objfem)
        Using dr
            While (dr.Read)

                Dim par As New Email
                populate_email(dr, par)
                objda.Add(par)
            End While
        End Using

        Return objda
    End Function

    Public Sub populate_email(ByVal dr As IDataReader, ByVal objwena As Email)
        objwena.Emaill = dr.GetString(0)
    End Sub

如何在一个文本框中显示多个值，这些值从数据库sql server 2008中的单个字段获取?

how to display multiple values in one textbox getting them from a single field in a database sql server 2008

推荐答案

我认为您正在尝试连接电子邮件地址. > 您可以这样做.

I think you are trying to concatenate Email Addresses.
You can do this way.

TxtTo.Text += objbus.Emaill +","

您可以使用String.Concat方法或StringBuilder类对.Net中的字符串提供各种操作.

You can use String.Concat method or StringBuilder class that provide various operation on string in .Net.

这篇关于如何在一个文本框中显示多个值以从数据库中获取它们的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！