Tuesday, May 2, 2017

SQL on Azure



using System.Data.SqlClient;

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
            builder.DataSource = "am-dol.database.windows.net";
            builder.UserID = "am_bvs";
            builder.Password = "gE^B{rG8X/rQg+83";
            builder.InitialCatalog = "am_bvs.database";

            //insert
            using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
            {
                connection.Open();
                StringBuilder sb = new StringBuilder();
                sb.Append("INSERT INTO am_bat (RespondentId) ");
                sb.Append("VALUES (@RespondentId);");
                String sql = sb.ToString();
                using (SqlCommand command = new SqlCommand(sql, connection))
                {
                    command.Parameters.AddWithValue("@RespondentId", "MyTestId3");
                    int rowsAffected = command.ExecuteNonQuery();
                }

            }



No comments:

Post a Comment