private void GetKitap(string aranacakIfade)
{
DataTable dt = aranacakIfade == "" ? Islemler.GetKitaplar() : Islemler.GetLikeKitaplar(aranacakIfade);
dataGridView1.Rows.Clear();
lblToplamKitapSayisi.Text = "Toplam Kitap Sayısı: " + dt.Rows.Count.ToString();
foreach (DataRow item in dt.Rows)
{
/*0 KitapID
* 1 DemirbasNo
* 2 KitapAdi
* 3 YazarID
* 4 TurID
* 5 RafID
* 6 YayineviID
* 7 GelisSekli
* 8 Aciklama
* 9 GelisTar
* 10 Adet
* 11 Cilt
* 12 ResimYolu
* 13 Durum
*/
string kitapDurum = Islemler.GetKitapDurum(Convert.ToInt32(item[0]));
dataGridView1.Rows.Add(item[0], item[1], item[2], null, null, null, null,
null, item[8], item[9], item[10], item[11], null, kitapDurum);
DataGridViewComboBoxCell colYazar = (DataGridViewComboBoxCell)dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[3];
colYazar.DataSource = cmbYazar.DataSource as DataTable;
colYazar.DisplayMember = "Adi";
colYazar.ValueMember = "YazarID";
colYazar.Value = item[3];
DataGridViewComboBoxCell colKitapTur = (DataGridViewComboBoxCell)dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[4];
colKitapTur.DataSource = cmbKitapTuru.DataSource as DataTable;
colKitapTur.DisplayMember = "Adi";
colKitapTur.ValueMember = "KitapTurID";
colKitapTur.Value = item[4];
DataGridViewComboBoxCell colRaf = (DataGridViewComboBoxCell)dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[5];
colRaf.DataSource = cmbRaf.DataSource as DataTable;
colRaf.DisplayMember = "Adi";
colRaf.ValueMember = "RafID";
colRaf.Value = item[5];
DataGridViewComboBoxCell colYayinevi = (DataGridViewComboBoxCell)dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[6];
colYayinevi.DataSource = cmbYayinevi.DataSource as DataTable;
colYayinevi.DisplayMember = "Adi";
colYayinevi.ValueMember = "YayineviID";
colYayinevi.Value = item[6];
DataGridViewComboBoxCell colGelisSekli = (DataGridViewComboBoxCell)dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[7];
colGelisSekli.Value = item[7];
string resim = item[12].ToString();
if (resim == "")
{
continue;
}
Bitmap bitmap = new Bitmap(resim);
DataGridViewImageCell colResim = (DataGridViewImageCell)dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[12];
colResim.Value = bitmap;
colResim.Tag = resim;
}
}
