Sort Result set

Sort Result set

I build a connect for my page with the database and then read all rows and show it in a table, I want to change the view of my data to be sorted uppon a specific column when click on the column name, so what to do? I think of two choices: 1- if the column name is a button. 2- if the column name is a hyperlink.

also how to delete a row from the table? if I have a button beside each row called delete, if you have a better idea please get it for me but please I need the easer one.

for the both I don't know how to connect the code and how call a function to do sorting and reiew data again. pleasse I need a complete example

thanks Jar

View Answers

April 9, 2011 at 4:08 PM

Hi,

Have a look at the following link: Shorting Table View By Column Name

Thanks

Ads









Related Tutorials/Questions & Answers:
Sort Result set
Sort Result set   I build a connect for my page with the database and then read all rows and show it in a table, I want to change the view of my data to be sorted uppon a specific column when click on the column name, so what
Result Set one to many mapping
Result Set one to many mapping  Suppose there are 5 tables in database named A,B,C,D and E. A has one to many relationship with B,C,D and D has one... Suppose result contains single entry of One record for A, Two records for B
Advertisements
how to sort the result of this 2 class program in java.....????
how to sort the result of this 2 class program in java.....????  package setget1_method; import java.util.Scanner; public class Main { { { Scanner input = new Scanner(System.in); LBook[] book = new LBook[5]; String
How to add a columns with a button set to a Jtable built with database result set
How to add a columns with a button set to a Jtable built with database result set  hi, i have to build a gui to display account numbers and account... that button column to the table which is built with database result set. i would thank
Hibernate Narrowing Criteria Result Set
Hibernate Narrowing Criteria Result Set In this tutorial you will learn how to narrow the Criteria result set. In Hibernate result set can be narrowed... how can you narrow the result set. For creating this example at first I have
how to store the REsult Set values in array and loop through it in java?
how to store the REsult Set values in array and loop through it in java?  I have two tables Slink and Locate Slink has column name Slinkid ,locate has Locateid,Slinkid. Slink has 9 rows 1,2,3,4,5,6,7,8,9 Locate has
how to store the REsult Set values in array and loop through it in java?
how to store the REsult Set values in array and loop through it in java?  I have two tables Slink and Locate Slink has column name Slinkid ,locate has Locateid,Slinkid. Slink has 9 rows 1,2,3,4,5,6,7,8,9 Locate has
Mysql ASC Order
; Mysql ASC Order is used to sort the result set by ascending or descending order. The Order by CLAUSE sort the result by specified column. Understand... | +------+---------+ Query The Query given below sort the records from 'stu' in ascending order
Hibernate Criteria Setfirst Result
Hibernate Criteria SetFirstResult Result The setFirstResult of hibernate criteria API is used for setting no of records to be fetched from the table criteria.setFirstResult(1); An example of set first is given below
SQL ORDER BY
; The ORDER BY keyword sort the table result set by a specified column. You want to sort the records in ascending order,  you can use the ASC keyword... BY keyword sort the table result set by a specified column
SEARCH AND SORT
SEARCH AND SORT  Cam any one provide me the code in java that : Program to search for MAX,MIN and then SORT the set using any of the Divide and conquer method
bubble sort
bubble sort  write a program in java using bubble sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  how many arrays needed for insertion sort and why
bubble sort
bubble sort  how to calculate the number of passes in bubble sort
display result
display result  i want a code that takes input from user through dropdown box and display the result into table.all the values regarding the user input must be displayed. i am using mysql database   hi i want study
buble sort
buble sort  ascending order by using Bubble sort programm   Java BubbleSort Example
Sort
quick sort
; System.out.println(" Quick Sort\n\n"); System.out.println("Values Before the sort:\n"); for(i = 0; i < array.length; i++){ array[i...("Values after the sort:\n"); for(i = 0; i <array.length; i
quick sort
; System.out.println(" Quick Sort\n\n"); System.out.println("Values Before the sort:\n"); for(i = 0; i < array.length; i++){ array[i...("Values after the sort:\n"); for(i = 0; i <array.length; i
quick sort
; System.out.println(" Quick Sort\n\n"); System.out.println("Values Before the sort:\n"); for(i = 0; i < array.length; i++){ array[i...("Values after the sort:\n"); for(i = 0; i <array.length; i
ModuleNotFoundError: No module named 'result'
ModuleNotFoundError: No module named 'result'  Hi, My Python... 'result' How to remove the ModuleNotFoundError: No module named 'result'... to install padas library. You can install result python with following command
Insertion Sort Applet
Insertion Sort Applet  Please All , I need Insertion sort applet program
Insertion Sort Applet
Insertion Sort Applet  I need Insertion Sort Applet code was design by Dr. Daniel Liang Please
insertion sort applet code
insertion sort applet code  i need Insertion Sort Applet Program
ModuleNotFoundError: No module named 'sort'
ModuleNotFoundError: No module named 'sort'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'sort' How to remove the ModuleNotFoundError: No module named 'sort' error
result after compilation
result after compilation  public class MainCls { public static void main(String argv) { System.out.println("My text
string array sort
string array sort  Hi. How to sort a string array

Ads