How to format "Drop Down List" TextFields C#

[missshaikh]

Hi All Friends.

I need your help..

I want to format Bold Italic in Drop Down List Control in C#.i retrieve my data from db.

like this .

________________
CD ROOM
CD-R Sony
CD-R HP
DVD- Room
Motherboard
Intell PIII
Intell PII
IBM PII
DEL PIII
KeyBoard-Mouse
Dell Keybord
SP Keybord
HDD Disk
Segat HDD Disk
40GB HDD
180GB HDD


i want to show like this in my ddl C# from DB. I need to know how to formate ddl????

:( plzzzzzz Answare me

[nateraaaa]

Hi All Friends.

I need your help..

I want to format Bold Italic in Drop Down List Control in C#.i retrieve my data from db.

like this .

________________
CD ROOM
CD-R Sony
CD-R HP
DVD- Room
Motherboard
Intell PIII
Intell PII
IBM PII
DEL PIII
KeyBoard-Mouse
Dell Keybord
SP Keybord
HDD Disk
Segat HDD Disk
40GB HDD
180GB HDD


i want to show like this in my ddl C# from DB. I need to know how to formate ddl????

:( plzzzzzz Answare me

I have researched many sites trying to find the answer to this question. This is what I found that seemed to be the most helpful.

 protected void Page_Load(object sender, System.EventArgs e) {
        SqlDataReader dr;
        string CONNECTION_STRING = "Data Source=MCN004;Initial Catalog=student;Integrated Security=True";
        string sQuery = "select Rollno, Name, Course from student";
        SqlConnection cn = new SqlConnection(CONNECTION_STRING);
        SqlCommand cmd = new SqlCommand(sQuery, cn);
        cn.Open();
        dr = cmd.ExecuteReader;
        while (dr.Read) {
            ListItem li = new ListItem(dr["Name"], dr["Course"]);
            switch (dr["Rollno"]) {
                case 1:
                    li.Attributes.Add("style", "color:red");
                    break;
                case 2:
                    li.Attributes.Add("style", "color:Green");
                    break;
                case 3:
                    li.Attributes.Add("style", "color:voilet");
                    break;
                case 4:
                    li.Attributes.Add("style", "color:darkolivegreen");
                    break;
                default:
                    li.Attributes.Add("style", "color:fuchsia");
                    break;
            }
            ddlStudent.Items.Add(li);
        }
        cn.Close();
    }

To change this and make the text bold replace color:whatever with font-weight:bold and to make it italic you will need to use font-style:italic.
I would prefer using something other than a switch statement here but give this a try and let us know if this will work for you.

Nathan