DataGrid ⇐ C#

[Anonymous]

using Microsoft.Data.SqlClient;
using System.Data;

namespace WinFormsApp1
{
public partial class Form1 : Form
{
private readonly string connectionString = "Data Source=DESKTOP-7I4194H;Initial Catalog=sqlTEST;Integrated Security=True;Encrypt=True;Trust Server Certificate=True";
public Form1()
{
InitializeComponent();
LoadData();
}

private void LoadData()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM partners";
SqlDataAdapter adapter = new SqlDataAdapter(query, connection);
DataTable table = new DataTable();
adapter.Fill(table);
dataGridView1.DataSource = table;
}

private void btnAdd_Click(object sender, EventArgs e)
{
using (AddEdit form = new AddEdit())
{
if (form.ShowDialog() == DialogResult.OK)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = "INSERT INTO Partners (CompanyName, DirectorName, Phone, Email) VALUES (@CompanyName, @DirectorName, @Phone, @Email)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@CompanyName", form.CompanyName);
command.Parameters.AddWithValue("@DirectorName", form.DirectorName);
command.Parameters.AddWithValue("@Phone", form.Phone);
command.Parameters.AddWithValue("@Email", form.Email);

connection.Open();
command.ExecuteNonQuery();
}
LoadData();
}
}
}

private void Edit_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0) return;

DataRowView row = (DataRowView)dataGridView1.SelectedRows[0].DataBoundItem;

using (AddEdit form = new AddEdit())
{
form.PartnerID = row["PartnerID"].ToString();
form.CompanyName = row["CompanyName"].ToString();
form.DirectorName = row["DirectorName"].ToString();
form.Phone = row["Phone"].ToString();
form.Email = row["Email"].ToString();

if (form.ShowDialog() == DialogResult.OK)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = "UPDATE Partners SET CompanyName = @CompanyName, DirectorName = @DirectorName, Phone = @Phone, Email = @Email WHERE PartnerID=@PartnerID";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@PartnerID", form.PartnerID);
command.Parameters.AddWithValue("@CompanyName", form.CompanyName);
command.Parameters.AddWithValue("@DirectorName", form.DirectorName);
command.Parameters.AddWithValue("@Phone", form.Phone);
command.Parameters.AddWithValue("@Email", form.Email);

connection.Open();

command.ExecuteNonQuery();
}
LoadData();
}
}
}
}
}


Подробнее здесь: https://stackoverflow.com/questions/796 ... d-einheria