syntaxhelp.com Your online cheat sheet!

Select statement using SQL Azure

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=SyntaxHelpTestDB;User ID=Hima;
Password=password;Trusted_Connection=False";

        SqlConnection objConn = new SqlConnection(sConn);
        objConn.Open();

        string sSQL = "SELECT * FROM mySyntaxHelpTestTable";

        SqlCommand objCmd = new SqlCommand(sSQL, objConn);
        objCmd.CommandType = System.Data.CommandType.Text;

        myGridView.DataSource = objCmd.ExecuteReader();
        myGridView.DataBind();

        objConn.Close();
    }