需要从SQL查询中获取价值 [英] need to get value from sql query

问题描述

通过ADO，我喜欢执行以下查询：

Through ADO,I like to do the following query:

    select name, address, zip from terr where id = '33334'

然后我喜欢给变量分配名称，addess和zip，以便以后可以分配在我的程序中。
我该如何使用VB.NET ADO？

I like then to assign name, addess, zip to variables so that I can assign it later in my program. How do I do this with VB.NET ADO?

推荐答案

尝试一些类似的事情：

  Dim dbName As String
  Dim dbAddress As String
  Dim dbZip As String
  Using connObj As New SqlClient.SqlConnection("<connectionString>")
     Using cmdObj As New SqlClient.SqlCommand("select name, address, zip from terr where id = '33334'", connObj)
        connObj.Open()
        Using readerObj As SqlClient.SqlDataReader = cmdObj.ExecuteReader
           'This will loop through all returned records 
           While readerObj.Read
              dbName = readerObj("name").ToString
              dbAddress = readerObj("address").ToString
              dbZip = readerObj("zip").ToString
              'handle returned value before next loop here
           End While
        End Using
        connObj.Close()
     End Using
  End Using

此外，您应该研究参数化where子句的值。

Also, you should look into parameterizing the value for the where clause.

这篇关于需要从SQL查询中获取价值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！