Data grid view control in window application

Question

0.00/5 (No votes)

See more:

I am using Data grid view control in window application.I am using data grid view to populate data from data base sql server 2005. when first time data is bind then correct data will show. Like....

SNo. Name Address DOB
1 santosh delhi 12 jan 1990
2 ashok mumbai 10 nov 1980

but when data is entered in various textbox and saved in data base, at the same time again data is populated then data grid view showing with previous data, and data is repeated. how can i remove repeated data from data grid view.

SNo. Name Address DOB
1 santosh delhi 12 jan 1990
2 ashok mumbai 10 nov 1980
1 santosh delhi 12 jan 1990
2 ashok mumbai 10 nov 1980
3 rajiv chennai 20 feb 1089

HOW CAN I REMOVE DUPLICATE RECORD IN DATA GRID VIEW ?

Posted 26-Jun-11 0:48am

Rajiv nayan

Updated 26-Jun-11 2:35am

v2

Add a Solution

3 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-06-26T01:04:00

Solution 1

Try calling the Clear() property on the DataGridView before calling the grid view for second time.

Posted 26-Jun-11 1:04am

Abhinav S

Updated 26-Jun-11 2:53am

v2

karan joshua · Accepted Answer · 2011-06-26T03:58:00

Solution 2

try this:

when you add new data successfully, try to call that method once again.

Posted 26-Jun-11 3:58am

karan joshua

nava mojtaba · Accepted Answer · 2011-06-26T07:47:00

hi.please written in class:
{
public static int insert_man(string dore1)
{
if (Connection.Connect.State == ConnectionState.Open)
{
Connection.Connect.Close();
}
SqlCommand cmd = new SqlCommand("sp_insert_manegement", Connection.Connect);
cmd.Parameters.Add("@dore", SqlDbType.NVarChar).Value = dore1;

cmd.CommandType = CommandType.StoredProcedure;
Connection.Connect.Open();
int i = cmd.ExecuteNonQuery();
return i;
Connection.Connect.Close();
}
}