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"); }