Hi,
I am learning ASP.net. I connected to database but can’t figure out how to write record ID to label. Below is the code:
Dim strConnection As String = ConfigurationManager.ConnectionStrings("objConn").ConnectionString
Dim objConn As New SqlConnection(strConnection)
objConn.Open()
Dim dAdapter As New SqlDataAdapter
dAdapter.SelectCommand = New SqlCommand("SELECT * FROM tblCMS", objConn)
Dim dSet As New DataSet
dAdapter.Fill(dSet)
objConn.Close()
I want to write first record “ID” to a label named “lblWelcome” in ASP.net page.
Please advice.