how i execute this code

Question

1.00/5 (1 vote)

See more:

//i want this code should be run so that i will get values in dropdownlist which is listbox control //the values are available in database but how i will fetch in this dropdownlist which i have taken //in listbox

C#

protected void gvUserInfo_ItemDataBound(object sender, ListViewItemEventArgs e)
    {
       
      if (e.Item.ItemType == DataControlRowType.DataRow)//error
        {
            con.Open();
            DropDownList ddl = (DropDownList)e.Item.FindControl("ddsponcor");
       
           SqlCommand cmd = new SqlCommand("select sponcorid from Registration_Master", con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            con.Close();
            ddl.DataSource = ds;
            ddl.DataTextField = "sponcorid";
            ddl.DataValueField = "sponcorid";
            ddl.DataBind();
            ddl.Items.Insert(0, new ListItem("--Select--", "0"));
        }
    }

//Error
//Operator '==' cannot be applied to operands of type //'System.Web.UI.WebControls.ListViewItemType' and //'System.Web.UI.WebControls.DataControlRowType'

//so what should i use instead.. to execute my code. please help me...

Posted 2-Dec-12 3:31am

sumit kausalye

Updated 2-Dec-12 3:32am

Krunal Rohit

v2

Add a Solution

Comments

[no name] 2-Dec-12 9:49am

So you want ListBox items in DropDownList ??

bbirajdar 2-Dec-12 13:07pm

nice catch.. copy paste does not work always..

[no name] 2-Dec-12 23:28pm

I didn't get you..

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ManojDhobale · Answer 1 · 2012-12-02T23:22:00

Solution 3

control you are using should be datagrid and use following code to compare rows

SQL

if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{

}

Posted 2-Dec-12 23:22pm

ManojDhobale

Comments

sumit kausalye 3-Dec-12 11:29am

Control is ListView

[no name] 4-Dec-12 0:09am

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.listview.itemdatabound.aspx

Krunal Rohit · Answer 2 · 2012-12-02T03:51:00

Solution 1

C#

foreach (ListItem li in ListBox1.Items)
  {
      DropDownList1.Items.Add(li);
  }

Posted 2-Dec-12 3:51am

Krunal Rohit

Zaf Khan · Answer 3 · 2012-12-02T05:31:00

Solution 2

I cant be sure but in VB we use TYPEOF
so your IF statement would be written as......

if (TypeOf(e.Item) == DataControlRowType.DataRow)

It may not work (as i dont know c#) but theres a chance it may.

Posted 2-Dec-12 5:31am

Zaf Khan

Comments

sumit kausalye 3-Dec-12 1:43am

no it is not working

Zaf Khan 3-Dec-12 5:08am

The reason its not working is because yur trying to make an object type comparision the difference being your comparing a DATAROW to a LISTITEMEVNTARG to see if they are the same type, which obviously they're not.

And to clarify with you...
What your saying is that you have a drop down list and a listbox.
The dropdownlist is popultaed from the Database and you wish to populate the list from the dropdownlist, a type of filtering so-to-speak.

I dont think you need to COMPARE the "e as ListViewEventArgs" to a DATAROW, but to simply check that the parameter "e asLIstViewEventArgs") exists.

As Im not sure of C coding i canot tell you how
but if i was doing it in VB then i would write...
<pre>
If ((e is nothing) = False) Then
</pre>