質問編集履歴

修正

2021/04/13 00:51

投稿

natume4948

スコア9

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -68,306 +68,306 @@
     {
+        //▼変数定義
+        string id = "";
+        string music = "";
+        string artist = "";
+        string album = "";
+        string date = "";
+        string genre = "";
+        DialogResult result;
+        DataTable dataT = new DataTable();
+        //テキストボックスのテキスト用配列
+        string[] search = new string[6];
+        //項目名用配列
+        string[] yourName = { "MusicID", "MusicName", "ArtistName", "AlbumName", "ReleaseDate", "Genre" };
+        //▲変数定義
+        //▼メソッド定義
+        //SQL文作成メソッド
+        void Sql(int index, string sq)
+        {
+            search[index] = sq;
+            //全体で使用する基本のSQL、1=1はAND処理を楽にするため
+            string sql = "SELECT * FROM music WHERE 1 = 1";
+            //string sql = "SELECT * FROM music WHERE 1 = 1 AND CAST(TRACK_NO AS VARCHAR) LIKE '1%'";
+            for (int i = 0; i < search.Length; i++)
+            {
+                string sea = search[i];
+                //トラックナンバー用処理
+                if (i == 0)
+                {
+                    //前方一致処理
+                    sql += " AND " + "CAST(" + yourName[i] + " AS VARCHAR) LIKE '" + sea + "%'";
+                }
+                //リリース用処理
+                else if (i == 4)
+                {
+                    //後方一致処理
+                    sql += " AND " + "CAST(" + yourName[i] + " AS VARCHAR) LIKE '%" + sea + "'";
+                }
+                else
+                {
+                    //部分一致処理
+                    sql += " AND " + yourName[i] + " LIKE '%" + sea + "%'";
+                }
+            }
+            Debug.WriteLine("xxxxxxxxxxxxxxxxx");
+            Debug.WriteLine(sql);
+            Debug.WriteLine("xxxxxxxxxxxxxxxxx");
+            //データベース描画前に一度削除
+            dataGridView1.DataSource = "";
+            //sql文エラーに備えて
+            try
+            {
+                //SQL文実行処理
+                SqlConnection sqlconn = new SqlConnection(Properties.Settings.Default.sqlserver);
+                SqlCommand command = new SqlCommand(sql, sqlconn);
+                SqlDataAdapter adapter = new SqlDataAdapter(command);
+                DataTable dt = new DataTable();
+                adapter.Fill(dt);
+                //データベースをGridに渡して表示
+                dataGridView1.DataSource = dt;
+                dataT = dt;
+                //検索結果の件数を表示
+                int count = dt.Rows.Count;
+                label1.Text = count.ToString();
+            }
+            catch (Exception ex)
+            {
+                //エラー表示
+                MessageBox.Show(ex.ToString());
+            }
+        }
+        public Form1()
+        {
+            InitializeComponent();
+        }
+        private void Form1_Load(object sender, EventArgs e)
+        {
+            //maxとminを同じにすることでサイズ固定
+            this.MaximumSize = this.Size;
+            this.MinimumSize = this.Size;
+            //最大化・最小化無効
+            this.MaximizeBox = false;
+            this.MinimizeBox = false;
+            SqlConnection sqlconn = new SqlConnection(Properties.Settings.Default.sqlserver);
+            sqlconn.Open();
+            SqlCommand command = new SqlCommand("SELECT * from Musics", sqlconn);
+            SqlDataAdapter adapter = new SqlDataAdapter(command);
+            DataTable dt = new DataTable();
+            adapter.Fill(dt);
+            dataGridView1.DataSource = dt;
+            dataT = dt;
+            //検索結果の件数を表示
+            int count = dt.Rows.Count;
+            label1.Text = count.ToString();
+        }
+        private void textBox1_TextChanged(object sender, EventArgs e)
+        {
+            id = textBox1.Text;
+            //値の種類とテキストボックスと項目名を渡す
+            Sql(0, id);
+        }
+        private void textBox2_TextChanged(object sender, EventArgs e)
+        {
+            music = textBox2.Text;
+            Sql(1, music);
+        }
+        private void textBox3_TextChanged(object sender, EventArgs e)
+        {
+            artist = textBox3.Text;
+            Sql(2, artist);
+        }
+        private void textBox4_TextChanged(object sender, EventArgs e)
+        {
+            album = textBox4.Text;
+            Sql(3, album);
+        }
+        private void textBox5_TextChanged(object sender, EventArgs e)
+        {
+            date = textBox5.Text;
+            Sql(4, date);
+        }
+        private void textBox6_TextChanged(object sender, EventArgs e)
+        {
+            genre = textBox6.Text;
+            Sql(5, genre);
+        }
+        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
+        {
+        }
+        private void button1_Click(object sender, EventArgs e)
+        {
+            //ダイアログのYesNoを取得
+            MessageBox.Show("一覧データを出力しますか？", "出力の確認", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
+            MessageBox.Show("一覧データを出力しました");
+    }
-        public Form1()
-        {
-            InitializeComponent();
-        }
-        private void Form1_Load(object sender, EventArgs e)
-        {
-            //maxとminを同じにすることでサイズ固定
-            this.MaximumSize = this.Size;
-            this.MinimumSize = this.Size;
-            //最大化・最小化無効
-            this.MaximizeBox = false;
-            this.MinimizeBox = false;
-            SqlConnection sqlconn = new SqlConnection(Properties.Settings.Default.sqlserver);
-            sqlconn.Open();
-            SqlCommand command = new SqlCommand("SELECT * from Musics", sqlconn);
-            SqlDataAdapter adapter = new SqlDataAdapter(command);
-            DataTable dt = new DataTable();
-            adapter.Fill(dt);
-            dataGridView1.DataSource = dt;
-            dataT = dt;
-            //検索結果の件数を表示
-            int count = dt.Rows.Count;
-            label1.Text = count.ToString();
-        }
-        private void textBox1_TextChanged(object sender, EventArgs e)
-        {
-            id = textBox1.Text;
-            //値の種類とテキストボックスと項目名を渡す
-            Sql(0, id);
-        }
-        private void textBox2_TextChanged(object sender, EventArgs e)
-        {
-            music = textBox2.Text;
-            Sql(1, music);
-        }
-        private void textBox3_TextChanged(object sender, EventArgs e)
-        {
-            artist = textBox3.Text;
-            Sql(2, artist);
-        }
-        private void textBox4_TextChanged(object sender, EventArgs e)
-        {
-            album = textBox4.Text;
-            Sql(3, album);
-        }
-        private void textBox5_TextChanged(object sender, EventArgs e)
-        {
-            date = textBox5.Text;
-            Sql(4, date);
-        }
-        private void textBox6_TextChanged(object sender, EventArgs e)
-        {
-            genre = textBox6.Text;
-            Sql(5, genre);
-        }
-        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
-        {
-        }
-        private void button1_Click(object sender, EventArgs e)
-        {
-            //▼変数定義
-            string id = "";
-            string music = "";
-            string artist = "";
-            string album = "";
-            string date = "";
-            string genre = "";
-            DialogResult result;
-            DataTable dataT = new DataTable();
-            //テキストボックスのテキスト用配列
-            string[] search = new string[6];
-            //項目名用配列
-            string[] yourName = { "MusicID", "MusicName", "ArtistName", "AlbumName", "ReleaseDate", "Genre" };
-            //▲変数定義
-            //▼メソッド定義
-            //SQL文作成メソッド
-            void Sql(int index, string sq)
-            {
-                search[index] = sq;
-                //全体で使用する基本のSQL、1=1はAND処理を楽にするため
-                string sql = "SELECT * FROM music WHERE 1 = 1";
-                //string sql = "SELECT * FROM music WHERE 1 = 1 AND CAST(TRACK_NO AS VARCHAR) LIKE '1%'";
-                for (int i = 0; i < search.Length; i++)
-                {
-                    string sea = search[i];
-                    //トラックナンバー用処理
-                    if (i == 0)
-                    {
-                        //前方一致処理
-                        sql += " AND " + "CAST(" + yourName[i] + " AS VARCHAR) LIKE '" + sea + "%'";
-                    }
-                    //リリース用処理
-                    else if (i == 4)
-                    {
-                        //後方一致処理
-                        sql += " AND " + "CAST(" + yourName[i] + " AS VARCHAR) LIKE '%" + sea + "'";
-                    }
-                    else
-                    {
-                        //部分一致処理
-                        sql += " AND " + yourName[i] + " LIKE '%" + sea + "%'";
-                    }
-                }
-                Debug.WriteLine("xxxxxxxxxxxxxxxxx");
-                Debug.WriteLine(sql);
-                Debug.WriteLine("xxxxxxxxxxxxxxxxx");
-                //データベース描画前に一度削除
-                dataGridView1.DataSource = "";
-                //sql文エラーに備えて
-                try
-                {
-                    //SQL文実行処理
-                    SqlConnection sqlconn = new SqlConnection(Properties.Settings.Default.sqlserver);
-                    SqlCommand command = new SqlCommand(sql, sqlconn);
-                    SqlDataAdapter adapter = new SqlDataAdapter(command);
-                    DataTable dt = new DataTable();
-                    adapter.Fill(dt);
-                    //データベースをGridに渡して表示
-                    dataGridView1.DataSource = dt;
-                    dataT = dt;
-                    //検索結果の件数を表示
-                    int count = dt.Rows.Count;
-                    label1.Text = count.ToString();
-                }
-                catch (Exception ex)
-                {
-                    //エラー表示
-                    MessageBox.Show(ex.ToString());
-                }
-            }
-            //ダイアログのYesNoを取得
-            result = MessageBox.Show("一覧データを出力しますか？", "出力の確認", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
-            MessageBox.Show("一覧データを出力しました");
-        }
         private void label1_Click(object sender, EventArgs e)
@@ -382,6 +382,8 @@
 }
 ```

誤字

2021/04/13 00:51

投稿

natume4948

スコア9

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -68,448 +68,306 @@
     {
-        //▼変数定義
-        string id = "";
-        string music = "";
-        string artist = "";
-        string album = "";
-        string date = "";
-        string genre = "";
-        DialogResult result;
-        DataTable dataT = new DataTable();
-        //テキストボックスのテキスト用配列
-        string[] search = new string[6];
-        //項目名用配列
-        string[] yourName = { "MusicID", "MusicName", "ArtistName", "AlbumName", "ReleaseDate", "Genre" };
-        //▲変数定義
-        //▼メソッド定義
-        //SQL文作成メソッド
-        private void Sql(int index, string sq)
-        {
-            search[index] = sq;
-            //全体で使用する基本のSQL、1=1はAND処理を楽にするため
-            string sql = "SELECT * FROM music WHERE 1 = 1";
-            //string sql = "SELECT * FROM music WHERE 1 = 1 AND CAST(TRACK_NO AS VARCHAR) LIKE '1%'";
-            for (int i = 0; i < search.Length; i++)
+        public Form1()
+        {
+            InitializeComponent();
+        }
+        private void Form1_Load(object sender, EventArgs e)
+        {
+            //maxとminを同じにすることでサイズ固定
+            this.MaximumSize = this.Size;
+            this.MinimumSize = this.Size;
+            //最大化・最小化無効
+            this.MaximizeBox = false;
+            this.MinimizeBox = false;
+            SqlConnection sqlconn = new SqlConnection(Properties.Settings.Default.sqlserver);
+            sqlconn.Open();
+            SqlCommand command = new SqlCommand("SELECT * from Musics", sqlconn);
+            SqlDataAdapter adapter = new SqlDataAdapter(command);
+            DataTable dt = new DataTable();
+            adapter.Fill(dt);
+            dataGridView1.DataSource = dt;
+            dataT = dt;
+            //検索結果の件数を表示
+            int count = dt.Rows.Count;
+            label1.Text = count.ToString();
+        }
+        private void textBox1_TextChanged(object sender, EventArgs e)
+        {
+            id = textBox1.Text;
+            //値の種類とテキストボックスと項目名を渡す
+            Sql(0, id);
+        }
+        private void textBox2_TextChanged(object sender, EventArgs e)
+        {
+            music = textBox2.Text;
+            Sql(1, music);
+        }
+        private void textBox3_TextChanged(object sender, EventArgs e)
+        {
+            artist = textBox3.Text;
+            Sql(2, artist);
+        }
+        private void textBox4_TextChanged(object sender, EventArgs e)
+        {
+            album = textBox4.Text;
+            Sql(3, album);
+        }
+        private void textBox5_TextChanged(object sender, EventArgs e)
+        {
+            date = textBox5.Text;
+            Sql(4, date);
+        }
+        private void textBox6_TextChanged(object sender, EventArgs e)
+        {
+            genre = textBox6.Text;
+            Sql(5, genre);
+        }
+        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
+        {
+        }
+        private void button1_Click(object sender, EventArgs e)
+        {
+            //▼変数定義
+            string id = "";
+            string music = "";
+            string artist = "";
+            string album = "";
+            string date = "";
+            string genre = "";
+            DialogResult result;
+            DataTable dataT = new DataTable();
+            //テキストボックスのテキスト用配列
+            string[] search = new string[6];
+            //項目名用配列
+            string[] yourName = { "MusicID", "MusicName", "ArtistName", "AlbumName", "ReleaseDate", "Genre" };
+            //▲変数定義
+            //▼メソッド定義
+            //SQL文作成メソッド
+            void Sql(int index, string sq)
             {
-                string sea = search[i];
+                search[index] = sq;
-                //トラックナンバー用処理
+                //全体で使用する基本のSQL、1=1はAND処理を楽にするため
+                string sql = "SELECT * FROM music WHERE 1 = 1";
+                //string sql = "SELECT * FROM music WHERE 1 = 1 AND CAST(TRACK_NO AS VARCHAR) LIKE '1%'";
-                if (i == 0)
+                for (int i = 0; i < search.Length; i++)
                 {
+                    string sea = search[i];
+                    //トラックナンバー用処理
+                    if (i == 0)
+                    {
-                    //前方一致処理
+                        //前方一致処理
-                    sql += " AND " + "CAST(" + yourName[i] + " AS VARCHAR) LIKE '" + sea + "%'";
+                        sql += " AND " + "CAST(" + yourName[i] + " AS VARCHAR) LIKE '" + sea + "%'";
+                    }
+                    //リリース用処理
+                    else if (i == 4)
+                    {
+                        //後方一致処理
+                        sql += " AND " + "CAST(" + yourName[i] + " AS VARCHAR) LIKE '%" + sea + "'";
+                    }
+                    else
+                    {
+                        //部分一致処理
+                        sql += " AND " + yourName[i] + " LIKE '%" + sea + "%'";
+                    }
                 }
+                Debug.WriteLine("xxxxxxxxxxxxxxxxx");
+                Debug.WriteLine(sql);
+                Debug.WriteLine("xxxxxxxxxxxxxxxxx");
+                //データベース描画前に一度削除
+                dataGridView1.DataSource = "";
-                //リリース用処理
+                //sql文エラーに備えて
-                else if (i == 4)
+                try
                 {
-                    //後方一致処理
+                    //SQL文実行処理
-                    sql += " AND " + "CAST(" + yourName[i] + " AS VARCHAR) LIKE '%" + sea + "'";
+                    SqlConnection sqlconn = new SqlConnection(Properties.Settings.Default.sqlserver);
+                    SqlCommand command = new SqlCommand(sql, sqlconn);
+                    SqlDataAdapter adapter = new SqlDataAdapter(command);
+                    DataTable dt = new DataTable();
+                    adapter.Fill(dt);
+                    //データベースをGridに渡して表示
+                    dataGridView1.DataSource = dt;
+                    dataT = dt;
+                    //検索結果の件数を表示
+                    int count = dt.Rows.Count;
+                    label1.Text = count.ToString();
                 }
-                else
+                catch (Exception ex)
                 {
-                    //部分一致処理
+                    //エラー表示
-                    sql += " AND " + yourName[i] + " LIKE '%" + sea + "%'";
+                    MessageBox.Show(ex.ToString());
                 }
             }
-            Debug.WriteLine("xxxxxxxxxxxxxxxxx");
-            Debug.WriteLine(sql);
-            Debug.WriteLine("xxxxxxxxxxxxxxxxx");
-            //データベース描画前に一度削除
-            dataGridView1.DataSource = "";
-            //sql文エラーに備えて
-            try
-            {
-                //SQL文実行処理
-                SqlConnection sqlconn = new SqlConnection(Properties.Settings.Default.sqlserver);
-                SqlCommand command = new SqlCommand(sql, sqlconn);
-                SqlDataAdapter adapter = new SqlDataAdapter(command);
-                DataTable dt = new DataTable();
-                adapter.Fill(dt);
-                //データベースをGridに渡して表示
-                dataGridView1.DataSource = dt;
-                dataT = dt;
-                //検索結果の件数を表示
+            //ダイアログのYesNoを取得
-                int count = dt.Rows.Count;
+            result = MessageBox.Show("一覧データを出力しますか？", "出力の確認", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
-                label1.Text = count.ToString();
+            MessageBox.Show("一覧データを出力しました");
-            }
+        }
-            catch (Exception e)
-            {
-                //エラー表示
-                //MessageBox.Show(e.ToString());
-            }
-        }
-        //xmlダイアログのYes後処理
-        //▲メソッド定義
-        public Form1()
-        {
-            InitializeComponent();
-        }
-        private void Form1_Load(object sender, EventArgs e)
-        {
-            //maxとminを同じにすることでサイズ固定
-            this.MaximumSize = this.Size;
-            this.MinimumSize = this.Size;
-            //最大化・最小化無効
-            this.MaximizeBox = false;
-            this.MinimizeBox = false;
-            SqlConnection sqlconn = new SqlConnection(Properties.Settings.Default.sqlserver);
-            sqlconn.Open();
-            SqlCommand command = new SqlCommand("SELECT * from Musics", sqlconn);
-            SqlDataAdapter adapter = new SqlDataAdapter(command);
-            DataTable dt = new DataTable();
-            adapter.Fill(dt);
-            dataGridView1.DataSource = dt;
-            dataT = dt;
-            //検索結果の件数を表示
-            int count = dt.Rows.Count;
-            label1.Text = count.ToString();
-        }
-        private void textBox1_TextChanged(object sender, EventArgs e)
-        {
-            id = textBox1.Text;
-            //値の種類とテキストボックスと項目名を渡す
-            Sql(0, id);
-        }
-        private void textBox2_TextChanged(object sender, EventArgs e)
-        {
-            music = textBox2.Text;
-            Sql(1, music);
-        }
-        private void textBox3_TextChanged(object sender, EventArgs e)
-        {
-            artist = textBox3.Text;
-            Sql(2, artist);
-        }
-        private void textBox4_TextChanged(object sender, EventArgs e)
-        {
-            album = textBox4.Text;
-            Sql(3, album);
-        }
-        private void textBox5_TextChanged(object sender, EventArgs e)
-        {
-            date = textBox5.Text;
-            Sql(4, date);
-        }
-        private void textBox6_TextChanged(object sender, EventArgs e)
-        {
-            genre = textBox6.Text;
-            Sql(5, genre);
-        }
-        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
-        {
-        }
-        private void button1_Click(object sender, EventArgs e)
-        {
-            //▼変数定義
-            string id = "";
-            string music = "";
-            string artist = "";
-            string album = "";
-            string date = "";
-            string genre = "";
-            DialogResult result;
-            DataTable dataT = new DataTable();
-            //テキストボックスのテキスト用配列
-            string[] search = new string[6];
-            //項目名用配列
-            string[] yourName = { "MusicID", "MusicName", "ArtistName", "AlbumName", "ReleaseDate", "Genre" };
-            //▲変数定義
-            //▼メソッド定義
-            //SQL文作成メソッド
-            void Sql(int index, string sq)
-            {
-                search[index] = sq;
-                //全体で使用する基本のSQL、1=1はAND処理を楽にするため
-                string sql = "SELECT * FROM music WHERE 1 = 1";
-                //string sql = "SELECT * FROM music WHERE 1 = 1 AND CAST(TRACK_NO AS VARCHAR) LIKE '1%'";
-                for (int i = 0; i < search.Length; i++)
-                {
-                    string sea = search[i];
-                    //トラックナンバー用処理
-                    if (i == 0)
-                    {
-                        //前方一致処理
-                        sql += " AND " + "CAST(" + yourName[i] + " AS VARCHAR) LIKE '" + sea + "%'";
-                    }
-                    //リリース用処理
-                    else if (i == 4)
-                    {
-                        //後方一致処理
-                        sql += " AND " + "CAST(" + yourName[i] + " AS VARCHAR) LIKE '%" + sea + "'";
-                    }
-                    else
-                    {
-                        //部分一致処理
-                        sql += " AND " + yourName[i] + " LIKE '%" + sea + "%'";
-                    }
-                }
-                Debug.WriteLine("xxxxxxxxxxxxxxxxx");
-                Debug.WriteLine(sql);
-                Debug.WriteLine("xxxxxxxxxxxxxxxxx");
-                //データベース描画前に一度削除
-                dataGridView1.DataSource = "";
-                //sql文エラーに備えて
-                try
-                {
-                    //SQL文実行処理
-                    SqlConnection sqlconn = new SqlConnection(Properties.Settings.Default.sqlserver);
-                    SqlCommand command = new SqlCommand(sql, sqlconn);
-                    SqlDataAdapter adapter = new SqlDataAdapter(command);
-                    DataTable dt = new DataTable();
-                    adapter.Fill(dt);
-                    //データベースをGridに渡して表示
-                    dataGridView1.DataSource = dt;
-                    dataT = dt;
-                    //検索結果の件数を表示
-                    int count = dt.Rows.Count;
-                    label1.Text = count.ToString();
-                }
-                catch (Exception ex)
-                {
-                    //エラー表示
-                    MessageBox.Show(ex.ToString());
-                }
-            }
-            //ダイアログのYesNoを取得
-            result = MessageBox.Show("一覧データを出力しますか？", "出力の確認", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
-            MessageBox.Show("一覧データを出力しました");
-        }
         private void label1_Click(object sender, EventArgs e)