Question in database

I think you should describe your table structures how you are designing tables along  with associate table in which you are facing problem so that anyone can found can there be any way to solve it?

I don't think it is possible to set the primary and allow for duplicate values at the same time.

So, I will not set a primary key for my table and I will need to fix this error:
Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

Any suggestions????

I did set a primary key for my table. So now how to allow the item, which I assign the PK to, to have duplicate values.

Thanks,
Ali

Hi


 Firstly u decalred prmary key on ur database atble  . . then ur duplicasy problem might be slove . .

Thanks Crich. But I'm not sure I understand what you say?

Thanks Crich. But I'm not sure I understand what you say?

Thank you Mayur for your reply.

What do you mean by "fire update query through stored procedure"

This Folowing Example is remove duplicate rows from a table

1. First, run the above GROUP BY query to determine how many sets of duplicate PK values exist, and the count of duplicates for each set.

    2.Select the duplicate key values into a holding table.
SELECT col1, col2, col3=count(*) INTO holdkey FROM t1 GROUP BY col1, col2 HAVING count(*) > 1

3.SELECT DISTINCT t1.* INTO holddups FROM t1, holdkey WHERE t1.col1 = holdkey.col1 AND t1.col2 = holdkey.col2


4.
SELECT col1, col2, count(*) FROM holddups GROUP BY col1, col2

5.DELETE t1 FROM t1, holdkey WHERE t1.col1 = holdkey.col1 AND t1.col2 = holdkey.col2


6.