public void cupboard()
{
SqlDataAdapter da = new SqlDataAdapter("add_book_proc", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@action", "cupboard");
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);
Cupboard_ddl.DataSource = dt;
Cupboard_ddl.DataTextField = "name";
Cupboard_ddl.DataValueField = "pk_id";
Cupboard_ddl.DataBind();
Cupboard_ddl.Items.Insert(0, "Select Cupboard");
}
public void cupboard()
{
SqlDataAdapter da = new SqlDataAdapter("select * from create_cupboard", con);
DataTable dt = new DataTable();
da.Fill(dt);
Cupboard_ddl.DataSource = dt;
Cupboard_ddl.DataTextField = "name";
Cupboard_ddl.DataValueField = "pk_id";
Cupboard_ddl.DataBind();
Cupboard_ddl.Items.Insert(0, "Select Cupboard");
}
