How to access Other sql database form web forms
-
Hi every-one, Short: My name is Ian, I am actually learning web programming, please if any one can answer me on my burning question - thank you. 1: Is it possible to access another sql server from a website 2: I want to create login and access ie. read and write client specific data to and from the client db. 3: What controls or how do I manipulate .net controls to allow me access on these db's If any one can assist me please and Thank you Ian
WOW
-
Hi every-one, Short: My name is Ian, I am actually learning web programming, please if any one can answer me on my burning question - thank you. 1: Is it possible to access another sql server from a website 2: I want to create login and access ie. read and write client specific data to and from the client db. 3: What controls or how do I manipulate .net controls to allow me access on these db's If any one can assist me please and Thank you Ian
WOW
Hi, I am not sure what you meant by another sql server. Yes you can connect to multiple sql server through your website. Its up to you how you manage your connections. You could use GridView, DataList etch controls to access your Db but not sure what exactly you are trying to achieve.
-
Hi every-one, Short: My name is Ian, I am actually learning web programming, please if any one can answer me on my burning question - thank you. 1: Is it possible to access another sql server from a website 2: I want to create login and access ie. read and write client specific data to and from the client db. 3: What controls or how do I manipulate .net controls to allow me access on these db's If any one can assist me please and Thank you Ian
WOW
Buy a book mate, The MS Press books "xxxxx Step By Step" will get you started. Read articles on SQL Injection attacks as well.
DEVELOPER DAY SCOTLAND 2009 Watch this space http://www.developerdayscotland.com/[^]
-
Hi, I am not sure what you meant by another sql server. Yes you can connect to multiple sql server through your website. Its up to you how you manage your connections. You could use GridView, DataList etch controls to access your Db but not sure what exactly you are trying to achieve.
Hi Jaffer, Well sorry for the incomplete description. Ok, I have a client(say Pups) who needs his clients to access their information over the web. This entails that when that client logs in over the web, I must read their login information which is stored in Pups SQL Db on Pups server. Also for new clients of Pups who need to register over the web, to be able to trade with Pups, I need to Update his sql Db. I am still new to ASP.net and web development and are not familiar with all the controls. I have however tried to adjust or change asp.net configuration and Provider but with no success. Please if you can help me and put me into the right direction. If the information is still not enough I will elaborate more should you have more questions. Thank you very much
WOW
-
Hi Jaffer, Well sorry for the incomplete description. Ok, I have a client(say Pups) who needs his clients to access their information over the web. This entails that when that client logs in over the web, I must read their login information which is stored in Pups SQL Db on Pups server. Also for new clients of Pups who need to register over the web, to be able to trade with Pups, I need to Update his sql Db. I am still new to ASP.net and web development and are not familiar with all the controls. I have however tried to adjust or change asp.net configuration and Provider but with no success. Please if you can help me and put me into the right direction. If the information is still not enough I will elaborate more should you have more questions. Thank you very much
WOW
Hi, Are you using 2 sql servers? Because from the description i am still unable to completely understand your problem. What i understand from your description is you might be having 2 sql servers one called pups. Okay when pups clients access pups application over web you might say you establish connection to the server using connection string 1 hitting pups database server. And when you need to connect to another database server you should use connection string 2. This logic should be embedded in your program to determine which database it should access at any particular moment. I am assuming you know about connection string and know how to connect to a sql server in asp.net
-
Hi, Are you using 2 sql servers? Because from the description i am still unable to completely understand your problem. What i understand from your description is you might be having 2 sql servers one called pups. Okay when pups clients access pups application over web you might say you establish connection to the server using connection string 1 hitting pups database server. And when you need to connect to another database server you should use connection string 2. This logic should be embedded in your program to determine which database it should access at any particular moment. I am assuming you know about connection string and know how to connect to a sql server in asp.net
-
Buy a book mate, The MS Press books "xxxxx Step By Step" will get you started. Read articles on SQL Injection attacks as well.
DEVELOPER DAY SCOTLAND 2009 Watch this space http://www.developerdayscotland.com/[^]