Gridview Sorting in C#

Question

Hello everyone. I have a public method to display data from the database to a grid view, say for example MyMethod(string param1, string param2). This method is using a stored procedure. Now, how can I sort my gridview? I research already for several hours and all of the samples that I found shows only a method without a parameter or is using a SQL query and not a stored procedure. Thank you for letting me understand this thing. Cheers

Jignesh Kumar · Answer

Hi Hold on, If you want to do without procedure you can do vai DataTable and viewState, Please folloe this one, https://www.c-sharpcorner.com/UploadFile/009464/gridview-sorting-example-in-Asp-Net-using-C-Sharp/

Jes Sie · Answer

Thank you all for your reply. As I was explaining in my question, I already have a stored procedure created, and below is my public function: public DataTable MyPublicFunction( string param1, string param2) { using (SqlConnection con = DBCS.GetDbCon()) { SqlCommand cmd = new SqlCommand( "sprs_GetParam_ByProjectID" , con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue( "@param1" , param1); cmd.Parameters.AddWithValue( "@param2" , param2); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return dt; } } Is there a way to make sorting without changing my stored procedure? I don't want to change my stored procedure because it only complicates things. I want to make a sorting via backend only...if it is possible with my current situation. Again thank you.

Jignesh Kumar · Answer

Hi Hold On, If you want to achieve via Store Procedure then you can find here, https://www.c-sharpcorner.com/article/effective-paging-sorting-and-filtering-using-sql-server-stored-procedure/ Just call this procedure on sorting event of your grid view with required parameter.

Murali Krishnan · Answer

If you using asp.net please consider below link https://www.c-sharpcorner.com/UploadFile/b8e86c/paging-and-sorting-in-Asp-Net-gridview/ If you using others like MVC, please mention