---
title: "Duplicate Values are inserted into database using DatagidView"  
description: "Duplicate Values are inserted into database using DatagidView"  
author: "Jayden Bell"  
published: 2013-12-23  
updated: 2014-09-30  
canonical: https://www.mindstick.com/forum/1829/duplicate-values-are-inserted-into-database-using-datagidview  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# Duplicate Values are inserted into database using DatagidView

[Duplicate Values](https://www.mindstick.com/forum/157764/how-to-find-duplicate-values-in-a-sql-table) are inserted into [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) using DatagidView

```
foreach (DataGridViewRow dgRow in dataGridView1.Rows)                {                    if (dgRow.Cells[0].Value != null)                    {                        string re1 = dgRow.Cells[0].Value.ToString();                        string strQuery1 = "INSERT INTO unit_master(unit) VALUES('" + re1 + "')";                        SqlCommand scmd1 = new SqlCommand(strQuery1,SqlConn);                        scmd1.ExecuteNonQuery();                    }                }
```

How to [resolve](https://www.mindstick.com/forum/159427/windows-app-dll-not-found-resolve-library-issue) it?

## Replies

### Reply by Anonymous User

Create Procedure

AS

@re1 Varchar(20)

BEGIN

if not exists (select * from unit_master d where d.unit = @re1)

INSERT INTO unit_master([unit ]) [values](https://www.mindstick.com/forum/327/sum-textbox-values)(@re1)

END

### Reply by Pravesh Singh

Hi Jayden,

Write a Insert Procedure that will check [duplicate](https://www.mindstick.com/forum/160911/sql-query-to-find-duplicate-records-in-a-table-in-sql-server) insertion

```
Create ProcedureAS@re1 Varchar(20)BEGINif not exists (select * from unit_master d where d.unit = @re1)    INSERT INTO unit_master([unit ]) values(@re1)END
```


---

Original Source: https://www.mindstick.com/forum/1829/duplicate-values-are-inserted-into-database-using-datagidview

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.