private void EditBook_Load(object sender, EventArgs e)
{
for (int i = 0; i <= 10; i++)
{
cmbQuantity.Items.Add(i);
}
for (int i = 1900; i <= DateTime.Now.Year; i++)
{
cmbYear.Items.Add(i);
}
string commString = "SELECT * FROM BooksInfo";
SqlCommand comm = new SqlCommand(commString, SQLConnection.Connection);
comm.Connection.Open();
SqlDataReader zaList = comm.ExecuteReader();
while (zaList.Read())
{
BookEdit b = new BookEdit();
b.ISBN = zaList.GetInt32(0);
b.BookName = zaList.GetString(1);
b.Author = zaList.GetString(2);
b.Year = zaList.GetInt32(3);
b.Language = zaList.GetInt32(4);
b.Category = zaList.GetInt32(5);
b.Quantity = zaList.GetInt32(6);
listBookID.Items.Add(b);
}
SQLConnection.Connection.Close();
string forCategory = "Select CategoryID, Description from Categories";
SqlDataAdapter adapter = new SqlDataAdapter(forCategory, SQLConnection.Connection);
DataTable dtable = new DataTable();
adapter.Fill(dtable);
cmbCategory.DataSource = dtable;
cmbCategory.DisplayMember = "Description";
cmbCategory.ValueMember = "CategoryID";
string zaLanguage = "Select ID, Language from Language";
SqlDataAdapter da = new SqlDataAdapter(zaLanguage, SQLConnection.Connection);
DataTable dt = new DataTable();
da.Fill(dt);
cmbLanguage.DataSource = dt;
cmbLanguage.DisplayMember = "Language";
cmbLanguage.ValueMember = "ID";
}
private void listBookID_SelectedIndexChanged(object sender, EventArgs e)
{
if (listBookID.SelectedIndex != -1)
{
BookEdit obj = (BookEdit)listBookID.SelectedItem;
txtISBN.Text = obj.ISBN.ToString();
txtAuthor.Text = obj.Author.ToString();
txtName.Text = obj.BookName.ToString();
cmbYear.Text = obj.Year.ToString();
cmbCategory.SelectedValue = obj.Category.ToString();
cmbLanguage.SelectedValue = obj.Language.ToString();
cmbQuantity.Text = obj.Quantity.ToString();
}
}
private void EditBook_Load(object sender, EventArgs e)
{
for (int i = 0; i <= 10; i++)
{
cmbQuantity.Items.Add(i);
}
for (int i = 1900; i <= DateTime.Now.Year; i++)
{
cmbYear.Items.Add(i);
}
string commString = "SELECT * FROM BooksInfo";
SqlCommand comm = new SqlCommand(commString, SQLConnection.Connection);
comm.Connection.Open();
SqlDataReader zaList = comm.ExecuteReader();
while (zaList.Read())
{
BookEdit b = new BookEdit();
b.ISBN = zaList.GetInt32(0);
b.BookName = zaList.GetString(1);
b.Author = zaList.GetString(2);
b.Year = zaList.GetInt32(3);
b.Language = zaList.GetInt32(4);
b.Category = zaList.GetInt32(5);
b.Quantity = zaList.GetInt32(6);
listBookID.Items.Add(b);
}
SQLConnection.Connection.Close();
string forCategory = "Select CategoryID, Description from Categories";
SqlDataAdapter adapter = new SqlDataAdapter(forCategory, SQLConnection.Connection);
DataTable dtable = new DataTable();
adapter.Fill(dtable);
cmbCategory.DataSource = dtable;
cmbCategory.DisplayMember = "Description";
cmbCategory.ValueMember = "CategoryID";
string zaLanguage = "Select ID, Language from Language";
SqlDataAdapter da = new SqlDataAdapter(zaLanguage, SQLConnection.Connection);
DataTable dt = new DataTable();
da.Fill(dt);
cmbLanguage.DataSource = dt;
cmbLanguage.DisplayMember = "Language";
cmbLanguage.ValueMember = "ID";
}