> 1. while adding data to teamtable and teamemtable, the duplication of data is also accepting.
any idea how to remove the duplication?
If have TSQL returning duplicate values, you can use DISTINCT to remove duplicate values as in:
SELECT DISTINCT A, B FROM FRED .........
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
TATWORTH
All-Star
72415 Points
14017 Posts
MVP
Re: filling the textbox,dropdownlist from the database??
Feb 07, 2008 05:45 AM|LINK
> 1. while adding data to teamtable and teamemtable, the duplication of data is also accepting.
any idea how to remove the duplication?
If have TSQL returning duplicate values, you can use DISTINCT to remove duplicate values as in:
SELECT DISTINCT A, B FROM FRED .........
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239