private void BindRowItemList()
{
SqlParameter[] arrParam = new SqlParameter[1];
arrParam[0] = new SqlParameter("@Action", "SELECT");
DataSet DSRecords = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_RawMaterial_CRUD", arrParam);
if (DSRecords.Tables[0].Rows.Count > 0)
{
DDLItemList.DataSource = DSRecords.Tables[0];
DDLItemList.DataTextField = "Name";
DDLItemList.DataValueField = "ID";
DDLItemList.DataBind();
DDLItemList.Items.Insert(0, new ListItem("Select", "0"));
}
}
public void BindItemFinishTypeList()
{
SqlParameter[] arr = new SqlParameter[1];
arr[0] = new SqlParameter("@Action", "SELECT");
DataSet ds = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_FinishMaterial_CRUD", arr);
if (ds.Tables[0].Rows.Count > 0)
{
DDLItemList.DataSource = ds.Tables[0];
DDLItemList.DataTextField = "Name";
DDLItemList.DataValueField = "ID";
DDLItemList.DataBind();
DDLItemList.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0"));
}
}
