将值加载到组合框时出错 [英] Error while loading value to combobox

问题描述

嗨

我正在使用vb lang。和数据库作为oracle



i有一个有两行的表。

i需要加载一行作为文本而另一行作为值。



我的代码如下：

hi
im using vb lang. and database as oracle

i have a table which hav two rows .
i need to load one row as text and other as value .

my code is given below

Private Sub GetAllTemp()

       Try
           conn.Open()
           Dim sql As String = "SELECT T_Name, Sno FROM UPLOADTEMPLATE"
           Dim cmd As New OracleCommand(sql, conn)
           cmd.CommandType = CommandType.Text
           Dim oraDataAdapter1 As New OracleDataAdapter
           oraDataAdapter1.SelectCommand = cmd
           Dim dtuser As New DataTable
           oraDataAdapter1.Fill(dtuser)
           cbTemplate.DataSource = dtuser
           cbTemplate.DisplayMember = "T_Name"
           'cbTemplate.ValueMember = "Sno"
           conn.Close()


       Catch ex As Exception

       End Try

   End Sub

Private Sub cbTemplate_SelectedIndexChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbTemplate.SelectedIndexChanged


       MsgBox(cbTemplate.SelectedValue.ToString)

   End Sub

加载值到组合框时代码自动触发索引更改。

on loading values to combobox the code automatically triggers index change.

推荐答案

这篇关于将值加载到组合框时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！