mercredi 6 mai 2015

Select from sql in vb and display in aspx page

Just wanna select a word from database and display in aspx page

Backend

Using da As New SqlDataAdapter
        con.Open()
        cmd.CommandText = "SELECT value_en as value FROM tbl_language WHERE element_id = 'a1';"
        da.SelectCommand = cmd
        Dim dt As New DataTable
        da.Fill(dt)
        Dim WordValue As String = dt.Rows(0).Item(0)
End Using

in aspx page

<%=WordValue%>

whats wrong here?

Aucun commentaire:

Enregistrer un commentaire