sql语句返回值的问题

Question

怎么把一个求平均数的SQL语句的结果返回给VB.NET的一个文本框呢？

Answer 1

唉~   先用存储过程的返回参数吧。  本来以为不用存储过程也可以实现的呢？

Answer 2

你好！

     SqlComand类执行SQL 语句，然后把结果赋给TextBox就可以了！

Public Sub ReadOrderData(ByVal connectionString As String)
  Dim queryString As String = _
    "SELECT OrderID, CustomerID FROM dbo.Orders;"
  Using connection As New SqlConnection(connectionString)
    Dim command As New SqlCommand(queryString, connection)
    connection.Open()
    Dim reader As SqlDataReader = command.ExecuteReader()
    Try
      While reader.Read()
        Console.WriteLine(String.Format("{0}, {1}", _
          reader(0), reader(1)))
      End While
    Finally
      ' Always call Close when done reading.
      reader.Close()
    End Try
  End Using
End Sub

---

周雪峰

Answer 3

你好，

概括来说就2个基础步骤：

1. 执行Sql得到返回值

2. 设置到TextBox.

具体取决于你怎么建表的，把结果放到DataTable里也可以，用存储过程也行。周雪峰的代码你可以参考一下，不错的。

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework!