public MusicCD GetMusicCD(int id) { MusicCD musicCD = null; SqlConnection connection = new SqlConnection(ConnectionString); connection.Open(); SqlCommand command = new SqlCommand("select * from musicCD", connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (id == Convert.ToInt32(reader["id"])) { MusicCDType type = MusicCD.getMusicCDType(reader["type"].ToString().Trim()); musicCD = new MusicCD(reader["singer"].ToString().Trim(), type, reader["name"].ToString(), Convert.ToInt32(reader["id"]), Convert.ToDouble(reader["price"]), reader["demo"].ToString().Trim(), reader["picture"].ToString(), reader["issue"].ToString()); musicCD.Id = Convert.ToInt32(reader["id"]); if (musicCD.Id > Product.Idcount) { Product.Idcount = musicCD.Id; } } } connection.Close(); return(musicCD); }
private void btnAddMusicCD_Click(object sender, EventArgs e) { ; MusicCDType type = MusicCD.getMusicCDType(cmbMusicType.SelectedItem.ToString()); adminUser.addNewMusicCD(txtMusicSinger.Text, type, txtMusicName.Text, Product.Idcount, Convert.ToDouble(txtMusicPrice.Text.Trim()), txtMusicName.Text.Trim() + ".jpg", txtMusicIssue.Text); DataTable dataTable = new DataTable(); DataTable = data.datagrid(dataTable, "musicCD"); dtgMusicCD.DataSource = DataTable; }