public void book_category()
{
SqlDataAdapter da = new SqlDataAdapter("add_book_proc", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@action", "bookcategory");
da.SelectCommand.Parameters.AddWithValue("@book_id", "");
da.SelectCommand.Parameters.AddWithValue("@book_name", "");
da.SelectCommand.Parameters.AddWithValue("@book_category", "");
da.SelectCommand.Parameters.AddWithValue("@subtitle", "");
da.SelectCommand.Parameters.AddWithValue("@isbn_no", "");
da.SelectCommand.Parameters.AddWithValue("@author", "");
da.SelectCommand.Parameters.AddWithValue("@cupboard", "");
da.SelectCommand.Parameters.AddWithValue("@cupboard_self", "");
da.SelectCommand.Parameters.AddWithValue("@edition", "");
da.SelectCommand.Parameters.AddWithValue("@publisher", "");
da.SelectCommand.Parameters.AddWithValue("@book_cost", "");
da.SelectCommand.Parameters.AddWithValue("@book_vendor", "");
da.SelectCommand.Parameters.AddWithValue("@copy", "");
da.SelectCommand.Parameters.AddWithValue("@Remarks", "");
da.SelectCommand.Parameters.AddWithValue("@ASN_no", "");
DataTable dt = new DataTable();
da.Fill(dt);
Bookcategory_ddl.DataSource = dt;
Bookcategory_ddl.DataTextField = "name";
Bookcategory_ddl.DataValueField = "pk_id";
Bookcategory_ddl.DataBind();
Bookcategory_ddl.Items.Insert(0, "Select Category");
}
public void book_category()
{
SqlDataAdapter da = new SqlDataAdapter("select * from book_category", con);
DataTable dt = new DataTable();
da.Fill(dt);
Bookcategory_ddl.DataSource = dt;
Bookcategory_ddl.DataTextField = "name";
Bookcategory_ddl.DataValueField = "pk_id";
Bookcategory_ddl.DataBind();
Bookcategory_ddl.Items.Insert(0, "Select Category");
}
