private void BindDDLWorkShift() { SqlParameter[] arrparm = new SqlParameter[2]; arrparm[0] = new SqlParameter("@Action", "SELECT_ByStatus"); arrparm[1] = new SqlParameter("@Status", true); DataSet DSRecordWorkShift = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_EmployeeWorkShift_CRUD", arrparm); if (DSRecordWorkShift.Tables[0].Rows.Count > 0) { DDLWorkingShift.DataSource = DSRecordWorkShift.Tables[0]; DDLWorkingShift.DataTextField = "Name"; DDLWorkingShift.DataValueField = "ID"; DDLWorkingShift.DataBind(); DDLWorkingShift.Items.Insert(0, new ListItem("Select", "0")); } }