How to disable column heading is clicked of DataGridView

Question

5.00/5 (1 vote)

See more:

Hello
When a column heading is clicked in a DataGridView, the default behavior is to order the grid rows based on the clicked column.I need to disable This..plz help

Posted 1-Aug-13 1:58am

ErBhati

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Syed Shabeer · Answer 1 · 2013-08-01T02:07:00

Solution 1

Try this

C#

foreach (DataGridViewColumn column in dataGridView.Columns)
{
    column.SortMode = DataGridViewColumnSortMode.NotSortable;
}

Posted 1-Aug-13 2:07am

Syed Shabeer

Comments

ridoy 1-Aug-13 8:14am

good one,+5

ErBhati 1-Aug-13 9:13am

Where i put this code
in form_load it not works

ErBhati · Answer 2 · 2013-08-26T23:38:00

Solution 3

i found solutions

if (e.RowIndex >= 0)

Posted 26-Aug-13 23:38pm

ErBhati

Updated 27-Jun-18 4:47am

v2

Comments

Ali Kweyu 27-May-22 14:38pm

Thanks I did this and it works
if (guna2DataGridViewstudent.Columns[e.ColumnIndex].Name == "Delete")
{
try
{
if (e.RowIndex >= 0)
{
DialogResult confirm = MessageBox.Show("Are you sure you want to delete ", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (confirm == DialogResult.Yes)
{
int id;
id = Convert.ToInt32(guna2DataGridViewstudent.Rows[e.RowIndex].Cells["Student_ID"].Value);

connect.openConnect();
try
{
SqlCommand command = new SqlCommand(" DELETE FROM Students WHERE Student_ID=@idtype", connect.GetConnection);
//command.Parameters = Add("", SqlDbType.VarChar).Value.TypeName;
command.Parameters.Add("@idtype", SqlDbType.VarChar).Value = id;
int result = command.ExecuteNonQuery();
if (result > 0)
{

MessageBox.Show("data deleted");
showTable();

}
else
{
MessageBox.Show("data fail");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connect.closeConnect();
}
}
}
}catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}

ridoy · Answer 3 · 2013-08-01T02:13:00

Check these..
http://stackoverflow.com/questions/4334983/best-way-to-disable-the-column-header-sorting-in-datagridview[^]
http://stackoverflow.com/questions/3965304/disable-datagridview-colum-header-to-allow-sorting[^]
http://stackoverflow.com/questions/4502442/how-to-disable-sort-in-datagridview[^]

bansidhar_kurup · Answer 4 · 2015-01-19T00:49:00

If you can extend the DatagridView you can override the Sort method with am empty one. This disables Sort for the DatagridView entirely.

C#

public override void Sort(DataGridViewColumn dataGridViewColumn, ListSortDirection direction)
{
      //base.Sort(dataGridViewColumn, direction);
}

Note: You cannot even programmatically sort any column.

How to disable column heading is clicked of DataGridView

4 solutions

Solution 1

Solution 3

Solution 2

Solution 4

Add your solution here

Preview 0