jeudi 20 août 2015

Inner Join dataset error in VB.net 2010

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