[RESOLVED] [2008] How to put my value on from my data table to my label

[shyguyjeff]

elow everyone..i have a program that acts like a marquee to the left. but my problem is that i want to load all data from my datatable to my label so that it shows what is on my datagrid..on my label i want it to arrange all all my 100 rows and 12 columns data...could anyone help me to resolved my problem is?

Here is my code:

   
            Dim connStr As String = "Database=RENDEZVOUS;Server=10.100.0.202;Integrated Security=SSPI;Connect Timeout=500000"
            'Dim connStr As String = "Server=10.100.0.202;Database=RENDEZVOUS;Connect Timeout = 5000000"
            Dim myQuery As String = "SELECT StoreName, _10Qty, _10LCP, _20Qty , _20LCP , _50Qty , _50LCP , _70Qty , _70LCP , _30Qty , _30LCP , DateXtracted FROM salesmonitor Order by _10LCP+_20LCP+_70LCP+_50LCP Desc"

            Dim myConnection As SqlConnection = New SqlConnection(connStr)
            Dim myCommand As SqlCommand = New SqlCommand(myQuery, myConnection)


            Dim dt As New DataTable("SalesMonitoring")

            dt.Load(myReader)

            DataGridView1.DataSource = Nothing
            'Bind data table to datagrid
            DataGridView1.DataSource = dt

            myReader.Close()


            myDataSet = New DataSet("SaleMonitor")
            myDataSet.Tables.Add(dt)


           lblData.text = ???

Please help me...Thanks in advance guys...

[shyguyjeff]

need it badly guys..just want to learn how could i put it into the label arrange in accordance to rows...

[shyguyjeff]

help me experts there...