data clearance error in datagridview

Question

0.00/5 (No votes)

See more:

VS2008

here is the code part

private void btnSearch_Click(object sender, EventArgs e)
        {
           //dgvSearch.Rows.Clear();
           
            int name = Convert.ToInt32(cboxJewlName.SelectedValue);
            int material=Convert.ToInt32(cboxJewlMaterial.SelectedValue) ;
           DataTable table = Bllcombohelper.getAllSelectedJewl(name, material);
           int roows=table.Rows.Count;
            int j=0;
            while (j < roows)
            {
                if (j > 14)
                {
 

                    dgvSearch.Rows.Add(1);
                   dgvSearch.ScrollBars = ScrollBars.Vertical;
                  
 
                }
                dgvSearch.Rows[j].Cells[0].Value = table.Rows[j].ItemArray[0].ToString();
                dgvSearch.Rows[j].Cells[1].Value = table.Rows[j].ItemArray[5].ToString();
                dgvSearch.Rows[j].Cells[2].Value = table.Rows[j].ItemArray[6].ToString();
                dgvSearch.Rows[j].Cells[3].Value=table.Rows[j].ItemArray[7].ToString()+"/-";
                dgvSearch.Rows[j].Cells[4].Value = table.Rows[j].ItemArray[4].ToString();
 
                j = j + 1;
 
 
            }
     //table.Clear();
  }

i used dgvSearch.Rows.Clear();
in the position commented above but it didn't work

also i tried table.Clear();
in the postion comment above but it also didn;t helped.

what should i do so that on the next click of search button the old value of datagridview first get cleared...and then procced to display the search item with some diffrent attribute

thank u for ur help

Posted 15-Aug-11 20:20pm

amsainju

Updated 15-Aug-11 21:43pm

Toniyo Jackson

v2

Add a Solution

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)

Abhinav S · Accepted Answer · 2011-08-15T20:26:00

Solution 1

Try

table.Clear();
dgvSearch.DataSource = table;

Posted 15-Aug-11 20:26pm

Abhinav S

Comments

amsainju 16-Aug-11 2:37am

it didn't worked :(

senthil sennu · Accepted Answer · 2011-08-15T20:27:00

Solution 2

C#

private void btnSearch_Click(object sender, EventArgs e)
{
 dgvSearch.DataSource = null;
 dgvSearch.Rows.Clear();
 dgvSearch.Columns.Clear();

// Your code
}

Hope this helps!

Posted 15-Aug-11 20:27pm

senthil sennu

Updated 15-Aug-11 20:51pm

v2

Comments

amsainju 16-Aug-11 2:33am

there is no such property such as datbind in c#...

senthil sennu 16-Aug-11 2:35am

Sorry, I thought u want to clear gridview. If it is a windows application u can use dgvSearch.DataSource = null; alone.

Ashika s 16-Aug-11 2:37am

this is not working in windows application.:(

amsainju 16-Aug-11 2:40am

ya not working in windows application :(

senthil sennu 16-Aug-11 2:50am

dgvSearch.DataSource = null;
dgvSearch.Rows.Clear();
dgvSearch.Columns.Clear();

I am using the above three line to clear my grid. Its working fine here. pls chk

Ashika s 16-Aug-11 3:45am

gud answer, its woking properly ha ha

senthil sennu 16-Aug-11 4:22am

pls change to the status to answered. :)

amsainju 16-Aug-11 7:40am

if (dgvSearch.Rows.Count > 0)
{
dgvSearch.Rows.Clear();
dgvSearch.Rows.Add(15);
}

i had forgetten to use dgvSearch.Rows.Add(15); in my code
the error was shown because dgvSearch.Rows.Clear() clears or say deletes all the empty rows that i used for a better design...
thank u all for your help