how to use radio buttons to sort in listview

[melvados]

Hi experts and all, I have encountered and in need of some help with checkboxes and listview. Just started to learn vs05 programming. This is my first thread by the way...

I want to sort out the data (as shown in the attachment) by using the check boxes and the listview and i am really stuck. For the list view, I am using an access file to read the data,

So can anyone help me. Really appreciate for any help/advices

[cloud255]

hi,

Apologies for the earlier post, please ignore it, i was being an idiot.

ok this should be more helpful:

your data bindings seem ok.

the syntax for sorting a list view seems a bit strange to me, anywy here it is:

first you have to specify a sorting metod,

listView1.Columns["ColumnName"].ListView.Sorting = SortOrder.Ascending;

then you can tell the control to sort on that column,

listView1.Columns["ColumnName"].ListView.Sort();

so use a string which gets a value from a swith to give it the name of the column which you want to sort

then replace "ColumnName" with the string variable,

that sould work.

do this after you have added all your items to the listview.

hope this works...

[melvados]

Hi there, really appreciate for your reply. Could you explain to me in a more detailed yet easier manner?

Also by the way, my list view is populated from the access file where I have write it in this manner and I don't seem to be using any datagridview...

Private Sub LoadProjects()
        'Declare variables
        Dim objListViewItem As ListViewItem
 
        'Initialize a new instance of the data access base class
        Using objData As New WDABase
            Try
                'Get all projects in a DataReader object
                objData.SQL = "usp_SelectProjects"
                objData.InitializeCommand()
                objData.OpenConnection()
                objData.DataReader = objData.Command.ExecuteReader
 
                'See if any data exists before continuing
                If objData.DataReader.HasRows Then
 
                    'Clear previous list
                    lvwParts.Items.Clear()
 
                    'Process all rows
                    While objData.DataReader.Read()
 
                        'Create a new ListViewItem
                        objListViewItem = New ListViewItem
 
                        'Add the data to the ListViewItem
                        objListViewItem.Text = _
                            objData.DataReader.Item("PartName")
                        objListViewItem.Tag = objData.DataReader.Item("PartID")
 
                        'Add the sub items to the listview item
                        objListViewItem.SubItems.Add( _
                            objData.DataReader.Item("PartCode"))
                        objListViewItem.SubItems.Add( _
                            objData.DataReader.Item("SequenceNumber"))
                        objListViewItem.SubItems.Add( _
                            Format(objData.DataReader.Item("LastUpdateDate"), "g"))
 
                        'Add the ListViewItem to the ListView control
                        lvwParts.Items.Add(objListViewItem)
 
                    End While
 
                End If
 
                objData.DataReader.Close()
            Catch ExceptionErr As Exception
                MessageBox.Show(ExceptionErr.Message, strAppTitle)
            End Try
        End Using
 
        'Cleanup
        objListViewItem = Nothing
 
    End Sub
 

Could it still worked in this way from the code you given?
Am really sorry about this inconvenience, for I am just starting out.