ASP.NET

<br />
public void FillctrlList2(DropDownList ctrl, string procedurename,string fieldtext ,string fieldvalue , string conn, SqlCommand cmd, int i)<br />
    {<br />
<br />
        try<br />
        {<br />
            if (con == null)<br />
            {<br />
                this.openconnection(conn);<br />
                this.con.Open(); //  con.Open();<br />
<br />
            }<br />
            if (con.State == ConnectionState.Closed)<br />
            {<br />
                this.openconnection(conn);<br />
                con.Open();<br />
            }<br />
            ctrl.Items.Clear();<br />
            ctrl.Items.Add(new ListItem("Select One", "0" ));<br />
                 cmd.Connection = con;<br />
            cmd.CommandText = procedurename;<br />
            cmd.CommandType = CommandType.StoredProcedure;<br />
  <br />
            rdr = cmd.ExecuteReader();<br />
               <br />
            ctrl.DataSource = rdr;<br />
            ctrl.DataTextField = fieldtext;<br />
            ctrl.DataValueField = fieldvalue;<br />
            ctrl.DataBind();<br />
              <br />
            rdr.Close(); <br />
         }<br />
        catch (Exception ex)<br />
        {<br />
            throw ex;<br />
<br />
        }<br />
    }<br />
<br />