需要从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'

然后我喜欢将名称、地址、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屋！