can u help me about this . . .
when i click the column header of datagrid it will sort automatically
Shodow
3
Junior Poster
Recommended Answers
Jump to PostDo you have any code on the datagrid?
Or just by clicking on the column header automatically sorts your records?
Jump to PostGet the column that the user clicked on to get the database field value. Now reload the grid with the data sorted as per the users selection.
rs.Open "SELECT * FROM MyTableName ORDER BY " & "'" & UserValueChosen & "'" Set Datagrid1.Datasource = rs
Jump to PostShow me all the code you have to determine on which column you have clicked and then the code to open the recordset and re-populate the grid,
Jump to PostYour code above is to add a new record. What code are you using to populate the datagrid with your data? Are you using a datacontrol or code?
Jump to PostThe data control will not work. You need to set the grid's datasource AFTER you select the order by -
Dim conn as ADODB.Connection Dim Rs As ADODB.Recordset Set conn = new ADODB.Connection Set Rs = New ADODB.Recordset Conn.Open = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\YourDatabaseName.MDB;Persist Security …
All 27 Replies
abelingaw
69
Posting Whiz in Training
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Shodow
3
Junior Poster
AndreRet
511
Senior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.