質問編集履歴

追記させていただきました。エラーが出てしまい方向性はあってるのでしょうか？

2020/03/31 14:30

投稿

pj7577bm60v

スコア13

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -92,6 +92,188 @@
         }
+//追記させていただきました。
+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 System.Data.SqlClient;
+namespace WindowsFormsApp4
+{
+    public partial class Form1 : Form
+    {
+        private SqlConnection cn = new SqlConnection();
+        private SqlCommand cmd = new SqlCommand();
+        private SqlDataReader rd;
+        private String cnstr = @"Data Source=(LocalDB)\MSSQLLocalDB;" + @"AttachDbFilename=|DataDirectory|\Schedule2.mdf;" + "Integrated Security = True; Connect Timeout = 30";
+        private string name = "";
+        private DateTime date = new DateTime(2000, 1, 1);
+        private string task = "";
+        readonly List<ListBox> listBoxs;
+        public Form1()
+        {
+            InitializeComponent();
+            listBoxs = new List<ListBox>
+            {
+                null,
+                listBox1,
+                listBox2,
+                listBox3,
+                listBox4,
+                listBox5,
+                listBox6,
+                listBox7,
+                listBox8,
+                listBox9,
+                listBox10,
+                listBox11,
+                listBox12,
+                listBox13,
+                listBox14
+            };
+        }
+        private void button1_Click(object sender, EventArgs e)
+        {
+            cn.ConnectionString = cnstr;
+            cn.Open();
+            cmd.Connection = cn;
+            cmd.CommandType = CommandType.Text;
+            cmd.CommandText = "SELECT * FROM [dbo] . [Table]";
+            rd = cmd.ExecuteReader();
+            while (rd.Read())
+            {
+                name = Convert.ToString(rd["名前"]);
+                date = Convert.ToDateTime(rd["日付"]);
+                task = Convert.ToString(rd["タスクネーム"]);
+                if (name == "A")
+                {
+                    var listBox = listBoxs[ListBoxItems];
+                    //listBox.Items.Add = task;
+                }
+            }
+            rd.Close();
+            cn.Close();
+        }
+        private int ListBoxItems
+        {
+            get
+            {
+                //if (date ==3,1 ) return 1;
+                return 0;
+            }
+        }
+    }
+}
 ```