«Transportda axborot tizimlari va texnologiyalari» kafedrasi
C# va PostgreSQL ma’lumotlar bazasini bog’lanishi
Download 1.76 Mb.
|
KURS ISHI XUDOYOROV
1.4 C# va PostgreSQL ma’lumotlar bazasini bog’lanishi
C# dasturlash tili va PostgreSQL ma’lumotlar bazasini bog’lash va unga kirish , ma’lumotlar qo’shish quyidagi tartibda amalga oshiriladi. Kodi: using System; using Npgsql; namespace Driver { public class AzurePostgresCreate { // Obtain connection string information from the portal // private static string Host = "mydemoserver.postgres.database.azure.com"; private static string User = "mylogin@mydemoserver"; private static string DBname = "mypgsqldb"; private static string Password = " private static string Port = "5432"; static void Main(string[] args) { // Build connection string using parameters from portal // string connString = String.Format( "Server={0};Username={1};Database={2};Port={3};Password={4};SSLMode=Prefer", Host, User, DBname, Port, Password); using (var conn = new NpgsqlConnection(connString)) {
using (var command = new NpgsqlCommand("DROP TABLE IF EXISTS inventory", conn)) { command.ExecuteNonQuery(); Console.Out.WriteLine("Finished dropping table (if existed)"); } using (var command = new NpgsqlCommand("CREATE TABLE inventory(id serial PRIMARY KEY, name VARCHAR(50), quantity INTEGER)", conn)) { command.ExecuteNonQuery(); Console.Out.WriteLine("Finished creating table"); } using (var command = new NpgsqlCommand("INSERT INTO inventory (name, quantity) VALUES (@n1, @q1), (@n2, @q2), (@n3, @q3)", conn)) { command.Parameters.AddWithValue("n1", "banana"); command.Parameters.AddWithValue("q1", 150); command.Parameters.AddWithValue("n2", "orange"); command.Parameters.AddWithValue("q2", 154); command.Parameters.AddWithValue("n3", "apple"); command.Parameters.AddWithValue("q3", 100); int nRows = command.ExecuteNonQuery(); Console.Out.WriteLine(String.Format("Number of rows inserted={0}", nRows)); } } Console.WriteLine("Press RETURN to exit"); Console.ReadLine(); } } } Download 1.76 Mb. Do'stlaringiz bilan baham: |
Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling
ma'muriyatiga murojaat qiling