Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello Everyone,

i am a MCA student and i have huge interest in .net technologies. to learn more i keep on doing experiments by creating a different types of programs.

now i have created a simple window program which extracts the information from the SQL 2005 database to datagrideview.

now what i want is, i want to upload the database on to the hosting server. and from server i information should appear in the grideview. like to inform you that i have hosting space and a domine name which i registered free of cost from "somee.com".

Now bellow are the couple of things which i want to understand

1. how to upload my database on the server.
2. what will be connection string.

would appreciate if someone can share any online tutorial or video which i can refer to.

i have also tried to get the information my self but failed to get it.

looking forward to your guidance

Thank you
Posted

1 solution

1) Depends
2) Depends

Not very helpful, huh? Unfortunately, it's also true.

They are very related questions, and very related answers, because both of them are completely up to the hosting company you are using. They have the SQL server instance loaded on a machine, with a name - they will tell you somewhere in their documentation what the instance name is and how you connect to it. They will also (probably) tell you how to load a database on to the instance - which may or may not be a case connecting and creating the DB. It may be that you have to use their software to create the DB, some hosts work that way to limit the number of DBs you are allowed. It may be that the instance is publicly available over the internet, so you can load the DB in any way you see fit. But if the later is the case, I would strongly recommend that you either store nothing of any importance in you DB or change hosting companies.

So the answer to both your questions is: "Depends".
Sorry - but you need to look to your hosting provider.
 
Share this answer
 
Comments
jonlink01 31-Dec-12 2:21am    
Hello Griff, thank you for writing.

suggestion given by you helped me a lot. earlier was under impression that we have a some tool to upload the database like filezilla which we use for uploading the pages(but i was wrong). with help of your suggestions i open the somee hosting site, there was an option to create database, their i created my test database and connection string was automatically created by the system.

and i use this connection string and in my VC# app and it works yapppiiii. a very nice and simple learning.

before i end just wanted to say u thank you for cumming forward and helping students like us.

looking forward for more help.

Thank you very very much originalGriff.:-)
OriginalGriff 31-Dec-12 2:49am    
You're welcome!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900