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 />

<br />
   <asp:Panel ID="pnlSearch" runat="server" CssClass="pnlsearch"><br />
	        <asp:Label ID="lblSearch" runat="server" Text="Station Name:" CssClass="lblsearch"<br />
	            TabIndex="0"></asp:Label><br />
	        <asp:TextBox ID="txtSearch" runat="server" CssClass="txtsearch" Width="190px" TabIndex="1"<br />
	             OnTextChanged="txtSearch_TextChanged"></asp:TextBox><br />
	        <asp:TextBox ID="TextBox1" runat="server" style="visibility:hidden;display:none;" /><br />
	        <asp:Button ID="btnSearch" runat="server" CssClass="btnsearch" Text="Search" Width="79px" <br />
	             TabIndex="2" OnClick="btnSearch_Click" /><br />
	    </asp:Panel><br />
    protected void lnkSearch_Click(object sender, EventArgs e)<br />
    {<br />
        pnlSearch.Visible = !pnlSearch.Visible;<br />
        if (pnlSearch.Visible == true)<br />
        {<br />
            txtSearch.Focus();<br />
        }<br />
    }<br />
    protected void txtSearch_TextChanged(object sender, EventArgs e)<br />
    {<br />
        btnSearch.Focus();<br />
    }<br />