I have an application developed in ASP.Net(C#) and MS SQL, its working fine and fulfilling the requirements. Now the problem is I have a MS Access Database from where I have to read some data and feed it into ASP.Net form and then save it to MS SQL Database. Keep in mind i can't convert the MS Access DB to SQL directly as I need only few data from the MS Access DB.
Well I tried to connect the MS Access DB with an ASP Page and stored the particular data in session variable and tried to feed data from session to textbox of the form but I got error message. The message is following:
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
And Now I have an idea, I want to connect the MS Access DB directly from ASP.Net Page and then will feed up the text boxes in the form and save it to the SQL DB. But I am not sure that it will work or not.
So, Please provide some light on this issue ASAP, I am waiting for your valuable feedbacks.
Thanks & Regard,