in my asp.net+vb web with access database i iam willing to show a marquee with live data from database.
.aspx code
<marquee behavior="scroll" direction="left">
<div ><asp:Label ID="Label1" runat="server" Text="Label1"></asp:Label></div></marquee>
.vb code
Dim ConString As String = ConfigurationManager.ConnectionStrings("baijuep").ConnectionString
Dim con As New SqlConnection(ConString)
Dim CmdString As String = "SELECT KNo, companyto FROM (InOut) where PosnASOn >= now()-2"
Dim Adpt As New SqlDataAdapter(CmdString, ConString)
Dim KNo As New DataSet()
Adpt.Fill(KNo)
For Each dr As DataRow In KNo.Tables(0).Rows
Label1.Text &= dr("KNo").ToString() + "<br />"
Next
End Sub
when i use the query (SELECT KNo, companyto FROM (InOut) where PosnASOn >= now()-2)
in query analyser it works fine and the data is displayed
but when i use the complete code .vb is not dispying data in to label