using Microsoft.Data.SqlClient;
using System;
using System.Data;
using System.Windows.Forms;
namespace databasecon
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string ConnectionString = "Data Source=WIZARD;Initial Catalog=ISMT;Integrated Security=True;Trust Server Certificate=True";
SqlConnection sqlConnection = new SqlConnection(ConnectionString);
string query = "SELECT * FROM Department";
SqlCommand sql = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
SqlDataAdapter adapter = new SqlDataAdapter(query, sqlConnection);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
dataGridView1.DataSource = dataTable;
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
}
}
void Insert()
{
string ConnectionString = "Data Source=WIZARD;Initial Catalog=ISMT;Integrated Security=True;Trust Server Certificate=True";
SqlConnection sqlConnection = new SqlConnection(ConnectionString);
string query = "INSERT INTO Department(Id, Name) VALUES(1, 'IT')";
SqlCommand sql = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
int RowsAffected = sql.ExecuteNonQuery();
if (RowsAffected > 0)
{
MessageBox.Show("Added");
}
}
///////////////
PostgreSQL Load Data
private string connString = "Host=localhost;Port=5432;Username=postgres;Password=123456;Database=test";
- •using (var conn = new NpgsqlConnection(connString))
- • {
- • conn.Open();
- • using (var cmd = new NpgsqlCommand("SELECT * FROM people", conn))
- • {
- • var dt = new DataTable();
- • dt.Load(cmd.ExecuteReader());
- • dataGridView1.DataSource = dt;
- • }
- • }