Styjun

administrative duties kill the research spirit?

Did Snape really give Umbridge a fake Veritaserum potion that Harry later pretended to drink?

Using Sed to add counter to keyword

Bypass with wrong cvv of debit card and getting OTP

What does the ash content of broken wheat really mean?

How do both sides know the MTU

What instances can be solved today by modern solvers (pure LP)?

Why would "dead languages" be the only languages that spells could be written in?

Did Stalin kill all Soviet officers involved in the Winter War?

Do the 26 richest billionaires own as much wealth as the poorest 3.8 billion people?

How to improve the size of cells in this table?

How can one synthesise a conjugated alkyne chain?

Olive oil in Japanese cooking

Has there ever been a cold war other than between the U.S. and the U.S.S.R.?

Phrasing "it says" or "it reads"

How to respond to someone who condemns behavior similar to what they exhibit?

What is meant by perfect, imperfect consonance and dissonance?

Was Wolfgang Unzicker the last Amateur GM?

Isn't "Dave's protocol" good if only the database, and not the code, is leaked?

Has chattel slavery ever been used as a criminal punishment in the USA since the passage of the Thirteenth Amendment?

What are the differences of checking a self-signed certificate vs ignore it?

What is the difference between a historical drama and a period drama?

Machine Learning Golf: Multiplication

Simple OOP currency converter

How to clear datagridview in c# for displaying another file?

How do I calculate someone's age in C#?How do you give a C# Auto-Property a default value?How do I enumerate an enum in C#?How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?How do I get a consistent byte representation of strings in C# without manually specifying an encoding?How do I update the GUI from another thread?How to loop through all enum values in C#?VB.NET: Clear DataGridViewHow clear panel and datagridview After Postback?How to display different records on text fields from different tables with only 1 dataGridView?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I am building an application in which i'm displaying an excel file in datagridview. I've given display button for showing data. My problem is once I click button, it works fine but after my second attempt it appends data with previous data. I want to clear datagridview for displaying new data again.
So, what code should I implement?

I tried dataGridView1.DataSource = null; and dataGridView1.Rows.Clear();, but they didn't work for my need

c# excel datagridview

share|improve this question

edited Mar 25 at 18:47

João Fernandes

35833 silver badges1212 bronze badges

asked Mar 25 at 18:42

rutu chavanrutu chavan

122 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Been a bit since I used these, but I believe that during initial setup you had to use dataGridView1.DataSource = X, have you attempted to clear the X object?
  
  – dmoore1181
  Mar 25 at 18:47
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  setting the data source to null should work so there must be a flaw in your logic elsewhere. Please post more code.
  
  – eddyizm
  Mar 25 at 18:50
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Setting DataSource = null should work. Sounds like you are appending data to the data source object instead of clearing/overriding the old data.
  
  – OhBeWise
  Mar 25 at 20:42
  

  
  
  
  

add a comment | 

0

I am building an application in which i'm displaying an excel file in datagridview. I've given display button for showing data. My problem is once I click button, it works fine but after my second attempt it appends data with previous data. I want to clear datagridview for displaying new data again.
So, what code should I implement?

I tried dataGridView1.DataSource = null; and dataGridView1.Rows.Clear();, but they didn't work for my need

c# excel datagridview

share|improve this question

edited Mar 25 at 18:47

João Fernandes

35833 silver badges1212 bronze badges

asked Mar 25 at 18:42

rutu chavanrutu chavan

122 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Been a bit since I used these, but I believe that during initial setup you had to use dataGridView1.DataSource = X, have you attempted to clear the X object?
  
  – dmoore1181
  Mar 25 at 18:47
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  setting the data source to null should work so there must be a flaw in your logic elsewhere. Please post more code.
  
  – eddyizm
  Mar 25 at 18:50
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Setting DataSource = null should work. Sounds like you are appending data to the data source object instead of clearing/overriding the old data.
  
  – OhBeWise
  Mar 25 at 20:42
  

  
  
  
  

add a comment | 

I am building an application in which i'm displaying an excel file in datagridview. I've given display button for showing data. My problem is once I click button, it works fine but after my second attempt it appends data with previous data. I want to clear datagridview for displaying new data again.
So, what code should I implement?

I tried dataGridView1.DataSource = null; and dataGridView1.Rows.Clear();, but they didn't work for my need

c# excel datagridview

share|improve this question

edited Mar 25 at 18:47

João Fernandes

35833 silver badges1212 bronze badges

asked Mar 25 at 18:42

rutu chavanrutu chavan

122 bronze badges

share|improve this question

edited Mar 25 at 18:47

João Fernandes

35833 silver badges1212 bronze badges

asked Mar 25 at 18:42

rutu chavanrutu chavan

122 bronze badges

share|improve this question

edited Mar 25 at 18:47

João Fernandes

35833 silver badges1212 bronze badges

asked Mar 25 at 18:42

rutu chavanrutu chavan

122 bronze badges

edited Mar 25 at 18:47

João Fernandes

35833 silver badges1212 bronze badges

edited Mar 25 at 18:47

João Fernandes

35833 silver badges1212 bronze badges

asked Mar 25 at 18:42

rutu chavanrutu chavan

122 bronze badges

asked Mar 25 at 18:42

rutu chavanrutu chavan

122 bronze badges