Export records to database and get filtered records
Hi all,
I am doing SEO works where for link building we have some websites they are repeated so i need the filtered websites and duplicate websites with there counting numbers.
There is a excelsheet where i have one columns as website and this contains data.I have to export these data to sql server database.And these records will be shown in a gridview when we click button.In one button when we click all duplicate records will be shown in gridview.I need the filter records from the database removing the duplicate records in gridview then export it to excel.One more thing, i have many excel files so after doing one file i want to delete the records from the database and the above all process will be repeated for those all the excelsheets.
Thanks in advance