private void comboBox6_SelectedIndexChanged(object sender, EventArgs e) { comboBox7.Items.Clear(); comboBox8.Items.Clear(); comboBox10.Items.Clear(); comboBox11.Items.Clear(); comboBox12.Items.Clear(); comboBox9.Items.Clear(); modtrack = comboBox6.Text; modscode = modacode + modtrack; List<DataTable> dt; List<ComboBox> CB = new List<ComboBox>(6); CB.Add(comboBox7); CB.Add(comboBox8); CB.Add(comboBox9); CB.Add(comboBox10); CB.Add(comboBox11); CB.Add(comboBox12); DataSet modOrigin = new DataSet(); try { using (sqlAdapter sqladp = new sqlAdapter()) { sqladp.getDataSet("select origin from [ori],song where ori.oricode=song.oricode and scode='" + modscode + "'",out modOrigin); modorigin = modOrigin.Tables[0].Rows[0][0].ToString(); sqladp.getDataTables(out dt, "select lyric from [song] where scode='" + modscode + "'", "select sname from [song] where scode='" + modscode + "'", "select arranger from [song] where scode='" + modscode + "'", "select style from [song] where scode='" + modscode + "'", "select vocal from [song] where scode='" + modscode + "'", "select distinct origin from [ori]"); string sql = "select oricode from [ori] where origin = '" + modorigin + "'"; modoricode = sqladp.ExecuteScalar(sql) as string; } Program.fillIn(ref dt, ref CB); comboBox12.SelectedIndex = comboBox12.Items.IndexOf(modorigin); } catch(Exception) { MessageBox.Show("无此曲目", "提示"); } }
private void Form4_Load(object sender, EventArgs e) { // imagebytes = ImageToStream(".\\x.jpg"); // imagebytes[0] =0; imagebytes = new byte[1]; imagebytes[0] = 0; List<ComboBox> CB = new List<ComboBox>(11); List<DataTable> dt; CB.Add(comboBox2); CB.Add(comboBox3); CB.Add(comboBox4); CB.Add(comboBox5); CB.Add(comboBox6); CB.Add(comboBox7); CB.Add(comboBox8); CB.Add(comboBox9); CB.Add(comboBox10); CB.Add(comboBox11); CB.Add(comboBox12); using (sqlAdapter sqladp = new sqlAdapter()) { try { sqladp.getDataTables(out dt, "select distinct acode from [album]", "select distinct gname from [group]", "select distinct aname from [album]", "select distinct [time] from [album]", "select distinct track from [song]", "select distinct lyric from [song]", "select distinct sname from [song]", "select distinct arranger from [song]", "select distinct style from [song]", "select distinct vocal from [song]", "select distinct origin from [ori]"); Program.fillIn(ref dt, ref CB); } catch (System.Exception ex) { System.Diagnostics.Debug.Write(ex.Message); } } //comboBox2.SelectedIndex = 0; //for (int i = 0; i < ds3.Tables[0].Rows.Count; i++) //{ // comboBox3.Items.Add(ds3.Tables[0].Rows[i][0]); //} //comboBox3.SelectedIndex = 0; //for (int i = 0; i < ds4.Tables[0].Rows.Count; i++) //{ // comboBox4.Items.Add(ds4.Tables[0].Rows[i][0]); //} //comboBox4.SelectedIndex = 0; //for (int i = 0; i < ds5.Tables[0].Rows.Count; i++) //{ // comboBox5.Items.Add(ds5.Tables[0].Rows[i][0]); //} //comboBox5.SelectedIndex = 0; //for (int i = 0; i < ds6.Tables[0].Rows.Count; i++) //{ // comboBox6.Items.Add(ds6.Tables[0].Rows[i][0]); //} //comboBox6.SelectedIndex = 0; //for (int i = 0; i < ds7.Tables[0].Rows.Count; i++) //{ // comboBox7.Items.Add(ds7.Tables[0].Rows[i][0]); //} //comboBox7.SelectedIndex = 0; //for (int i = 0; i < ds8.Tables[0].Rows.Count; i++) //{ // comboBox8.Items.Add(ds8.Tables[0].Rows[i][0]); //} //comboBox8.SelectedIndex = 0; //for (int i = 0; i < ds9.Tables[0].Rows.Count; i++) //{ // comboBox9.Items.Add(ds9.Tables[0].Rows[i][0]); //} //comboBox9.SelectedIndex = 0; //for (int i = 0; i < ds10.Tables[0].Rows.Count; i++) //{ // comboBox10.Items.Add(ds10.Tables[0].Rows[i][0]); //} //comboBox10.SelectedIndex = 0; //for (int i = 0; i < ds11.Tables[0].Rows.Count; i++) //{ // comboBox11.Items.Add(ds11.Tables[0].Rows[i][0]); //} //comboBox11.SelectedIndex = 0; //for (int i = 0; i < ds12.Tables[0].Rows.Count; i++) //{ // comboBox12.Items.Add(ds12.Tables[0].Rows[i][0]); //} //comboBox12.SelectedIndex = 0; }
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e) { DataSet ds6 = new DataSet(); comboBox1.Items.Clear(); comboBox3.Items.Clear(); comboBox4.Items.Clear(); comboBox5.Items.Clear(); comboBox7.Items.Clear(); comboBox8.Items.Clear(); comboBox10.Items.Clear(); comboBox11.Items.Clear(); comboBox12.Items.Clear(); comboBox9.Items.Clear(); modacode = comboBox2.Text; modgcode = modacode.Substring(0, 4); List<DataTable> dt; List<ComboBox> CB = new List<ComboBox>(4); CB.Add(comboBox3); CB.Add(comboBox4); CB.Add(comboBox5); CB.Add(comboBox6); using (sqlAdapter sqladp = new sqlAdapter()) { try { sqladp.getDataTables(out dt,"select distinct gcode from [gas] where acode='" + modacode + "'"); for (int i = 0; i < dt[0].Rows.Count; i++) { comboBox1.Items.Add(dt[0].Rows[i][0]); } comboBox1.SelectedIndex = 0; modgcode = comboBox1.Text; sqladp.getDataTables(out dt, "select gname from [group] where gcode='" + modgcode + "'", "select aname from [album] where acode='" + modacode + "'", "select [time] from [album] where acode='" + modacode + "'", "select distinct track from [song],gas where gas.scode=song.scode and acode='" + modacode + "'"); comboBox6.Items.Clear(); Program.fillIn(ref dt, ref CB); modgcode = comboBox1.Text; modgname = comboBox3.Text; modaname = comboBox4.Text; modtime = comboBox5.Text; comboBox6.SelectedIndex = 0; } catch(Exception) { MessageBox.Show("无此曲目", "提示"); } } pictureBox1.Image = null; // byte[] imagebytes = null; using (sqlAdapter sqladp = new sqlAdapter()) { SqlDataReader dr; sqladp.getExecuteReader(out dr,"select cover from album where acode='" + modacode + "'"); while (dr.Read()) { imagebytes1 = (byte[])dr.GetValue(0); } dr.Close(); } if (imagebytes1 != null) { if (imagebytes1[0] == 0) { pictureBox1.Image = touhou_music.Properties.Resources.x; return; } MemoryStream ms = new MemoryStream(imagebytes1); Bitmap bmpt = new Bitmap(ms); //Image image = Image.FromStream(ms, true); //dr.Close(); //closeSQL(); pictureBox1.Image = bmpt; } }
private void button1_Click(object sender, EventArgs e) { comboBox3.Items.Clear(); comboBox4.Items.Clear(); comboBox5.Items.Clear(); comboBox7.Items.Clear(); comboBox8.Items.Clear(); comboBox9.Items.Clear(); comboBox10.Items.Clear(); comboBox11.Items.Clear(); comboBox12.Items.Clear(); List<ComboBox> CB = new List<ComboBox>(9); List<DataTable> dt; CB.Add(comboBox3); CB.Add(comboBox4); CB.Add(comboBox5); CB.Add(comboBox7); CB.Add(comboBox8); CB.Add(comboBox9); CB.Add(comboBox10); CB.Add(comboBox11); CB.Add(comboBox12); modacode = comboBox2.Text; modtrack = comboBox6.Text; modscode = modacode + modtrack; modgcode = modacode.Substring(0, 4); using (sqlAdapter sqladp = new sqlAdapter()) { try { sqladp.getDataTables(out dt, "select gname from [group] where gcode='" + modgcode + "'", "select aname from [album] where acode='" + modacode + "'", "select [time] from [album] where acode='" + modacode + "'", "select lyric from [song] where scode='" + modscode + "'","select sname from [song] where scode='" + modscode + "'", "select arranger from [song] where scode='" + modscode + "'","select style from [song] where scode='" + modscode + "'", "select vocal from [song] where scode='" + modscode + "'", "select origin from [ori],song where ori.oricode=song.oricode and scode='" + modscode + "'"); for (int i = 0; i < dt.Count; i++) { try { for (int j = 0; j < dt[i].Rows.Count; j++) { CB[i].Items.Add(dt[i].Rows[j][0]); } CB.ElementAt(i).SelectedIndex = 0; } catch (System.Exception ex) { System.Diagnostics.Debug.Write(ex.Message); MessageBox.Show("无此曲目", "提示"); } } } catch (System.Exception ex) { System.Diagnostics.Debug.Write(ex.Message); } //modgname = comboBox3.Text; //modaname = comboBox4.Text; //modtime = comboBox5.Text; // modacode = comboBox2.Text; // modtrack = comboBox6.Text; } }