Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
<asplaceholder id="thisPlace" runat="server"/>
in code (and please keep in mind this is absolute bare bones):
Dim strSQL as String = "SELECT * FROM table" 'Uggg, better to write all the column names out
Dim objConn As System.Data.SqlClient.SqlConnection
Dim objComm As System.Data.SqlClient.SqlCommand
Dim ThisReader As System.Data.SqlClient.SqlDataReader
objConn = New System.Data.SqlClient.SqlConnection(GetConnectString())
objConn.Open()
objComm = New System.Data.SqlClient.SqlCommand("sql", objConn)
ThisReader = objComm.ExecuteReader()
If ThisReader.HasRows() Then
Dim i As Integer
For i = 0 To (ThisReader.FieldCount - 1)
Dim txtNew As New TextBox
txtNew.ID = ThisReader.GetName(i)
txtNew.Text = ThisReader.Item(i)
thisPlace.Controls.Add(txtNew)
Next
End If
ThisReader.Close()
objComm.Dispose()
objConn.Close()