«Transportda axborot tizimlari va texnologiyalari» kafedrasi

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))

{
Console.Out.WriteLine("Opening connection");
conn.Open();

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(); } } }