Hi
i need to display data on Button. I am using MSSQL 2014
I have tried below code. But I don't know how to bind the data with button
Pls advice me.
Thank you.
Maideen
Dim query As String = String.Format("SELECT roomno from AD_Rooms_Master order by roomno")
Try
Dim dt As DataTable = GetData(query)
For i As Int32 = 1 To 10
Dim btn As New Button()
btn.ID = "btn" & i
btn.Text = i.ToString()
AddHandler btn.Click, AddressOf btnLoadButton_Click
pnl_btns.Controls.Add(btn)
Next
Catch ex As Exception
ScriptManager.RegisterStartupScript(Me, Me.[GetType](), "Message", "alert('Error occured : " & ex.Message.ToString() & "');", True)
Finally
cmd = Nothing
conn.Close()
End Try