How to sort the datagridview data.when I click column header in C# windows application

Question

0.00/5 (No votes)

See more:

I have a datagridview in that edit and delete buttons there.I am loading
datagridview from the database table.And I click the datagridview Edit button respective data showing in the respective textboxes fine.and i click submit button data is saving database and showing datagridview.For this purpose used datagridview cellcontent click event.what i want is if i click id column header on datagridview data needs to sorted.How to do that.I am getting Argument out of Range Exception "Index out of range Exception".Plaese help me on this.

What I have tried:

C#

<blockquote class="quote"><div class="op">Quote:</div> 

    private void dgvwDtls_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            ChqMngrBsns.Masters.BankInfo bnkinfo = new ChqMngrBsns.Masters.BankInfo();

            bnkid = Convert.ToInt32(dgvwDtls.Rows[e.RowIndex].Cells["bankid"].Value);
            if (dgvwDtls.Columns[e.ColumnIndex].Name == "Edit" && e.RowIndex >= 0)
             {
                 txtBnknm.Text = dgvwDtls.Rows[e.RowIndex].Cells["bankname"].Value.ToString();


                 string CTS = dgvwDtls.Rows[e.RowIndex].Cells["Chequetype"].Value.ToString();


                 if (CTS == "True")
                 {
                     rbchqtype1.Checked = true;
                 
                 }

                 else if (CTS == "False")
                 {
                     rbchqtype2.Checked = true;
                 
                 }
                 
                 txtAcntno.Text = dgvwDtls.Rows[e.RowIndex].Cells["Accountno"].Value.ToString();
                 cmbAcntype.Text = dgvwDtls.Rows[e.RowIndex].Cells["Accounttype"].Value.ToString();
                 Isinsert = false;
            }
                else if (dgvwDtls.Columns[e.ColumnIndex].Name == "Delete" && e.RowIndex >= 0)
                {
                    bnkid = Convert.ToInt32(dgvwDtls.Rows[e.RowIndex].Cells["bankid"].Value);
                    DialogResult dr = MessageBox.Show("Are you sure to delete row?", "Confirmation", MessageBoxButtons.YesNo);
                    if (dr == DialogResult.Yes)
                    {
                        bnkinfo.DeleteData(bnkid);
                    }
                    else if (DialogResult == DialogResult.No)
                    {
                        MessageBox.Show("Nothing Deleted");
                    }

                    LoadDataGridView();
                
                
                }


             }</blockquote

Posted 19-May-17 1:20am

Member 13153537

Updated 19-May-17 3:00am

v2

Add a Solution

Comments

RickZeeland 19-May-17 8:18am

Can you also show the code where you set the datagridview.datasource ?

Member 13153537 19-May-17 8:20am

This is the code for the loading data to datagridview

private void LoadDataGridView()
{
string connection = @"Data Source=CISBLR-01\SQL2008; Initial Catalog=ChequeManager;Integrated Security=True;";
SqlConnection con = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand("SELECT bank_Id,row_number() over(order by [bank_Id]) as SlNo,[bank_Name],[bank_Accountno],[bank_Accountype],[bank_Chequetype] FROM [dbo].[bankdetails] order by SlNo", con);
try
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
dgvwDtls.DataSource = dt;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

Member 13153537 19-May-17 8:30am

How to Handle that Exception in my case.Please give any reference.Thanks in advance.

RickZeeland 19-May-17 8:35am

I think you need to check: e.RowIndex >= 0

Member 13153537 19-May-17 8:42am

I know it is silly question.I'm fresher.Thanks for the help.

2 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)

RickZeeland · Accepted Answer · 2017-05-19T02:14:00

Solution 1

Check for:

e.RowIndex >= 0

You can use the .SortMode property for columns, see:
How to: Set the Sort Modes for Columns in the Windows Forms DataGridView Control[^]
Also see: sort datagridview on column header click[^]

Posted 19-May-17 2:14am

RickZeeland

Updated 19-May-17 2:37am

v2

Comments

Member 13153537 19-May-17 8:27am

If I select first column value and click column header it is working fine.If i directly click the column header i am getting argument out of range exception.Any way Thanks for the Help.

phil.o · Accepted Answer · 2017-05-19T03:00:00

RickZeeland is right. I post this second solution with a slight correction from the code you showed:

C#

private void dgvwDtls_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
   if (e.RowIndex > -1) {
      ChqMngrBsns.Masters.BankInfo bnkinfo = new ChqMngrBsns.Masters.BankInfo();
      bnkid = Convert.ToInt32(dgvwDtls.Rows[e.RowIndex].Cells["bankid"].Value);
      if (dgvwDtls.Columns[e.ColumnIndex].Name == "Edit")
      {
         txtBnknm.Text = dgvwDtls.Rows[e.RowIndex].Cells["bankname"].Value.ToString();
         string CTS = dgvwDtls.Rows[e.RowIndex].Cells["Chequetype"].Value.ToString();
         if (CTS == "True")
         {
            rbchqtype1.Checked = true;
         }
         else if (CTS == "False")
         {
            rbchqtype2.Checked = true;
         }
         txtAcntno.Text = dgvwDtls.Rows[e.RowIndex].Cells["Accountno"].Value.ToString();
         cmbAcntype.Text = dgvwDtls.Rows[e.RowIndex].Cells["Accounttype"].Value.ToString();
         Isinsert = false;
      }
      else if (dgvwDtls.Columns[e.ColumnIndex].Name == "Delete")
      {
         bnkid = Convert.ToInt32(dgvwDtls.Rows[e.RowIndex].Cells["bankid"].Value);
         DialogResult dr = MessageBox.Show("Are you sure to delete row?", "Confirmation", MessageBoxButtons.YesNo);
         if (dr == DialogResult.Yes)
         {
            bnkinfo.DeleteData(bnkid);
         }
         else if (DialogResult == DialogResult.No)
         {
            MessageBox.Show("Nothing Deleted");
         }
         LoadDataGridView();
      }
   }
}

If you place the test of the RowIndex at the beginning, you get an early exit of the method. Strange that the CellContentClick event is fired when you click on a column header, though.