ASP.NET

public void Fillemp(DropDownList ctrl, string procedurename, string conn, SqlCommand cmd)<br />
{	<br />
try<br />
{<br />
if (con == null)<br />
{<br />
this.openconnection(conn);<br />
this.con.Open(); // con.Open();<br />
}<br />
if (con.State == ConnectionState.Closed)<br />
{<br />
this.openconnection(conn);<br />
con.Open();<br />
}<br />
DataTable dtcompany = new DataTable();<br />
ctrl.Items.Clear();<br />
dtcompany = GetDataTable(procedurename, cmd);<br />
ctrl.Items.Add(new ListItem("Select One", "0"));<br />
ctrl.Items.Add(new ListItem("All" , "1"));<br />
ctrl.Items.Add(new ListItem("Self" , "2"));<br />
foreach (DataRow row in dtcompany.Rows)<br />
{<br />
ListItem item = new ListItem(row["emPname"].ToString(), row["er_emp_code"].ToString());<br />
item.Attributes.Add("title", row["empname"].ToString());<br />
int lvl = int.Parse(row["er_user_lvl"].ToString());<br />
switch(lvl)<br />
{<br />
case 8:<br />
 <br />
item.Attributes.Add("style", "color:green");<br />
break;<br />
case 7:<br />
item.Attributes.Add("style", "color:blue"); <br />
break;<br />
case 6:<br />
item.Attributes.Add("style", "color:red"); <br />
break;<br />
case 5:<br />
item.Attributes.Add("style", "color:purple"); <br />
break;<br />
default :<br />
item.Attributes.Add("style", "color:BLACK"); <br />
break;<br />
 <br />
}<br />
ctrl.Items.Add(item); <br />
 <br />
 <br />
 <br />
}<br />
 <br />
 <br />
}<br />
catch (Exception ex)<br />
{<br />
throw ex;<br />
}<br />
finally<br />
{<br />
if (con != null)<br />
{<br />
con.Close();<br />
}<br />
}<br />
}<br />

 if (!(IsPostBack)) <br />
{<br />
SqlCommand cmd = new SqlCommand();<br />
cmd.Parameters.AddWithValue("empcode", Membership.GetUser().UserName);<br />
Doctor dr = new Doctor();<br />
dr.Fillemp(Ddlzse, "SpGetPredecessor", "bbraunemisconnectstring", cmd);<br />
dr.FillctrlList1(Ddlsubdiv, "SPGETSUBDIV_GIVENEMP", "bbraunemisconnectstring", cmd, 0);<br />
 <br />
 <br />
}<br />

 <br />
<TD id ="tdddlzsm" style="BORDER-BOTTOM: gray 1px solid; TEXT-ALIGN: left ;     width: 490px;" align ="center"  ><br />
<asp:DropDownList id="Ddlzse" runat="server" Width="480px"  Font-Bold="False"   Font-Size="9pt"  Font-Names="Arial"   AppendDataBoundItems="True" ></asp:DropDownList><br />
</TD><br />
 <br />