如何使用连接字符串从数据库中获取数据 [英] How to get the data from database using connection string

问题描述

嗨
我是vb.net的新手，我的问题是我正在使用组合框，我需要使用连接字符串从sql server获取数据，我已经尝试了下面的代码。它是不工作



我尝试过：

Hi I'm a new to vb.net ,my question is I am Using a Combo box and I need to get the data from sql server using connection string and I have tried the below code.It is not working

What I have tried:

Imports System
Imports System.Collections.Generic
Imports System.Web
Imports System.Xml
Imports System.Windows.Forms
Imports System.Data.SqlClient
Imports System.Configuration


Public Class Form1

    Private Sub ComboBox1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles ComboBox1.SelectedIndexChanged
        Dim VB = ConfigurationManager.ConnectionString["HMDB"].ConnectionString
        Using Con = New SqlConnection(VB)
            Dim SqlText = "Select DocEntry from dbo.Master1"
            Dim cmd = New SqlCommand(SqlText, Con)
            Con.Open()
            ComboBox1.DataSource = cmd.ExecuteReader()
            ComboBox1.DataBind()

        End Using
    End Sub
End Class

______________________________________________________________________________________

App.config

______________________________________________________________________________________
App.config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <connectionstrings>
  <connectionStrings>
      <add name ="HMDB"
           connectionString ="Data Source=DESKTOP-68VGRJG;Database=master;integrated security =SSPI"/>
            </connectionStrings>
</configuration>
</configuration>

推荐答案

请参阅如何从VB.Net中的数据集填充组合框 [ ^ ]

这篇关于如何使用连接字符串从数据库中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！