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 dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { pictureBox2.Image = null; int row = dataGridView1.CurrentCell.RowIndex; string nowalbum = dataGridView1.Rows[row].Cells[1].Value.ToString(); byte[] imagebytes = null; using (sqlAdapter sqladp = new sqlAdapter()) { //" + tempaname + " SqlDataReader dr; sqladp.getExecuteReader(out dr,"select cover from album where aname='" + nowalbum.Replace("'", "''") + "'"); while (dr.Read()) { imagebytes = (byte[])dr.GetValue(0); } dr.Close(); } if (imagebytes != null) { if (imagebytes[0] == 0) { pictureBox2.Image = touhou_music.Properties.Resources.x; return; } MemoryStream ms = new MemoryStream(imagebytes); Bitmap bmpt = new Bitmap(ms); //Image image = Image.FromStream(ms, true); //dr.Close(); //closeSQL(); pictureBox2.Image = bmpt; } }