Database connection

Question

I want to connect with online database and Microsoft Visual Studio. Can anybody help me how to connect with ***ONLINE**** Database?? Thanks a lot :-)

Krishna Rajput Singh · Answer

http://www.c-sharpcorner.com/UploadFile/a5f59f/how-to-create-log-in-form-in-visual-studio-and-connection-wi/

Khargesh Rajput · Answer

add your credentials of online database to connectionstring to connect online database

Nanhe Siddique · Answer

add following code in web.config file. and .cs page string query="insert update delete or select query"; SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[" ConnectionStringName "].ConnectionString); //if your query dml then con.Open(); SqlCommand cmdInsert = new SqlCommand(query,con); cmdInsert.ExecuteNonQuery(); con.Close(); //and if your query is select then con.Open(); SqlDataAdapter adap = new SqlDataAdapter(); DataTable ds = new DataTable(); adap.Fill(ds); con.Close(); i hope this help you Soe

Abhay Shanker · Answer

Hi,below link can be helpful to you. http://weblogs.asp.net/scottgu/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1

Database connection

Answers (4)