16,554
社区成员
发帖
与我相关
我的任务
分享
‘引入命名空间
Imports System.Data
Imports System.Data.SqlClient
Public Sub ServerTime()
Dim ConnectionString As String = "Data Source=.;Initial Catalog=master;User ID=sa;Password=123"
Dim MyConn As New SqlConnection(ConnectionString)
MyConn.Open()
Dim MyComm As SqlCommand
MyComm = New SqlCommand("SELECT GETDATE()", MyConn)
Dim RD As SqlDataReader
RD = MyComm.ExecuteReader ’获取数据
RD.Read()
Me.Label1.Text = RD(0)
RD.Close()
MyConn.Close()
MyConn.Dispose()
MyComm.Dispose()
End Sub
这样写应该没啥问题,可以取得SQL服务器时间!
不过建议LZ写个函数,或者使用SqlHelper函数,
比如SQL计算查询结果语句,返回查询结果
''' <summary>
''' 执行一条计算查询结果语句,返回查询结果(object)。
''' </summary>
''' <param name="SQLString">计算查询结果语句</param>
''' <returns>查询结果(object)</returns>
Public Function GetSingle(ByVal SQLString As String) As Object
Dim ConnectionString As String = "Data Source=.;Initial Catalog=master;User ID=sa;Password=123"
Using connection As New SqlConnection(ConnectionString)
Using cmd As New SqlCommand(SQLString, connection)
Try
connection.Open()
Dim obj As Object = cmd.ExecuteScalar()
If ([Object].Equals(obj, Nothing)) OrElse ([Object].Equals(obj, System.DBNull.Value)) Then
Return Nothing
Else
Return obj
End If
Catch e As System.Data.SqlClient.SqlException
connection.Close()
Throw e
End Try
End Using
End Using
End Function
下面传入sql语句直接调用即可;
Me.Label1.Text = GetSingle("select getdate()")
希望对你有所帮助,供LZ参考!!