29 Ocak 2012 Pazar

SQL Azure Connection

private static string userName = "bahar";
private static string password = "12341234";
private static string dataSource = "i7x8ktgn28.database.windows.net";
private static string sampleDatabaseName = "ATSDB";

SqlConnectionStringBuilder cs;
cs = new SqlConnectionStringBuilder();
cs.DataSource = dataSource;
cs.InitialCatalog = sampleDatabaseName;
cs.Encrypt = true;
cs.TrustServerCertificate = false;
cs.UserID = userName;
cs.Password = password;


// Connect to the database and perform various operations
using (SqlConnection conn = new SqlConnection(cs.ToString()))
{
using (SqlCommand cmd = conn.CreateCommand())
{
conn.Open();

// Query the table
cmd.CommandText = "insert into Bus (TID, Firm, FromCity, ToCity, DepartureTime, Duration, Price) VALUES ('" + tid + "','" + listBus[i].firmName + "','" + startUtf + "','" + destinationUtf + "','" + listBus[i].time + "','" + listBus[i].duration + "'," + listBus[i].price + ")";
cmd.ExecuteNonQuery();

conn.Close();

}
}

Hiç yorum yok:

Yorum Gönder