/// <summary> /// to bind the data from the database to the dropdown ddlWalls /// </summary> private void bindDDLWall() { objWallTypeBLL = new WallTypeBLL(); objWallTypeList = objWallTypeBLL.GetWallType(); ddlWalls.DataSource = objWallTypeList; ddlWalls.DataTextField = "WallTypeName"; ddlWalls.DataValueField = "WallTypeID"; ddlWalls.DataBind(); }
/// <summary> /// To Get Wall Type /// </summary> /// <returns></returns> public WallTypeList GetWallType() { proc = "USP_MST_GET_WALL"; cnn = new OracleConnection(con); WallTypeBO objWallType = null; WallTypeList lstWallTypeList = new WallTypeList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objWallType = new WallTypeBO(); if (ColumnExists(dr, "wallid") && !dr.IsDBNull(dr.GetOrdinal("wallid"))) { objWallType.WallTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("wallid"))); } if (ColumnExists(dr, "WallType") && !dr.IsDBNull(dr.GetOrdinal("WallType"))) { objWallType.WallTypeName = dr.GetString(dr.GetOrdinal("WallType")); } if (ColumnExists(dr, "IsDeleted") && !dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { objWallType.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } lstWallTypeList.Add(objWallType); } dr.Close(); } catch (Exception ex) { throw ex; } return(lstWallTypeList); }