45 lines
1.1 KiB
C#
45 lines
1.1 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel;
|
|
using System.Data;
|
|
using System.Drawing;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using System.Windows.Forms;
|
|
using MySql.Data.MySqlClient;
|
|
|
|
namespace modul
|
|
{
|
|
public partial class Form1 : Form
|
|
{
|
|
string db = "server=git.pgk.alspio.com; port=3306; username=pozorisp; password=pozorisp; database=pozorisp_Cherkasov";
|
|
public Form1()
|
|
{
|
|
InitializeComponent();
|
|
LoadData();
|
|
}
|
|
|
|
private void Form1_Load(object sender, EventArgs e)
|
|
{
|
|
|
|
}
|
|
|
|
private void LoadData()
|
|
{
|
|
using(MySqlConnection conn = new MySqlConnection(db))
|
|
{
|
|
MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM materials", conn);
|
|
DataTable dataTable = new DataTable();
|
|
adapter.Fill(dataTable);
|
|
dataGridView1.DataSource = dataTable;
|
|
}
|
|
}
|
|
|
|
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
|
|
{
|
|
|
|
}
|
|
}
|
|
}
|