i'm trying to fill a dataset with this code
Dim objConexion As SqlConnection
objConexion = New SqlConnection
objConexion.ConnectionString = "Server=PILLAN\LATIN1;Database=Control;User Id=sa;Password=***;"
'
' Crear adaptador
Dim Da As New SqlDataAdapter("SELECT TOP (5) CONVERT(Varchar(13), FloatTableCaldera.DateAndTime, 103) AS Fecha, CONVERT(varchar(13), FloatTableCaldera.DateAndTime, 108) AS Hora, FloatTableCaldera.Val AS Valor, FloatTableCaldera.Millitm AS Militm, Equivalencia.Equivalencia as Indicador FROM dbo.FloatTableCaldera INNER JOIN Equivalencia ON FloatTableCaldera.TagIndex = Equivalencia.TagIndex ORDER BY FloatTableCaldera.DateAndTime DESC", objConexion)
'
' Crear conjunto de datos
Dim ds As New DataSet
objConexion.Open()
'
'utilizar el adaptador para llenar el dataset con una tabla
Da.Fill(ds)
objConexion.Close()
When i try to run in VS 2010 return this error.
Invalid object name 'FloatTableCaldera'.
But In Sql Server Managment i run the same sql without problem. Please anyone can help me because i don't see the error.
Aucun commentaire:
Enregistrer un commentaire