Changing connection in datagrid, dataadapter and dataset to point to database on the server.
Posted on 2006-06-28
I have a solution that runs great on my computer but I'm unsure how to make it work when I upload it to the server. I have a web forms page with a datagrid that fills data from a dataset. I created it using visual studio and using the create dataset wizard after I created a data adapter. The data adapter created a data connection that points to my local machine, C:\Inetpub\wwwroot\nts\db\db_nts_web.mdb, but I need everything to point to my server connection instead.
The connection on my server looks like this: E:\inetpub\myhost\mywebsite.com\httpdocs\db\db_nts_web.mdb
Am I retarded or is there an easy way to make this change?
Any help would be greatly appreciated and would save my sanity.