<div>
Usually read data from SQL table to GridView, but to insert all data from GridView in DataBase. And not check data from GridView &nbsp;for existence duplicates. Are you sure, that this approch is correct and need?<br />
<br />
If you have data from your GridView, you can use this code to get data without duplicates.<br />

<pre><code id="code-20-42596761-1">var result = YourList.Select(o =&gt; new { x.Username, x.ItemID })
                                       .Distinct();</code></pre>
</div>


Usually read data from SQL table to GridView, but to insert all data from GridView in DataBase. And not check data from GridView  for existence duplicates. Are you sure, that this approch is correct and need?

If you have data from your GridView, you can use this code to get data without duplicates.


var result = YourList.Select(o => new { x.Username, x.ItemID })
                                       .Distinct();

Developer

Murray Brown

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
In my ASP.net web app I am writing code that loops through a GridView and inserts data into a SQL table.<br />
I want to prevent duplicates based o two columns [Username] and [Item ID].<br />
<br />
What I the best way to do this?
</div>
</div>


Hi

In my ASP.net web app I am writing code that loops through a GridView and inserts data into a SQL table.
I want to prevent duplicates based o two columns [Username] and [Item ID].

What I the best way to do this?

ASP.net/SQL Prevent Duplicates

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.