Gridview Sorting in C#

Jes Sie

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar5y ago
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/
+1
Jes Sie5y ago
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.
+1
Jignesh Kumar5y ago
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.
+1
Murali Krishnan5y ago
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
+1