Working with Sql Azure - Creating connection String



Create connection using sql Azure

using System.Data;
using System.Data.SqlClient;
 protected void Page_Load(object sender, EventArgs e)
    {
//stoaxy9 -unique server that is generated automatically for your account. Make trusted connection to false.
        string sConn = "Server=tcp:stoaxy9.database.windows.net;
        Database=SyntaxHelp;
//specify Sql azure account UserID and Password
        User ID=Hima;
        Password=password;Trusted_Connection=False";
        SqlConnection objConn = new SqlConnection(sConn);
        objConn.Open();         
        objConn.Close();
     }

Share |

 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.