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