質問編集履歴

■データ取得箇所　の修正

2023/02/12 10:26

投稿

スコア49

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -37,11 +37,7 @@
             }
 ■データ取得箇所
-        private void Menu_Load(object sender, EventArgs e)
-        {
-        private void frmMenu_Load(object sender, EventArgs e)
+　    private void frmMenu_Load(object sender, EventArgs e)
         {
             try
             {

■データ取得箇所の修正

2023/02/12 10:25

投稿

スコア49

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -41,27 +41,29 @@
         {
+        private void frmMenu_Load(object sender, EventArgs e)
+        {
             try
             {
                 //　テンプレート
-                DatabaseAccessManager dam = new DatabaseAccessManager();
+                clsDataBaseAccessManager dam = new clsDataBaseAccessManager();
-                DataTable dtclinic = new DataTable();
+                DataTable dtClinic = new DataTable();
                 using (SQLiteCommand cmd = dam.CreateCommand())
                 {
                     string sql = "select * from MST_病院 where 病院コード = @code";
                     cmd.CommandText = sql;
-                    cmd.Parameters.Add(new SQLiteParameter("@code", "001"));
+                    cmd.Parameters.Add(new SQLiteParameter("@code", "1"));
-                    dtclinic = dam.ExecuteQuery(cmd);
+                    dtClinic = dam.ExecuteQuery(cmd);
                 }
-                    dam.CloseConnection();
+                dam.CloseConnection();
-                label1.Text = dtclinic.Rows[0]["病院名"].ToString();
+                lblClinicNameMenu.Text = dtClinic.Rows[0]["病院名"].ToString();
-                //
             }
             catch (Exception ex)
             {
-                MessageBox.Show(ex.Message);　　// ここで該当メッセージが表示されます
+                MessageBox.Show(ex.Message);
             }
         }