''Connect To SQL Server to Pull News Feed and such. ' create a new SqlConnection object with the appropriate connection string Dim query As String = "SELECT title FROM news_feed WHERE active='1'" Dim connStr As String = "*************" Dim connection As New MySqlConnection(connStr) Dim cmd As New MySqlCommand(query, connection) connection.Open() Dim reader As MySqlDataReader reader = cmd.ExecuteReader() While reader.Read() Label1.Text = (reader.GetChar("title")) '<- Kind of Working! End While
Now Say title in the SQL table is Test; My Label1 Will now read T. I'm looking for it to read test however not just the first value. Taking a look to try to fix it, but thinking it might be something of a facepalm moment.