From 1a1c8e71fcd14858f595029f089b2d4a00202b32 Mon Sep 17 00:00:00 2001
From: ogi <Administrator@S-OGI-PC>
Date: Fri, 05 Dec 2025 09:24:16 +0900
Subject: [PATCH] プロジェクトファイルを追加。
---
HotelPms.SourceFactory/PostgreSqlDemo.cs | 49 +++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 49 insertions(+), 0 deletions(-)
diff --git a/HotelPms.SourceFactory/PostgreSqlDemo.cs b/HotelPms.SourceFactory/PostgreSqlDemo.cs
new file mode 100644
index 0000000..566ede9
--- /dev/null
+++ b/HotelPms.SourceFactory/PostgreSqlDemo.cs
@@ -0,0 +1,49 @@
+using HotelPms.Share.Data;
+using HotelPms.Share.Windows.Util;
+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;
+
+namespace HotelPms.SourceFactory
+{
+ public partial class PostgreSqlDemo : Form
+ {
+ public PostgreSqlDemo()
+ {
+ InitializeComponent();
+ GeneralSub.InitDataGridView(dataGridView1, true);
+ }
+
+ private void button1_Click(object sender, EventArgs e)
+ {
+ bool ret = PostgreSqlNet.CreateDataBase(new DBConnectItem(txtHost.Text, txtDB.Text, txtUser.Text, txtPassword.Text, 5433));
+ dataGridView1.DataSource = ToTable(ret.ToString());
+
+ }
+
+
+ public DataTable ToTable(string msg)
+ {
+ DataTable table = new DataTable();
+ table.Columns.Add("内容", typeof(string));
+ DataRow row = table.NewRow();
+ table.Rows.Add(row);
+ row[0] = msg;
+ return table;
+ }
+
+ private void button2_Click(object sender, EventArgs e)
+ {
+ using (PostgreSqlNet postgreSqlNet = new PostgreSqlNet(new DBConnectItem(txtHost.Text, txtDB.Text, txtUser.Text, txtPassword.Text, 5433)))
+ {
+ dataGridView1.DataSource = postgreSqlNet.GetDataTable(txtSql.Text);
+ }
+ }
+ }
+}
--
Gitblit v1.10.0