Saturday, June 7, 2014

How to Use Data Reader In ListView VB.net

TryQuery = "Select * From tbl_studinfo Order by stud_id"MySqlCommand = New MySqlCommand(Query, CNN)MySqlDataReader = MySqlCommand.ExecuteReaderListView1.Items.Clear()Do While MySqlDataReader.ReadWith ListView1.Items.Add(MySqlDataReader(0)).SubItems.Add(MySqlDataReader(1)).SubItems.Add(MySqlDataReader(2)).SubItems.Add(MySqlDataReader(3)).SubItems.Add(MySqlDataReader(4)).SubItems.Add(MySqlDataReader(5)).SubItems.Add(MySqlDataReader(6)).SubItems.Add(MySqlDataReader(7)).SubItems.Add(MySqlDataReader(8))End WithLoopCatch ex As ExceptionMessageBox.Show(ex.Message.ToString, "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error)FinallyMySqlDataReader.Close()