I am doing a crm project,i.e, Customer Relationship Management. the first module i am doing is called url filteration. In this i have a database which has the fields name,emailid,designation,line of business,company,city,country which has around 80,000 entries and gets updated daily.this database i have considered as one table . I have another table which has only email-ids which called exclusion list which is in 3 formats i.e,1.) only extensions(eg..gov,.edu etc) 2.) emailid (eg. name@company.com), 3.)company websites (eg. ti.com etc), even this table keeps on updating daily. What my application should do is it should compare the email-id in the exclusion list table with the first table and should delete those entries which match in the table which consists of 80,000 entries which is the master table.The front end is ASP.Net and backend is ADO.Net. The database i am using is MS Access. I wanted a code for the ui design and also for the implementation of this module, ie, database connection etc. I have another module with this which i will tell later. Please help me.
M
mddev
@mddev
Posts
-
crm -
How to connect to the MS Access database?my front end will be asp.net.
-
How to connect to the MS Access database?I wanted a code which would connect with the MS Access database.