Delet Row in DataGridView

Question

0.00/5 (No votes)

See more:

Hi,

I am using below code to delete row in datagridview but it is not deleting row till count it is lefting some row undeleted my code is

C#

AppiRow=datagridview.currentcell.rowindex;

for (int AppiLib_Count = 0; AppiLib_Count < AppiLib.Count; AppiLib_Count++)
                   {
                       dataGrid.Rows.RemoveAt(AppiRow);
                       AppiRow++;
                   }

please help on this..

Posted 4-Sep-13 19:41pm

rahuls1

Updated 4-Sep-13 19:47pm

Sandeep Singh Shekhawat

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)

Priyanka Bhagwat · Answer 1 · 2013-09-04T19:49:00

Solution 1

hi,

for example

you can use

HTML

OnRowDeleting="Countrylist_Rowdelete"

method of gridview

IN .cs file

C#

protected void Countrylist_Rowdelete(object sender, GridViewDeleteEventArgs e)//TO DELETE PARTICULAR RECORD SELECTED FROM GRID
       {       
           int intCode = Convert.ToInt32(Countrylist.DataKeys[e.RowIndex].Value);
           strQuery = "DELETE FROM Country_master " +
                      "WHERE CountryId=" + intCode + "";
           OpenConn();
           OleDbCommand oledbcmd = new OleDbCommand(strQuery, con);
           oledbcmd.ExecuteNonQuery();
           Display();//function that binds your gridview

       }

Hope this may help you
Happy Coding :)

Posted 4-Sep-13 19:49pm

Priyanka Bhagwat

Comments

rahuls1 5-Sep-13 1:52am

hiplease help me through my code i am not getting your code..

Priyanka Bhagwat 5-Sep-13 2:18am

hi can you tell me what is AppiLib.Count in your code

rahuls1 5-Sep-13 2:21am

its count is suppose 5 it is a collection of list..

Priyanka Bhagwat 5-Sep-13 1:58am

hi can you tell me what is AppiLib.Count in your code

Thanks7872 5-Sep-13 2:15am

Use reply button,other wise OP won't come to know that you have commented.

Priyanka Bhagwat 5-Sep-13 2:18am

thnkss :)

rahuls1 5-Sep-13 2:21am

its count is suppose 5 it is a collection of list

Priyanka Bhagwat 5-Sep-13 2:30am

try this after deleting

dataGridView1.Refresh();
OR re-bind the data and see..

dataGridView1.DataSource = myDataSource;
dataGridView1.Refresh();

might work

rahuls1 5-Sep-13 2:43am

Uncommitted new row cannot be deleted. is this is the problem can u have any suggestion.
and i am not using dataSource..

Priyanka Bhagwat 5-Sep-13 2:52am

is it happening with the latest records only
,please check and let me knw

rahuls1 5-Sep-13 2:53am

ya

Priyanka Bhagwat 5-Sep-13 2:58am

i have given the link in the solution plz checkkk :)

Priyanka Bhagwat · Answer 2 · 2013-09-04T20:57:00

hi,
check this link for your error

http://msghelp.net/showthread.php?tid=91063[^]

and

to delete gridview row without database
check

Add/Delete rows from gridview without database[^]

gridview row deletion without database[^]

http://bytes.com/topic/net/answers/828749-how-delete-row-gridview-without-database[^]

Happy Coding :)