databinding a Dropdownlist to another dropdownlist

[tshad]

Can you databind a dropdownlist to another dropdownlist?

I have 2 identical list. I am getting my data from a DataReader, so as soon
as I have bound the first DDL, I can't do it again to the next as the
dataReader can only be read once.

I tried:

ExperienceLevel .DataSource=dbR eader
ExperienceLevel .DataTextField= "Descriptio n"
ExperienceLevel .DataValueField ="ExperienceLev elID"
ExperienceLevel .databind()
ExperienceLevel .Items.Insert(0 , "Select Experience Level")
ExperienceLevel .Items(0).value = 0

ActualExperienc eLevel.DataSour ce=ExperienceLe vel
ActualExperienc eLevel.DataText Field= DataTextField
ActualExperienc eLevel.DataValu eField=DataValu eField
ActualExperienc eLevel.databind ()
ActualExperienc eLevel.Items.In sert(0, "Select Experience Level")
ActualExperienc eLevel.Items(0) .value = 0

But that doesn't seem to work.

Thanks,

Tom

[bcutting]

Fill an ArrayList with DictionaryEntri es, then bind to that.

Example
ArrayList arlItems = new ArrayList ();
while (dReader.Read ())
arlItem.Add (new DictionaryEntry (dReader["Descriptio n"].ToString (),
dReader["ExperienceLeve lID].ToString());

then create an array and set the datasources

ActualExperienc eLevel.DataSour ce = arrDEntries;
ActualExperienc eLevel.DataText Field = "value";
ActualExperienc eLevel.DataValu eField = "key";

Hope this helps,
Brendan

[timkling]

To bind to a dropdownlist the datasource must implement IListSource or
IEnumerable. DropDownList.It ems is enumerable.

So this will work:
ExperienceLevel .DataSource=dbR eader
ExperienceLevel .DataTextField= "Descriptio n"
ExperienceLevel .DataValueField ="ExperienceLev elID"
ExperienceLevel .DataBind()
ExperienceLevel .Items.Insert(0 , "Select Experience Level")
ExperienceLevel .Items(0).value = 0

ActualExperienc eLevel.DataSour ce=ExperienceLe vel.Items
ActualExperienc eLevel.DataBind ()

Don't add your default item because it is already in the list.

Tim

"tshad" wrote:

Can you databind a dropdownlist to another dropdownlist?

I have 2 identical list. I am getting my data from a DataReader, so as soon
as I have bound the first DDL, I can't do it again to the next as the
dataReader can only be read once.

I tried:

ExperienceLevel .DataSource=dbR eader
ExperienceLevel .DataTextField= "Descriptio n"
ExperienceLevel .DataValueField ="ExperienceLev elID"
ExperienceLevel .databind()
ExperienceLevel .Items.Insert(0 , "Select Experience Level")
ExperienceLevel .Items(0).value = 0

ActualExperienc eLevel.DataSour ce=ExperienceLe vel
ActualExperienc eLevel.DataText Field= DataTextField
ActualExperienc eLevel.DataValu eField=DataValu eField
ActualExperienc eLevel.databind ()
ActualExperienc eLevel.Items.In sert(0, "Select Experience Level")
ActualExperienc eLevel.Items(0) .value = 0

But that doesn't seem to work.

Thanks,

Tom

[tshad]

"timkling" <ti******@discu ssions.microsof t.com> wrote in message
news:D8******** *************** ***********@mic rosoft.com...

To bind to a dropdownlist the datasource must implement IListSource or
IEnumerable. DropDownList.It ems is enumerable.

So this will work:
ExperienceLevel .DataSource=dbR eader
ExperienceLevel .DataTextField= "Descriptio n"
ExperienceLevel .DataValueField ="ExperienceLev elID"
ExperienceLevel .DataBind()
ExperienceLevel .Items.Insert(0 , "Select Experience Level")
ExperienceLevel .Items(0).value = 0

ActualExperienc eLevel.DataSour ce=ExperienceLe vel.Items
ActualExperienc eLevel.DataBind ()

Worked great.
Don't add your default item because it is already in the list.
Which default item - the insert?

ExperienceLevel .Items.Insert(0 , "Select Experience Level")
Thanks,

Tom
Tim

"tshad" wrote:

Can you databind a dropdownlist to another dropdownlist?

I have 2 identical list. I am getting my data from a DataReader, so as
soon
as I have bound the first DDL, I can't do it again to the next as the
dataReader can only be read once.

I tried:

ExperienceLevel .DataSource=dbR eader
ExperienceLevel .DataTextField= "Descriptio n"
ExperienceLevel .DataValueField ="ExperienceLev elID"
ExperienceLevel .databind()
ExperienceLevel .Items.Insert(0 , "Select Experience Level")
ExperienceLevel .Items(0).value = 0

ActualExperienc eLevel.DataSour ce=ExperienceLe vel
ActualExperienc eLevel.DataText Field= DataTextField
ActualExperienc eLevel.DataValu eField=DataValu eField
ActualExperienc eLevel.databind ()
ActualExperienc eLevel.Items.In sert(0, "Select Experience Level")
ActualExperienc eLevel.Items(0) .value = 0

But that doesn't seem to work.

Thanks,

Tom

[Bruce Barker]

a datareader can not be used twice, because it forward only cursor. the
second databind will find itself at the end.

-- bruce (sqlwork.com)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:OY******** ******@TK2MSFTN GP14.phx.gbl...

Can you databind a dropdownlist to another dropdownlist?

I have 2 identical list. I am getting my data from a DataReader, so as
soon as I have bound the first DDL, I can't do it again to the next as the
dataReader can only be read once.

I tried:

ExperienceLevel .DataSource=dbR eader
ExperienceLevel .DataTextField= "Descriptio n"
ExperienceLevel .DataValueField ="ExperienceLev elID"
ExperienceLevel .databind()
ExperienceLevel .Items.Insert(0 , "Select Experience Level")
ExperienceLevel .Items(0).value = 0

ActualExperienc eLevel.DataSour ce=ExperienceLe vel
ActualExperienc eLevel.DataText Field= DataTextField
ActualExperienc eLevel.DataValu eField=DataValu eField
ActualExperienc eLevel.databind ()
ActualExperienc eLevel.Items.In sert(0, "Select Experience Level")
ActualExperienc eLevel.Items(0) .value = 0

But that doesn't seem to work.

Thanks,

Tom

[timkling]

> Which default item - the insert?

ExperienceLevel .Items.Insert(0 , "Select Experience Level") Yes. Do it to the first list, but after that it will be in the second list
automatically.
Tim

"tshad" wrote:
"timkling" <ti******@discu ssions.microsof t.com> wrote in message
news:D8******** *************** ***********@mic rosoft.com...

To bind to a dropdownlist the datasource must implement IListSource or
IEnumerable. DropDownList.It ems is enumerable.

So this will work:
ExperienceLevel .DataSource=dbR eader
ExperienceLevel .DataTextField= "Descriptio n"
ExperienceLevel .DataValueField ="ExperienceLev elID"
ExperienceLevel .DataBind()
ExperienceLevel .Items.Insert(0 , "Select Experience Level")
ExperienceLevel .Items(0).value = 0

ActualExperienc eLevel.DataSour ce=ExperienceLe vel.Items
ActualExperienc eLevel.DataBind ()

Worked great.

Don't add your default item because it is already in the list.

Which default item - the insert?

ExperienceLevel .Items.Insert(0 , "Select Experience Level")
Thanks,

Tom

Tim

"tshad" wrote:

Can you databind a dropdownlist to another dropdownlist?

I have 2 identical list. I am getting my data from a DataReader, so as
soon
as I have bound the first DDL, I can't do it again to the next as the
dataReader can only be read once.

I tried:

ExperienceLevel .DataSource=dbR eader
ExperienceLevel .DataTextField= "Descriptio n"
ExperienceLevel .DataValueField ="ExperienceLev elID"
ExperienceLevel .databind()
ExperienceLevel .Items.Insert(0 , "Select Experience Level")
ExperienceLevel .Items(0).value = 0

ActualExperienc eLevel.DataSour ce=ExperienceLe vel
ActualExperienc eLevel.DataText Field= DataTextField
ActualExperienc eLevel.DataValu eField=DataValu eField
ActualExperienc eLevel.databind ()
ActualExperienc eLevel.Items.In sert(0, "Select Experience Level")
ActualExperienc eLevel.Items(0) .value = 0

But that doesn't seem to work.

Thanks,

Tom

[tshad]

"timkling" <ti******@discu ssions.microsof t.com> wrote in message
news:A7******** *************** ***********@mic rosoft.com...

Which default item - the insert?

ExperienceLevel .Items.Insert(0 , "Select Experience Level") Yes. Do it to the first list, but after that it will be in the second
list
automatically.

Worked as advertised.

Thanks,

Tom
Tim

"tshad" wrote:

"timkling" <ti******@discu ssions.microsof t.com> wrote in message
news:D8******** *************** ***********@mic rosoft.com...

> To bind to a dropdownlist the datasource must implement IListSource or
> IEnumerable. DropDownList.It ems is enumerable.
>
> So this will work:
> ExperienceLevel .DataSource=dbR eader
> ExperienceLevel .DataTextField= "Descriptio n"
> ExperienceLevel .DataValueField ="ExperienceLev elID"
> ExperienceLevel .DataBind()
> ExperienceLevel .Items.Insert(0 , "Select Experience Level")
> ExperienceLevel .Items(0).value = 0
>
> ActualExperienc eLevel.DataSour ce=ExperienceLe vel.Items
> ActualExperienc eLevel.DataBind ()
>

Worked great.

> Don't add your default item because it is already in the list.

Which default item - the insert?

ExperienceLevel .Items.Insert(0 , "Select Experience Level")
Thanks,

Tom

>
> Tim
>
> "tshad" wrote:
>
>> Can you databind a dropdownlist to another dropdownlist?
>>
>> I have 2 identical list. I am getting my data from a DataReader, so as
>> soon
>> as I have bound the first DDL, I can't do it again to the next as the
>> dataReader can only be read once.
>>
>> I tried:
>>
>> ExperienceLevel .DataSource=dbR eader
>> ExperienceLevel .DataTextField= "Descriptio n"
>> ExperienceLevel .DataValueField ="ExperienceLev elID"
>> ExperienceLevel .databind()
>> ExperienceLevel .Items.Insert(0 , "Select Experience Level")
>> ExperienceLevel .Items(0).value = 0
>>
>> ActualExperienc eLevel.DataSour ce=ExperienceLe vel
>> ActualExperienc eLevel.DataText Field= DataTextField
>> ActualExperienc eLevel.DataValu eField=DataValu eField
>> ActualExperienc eLevel.databind ()
>> ActualExperienc eLevel.Items.In sert(0, "Select Experience Level")
>> ActualExperienc eLevel.Items(0) .value = 0
>>
>> But that doesn't seem to work.
>>
>> Thanks,
>>
>> Tom
>>
>>
>>

[tshad]

"timkling" <ti******@discu ssions.microsof t.com> wrote in message
news:A7******** *************** ***********@mic rosoft.com...

Which default item - the insert?

ExperienceLevel .Items.Insert(0 , "Select Experience Level") Yes. Do it to the first list, but after that it will be in the second
list
automatically.
Tim

Just realized that it wasn't doing it correctly.

I have the following:

CopyResumeTo1.D ataSource = dbReader
CopyResumeTo1.D ataValueField = "UserID"
CopyResumeTo1.D ataTextField = "FullName"
CopyResumeTo1.D ataBind()
CopyResumeTo1.I tems.Insert(0, new ListItem("Selec t Current User","0"))

CopyResumeTo2.D ataSource=CopyR esumeTo1.Items
CopyResumeTo2.D ataBind()

CopyResumeTo3.D ataSource=CopyR esumeTo1.Items
CopyResumeTo3.D ataBind()

The first one (CopyResumeTo1) is working correctly. It has the
DataValueField (UserID) as an integer and the DataTextFiled (FullName) as
the name and if I look at the ViewSource, it is correct.

But when I look at the other 2 dropdowns, it is putting the FullName in both
the DataValueField and the DataTextField.

Also, I thought my insert would put a 0 in the Value field, but it put a
blank there. Is my format incorrect?

CopyResumeTo1.I tems.Insert(0, new ListItem("Selec t Current User","0")

Thanks,

Tom
"tshad" wrote:

"timkling" <ti******@discu ssions.microsof t.com> wrote in message
news:D8******** *************** ***********@mic rosoft.com...

> To bind to a dropdownlist the datasource must implement IListSource or
> IEnumerable. DropDownList.It ems is enumerable.
>
> So this will work:
> ExperienceLevel .DataSource=dbR eader
> ExperienceLevel .DataTextField= "Descriptio n"
> ExperienceLevel .DataValueField ="ExperienceLev elID"
> ExperienceLevel .DataBind()
> ExperienceLevel .Items.Insert(0 , "Select Experience Level")
> ExperienceLevel .Items(0).value = 0
>
> ActualExperienc eLevel.DataSour ce=ExperienceLe vel.Items
> ActualExperienc eLevel.DataBind ()
>

Worked great.

> Don't add your default item because it is already in the list.

Which default item - the insert?

ExperienceLevel .Items.Insert(0 , "Select Experience Level")
Thanks,

Tom

>
> Tim
>
> "tshad" wrote:
>
>> Can you databind a dropdownlist to another dropdownlist?
>>
>> I have 2 identical list. I am getting my data from a DataReader, so as
>> soon
>> as I have bound the first DDL, I can't do it again to the next as the
>> dataReader can only be read once.
>>
>> I tried:
>>
>> ExperienceLevel .DataSource=dbR eader
>> ExperienceLevel .DataTextField= "Descriptio n"
>> ExperienceLevel .DataValueField ="ExperienceLev elID"
>> ExperienceLevel .databind()
>> ExperienceLevel .Items.Insert(0 , "Select Experience Level")
>> ExperienceLevel .Items(0).value = 0
>>
>> ActualExperienc eLevel.DataSour ce=ExperienceLe vel
>> ActualExperienc eLevel.DataText Field= DataTextField
>> ActualExperienc eLevel.DataValu eField=DataValu eField
>> ActualExperienc eLevel.databind ()
>> ActualExperienc eLevel.Items.In sert(0, "Select Experience Level")
>> ActualExperienc eLevel.Items(0) .value = 0
>>
>> But that doesn't seem to work.
>>
>> Thanks,
>>
>> Tom
>>
>>
>>

[tshad]

"tshad" <ts**********@f tsolutions.com> wrote in message
news:u$******** ******@TK2MSFTN GP14.phx.gbl...

"timkling" <ti******@discu ssions.microsof t.com> wrote in message
news:A7******** *************** ***********@mic rosoft.com...

Which default item - the insert?

ExperienceLevel .Items.Insert(0 , "Select Experience Level") Yes. Do it to the first list, but after that it will be in the second
list
automatically.
Tim

Just realized that it wasn't doing it correctly.

I have the following:

CopyResumeTo1.D ataSource = dbReader
CopyResumeTo1.D ataValueField = "UserID"
CopyResumeTo1.D ataTextField = "FullName"
CopyResumeTo1.D ataBind()
CopyResumeTo1.I tems.Insert(0, new ListItem("Selec t Current User","0"))

CopyResumeTo2.D ataSource=CopyR esumeTo1.Items
CopyResumeTo2.D ataBind()

CopyResumeTo3.D ataSource=CopyR esumeTo1.Items
CopyResumeTo3.D ataBind()

I found what needed to be added to make this work.

You also need the DataValueField and DataTextField defined, but refering to
the properties of the ListItem and not the original DataReader. So the
above needs to be done as so:

CopyResumeTo1.D ataSource = dbReader
CopyResumeTo1.D ataValueField = "UserID"
CopyResumeTo1.D ataTextField = "FullName"
CopyResumeTo1.D ataBind()
CopyResumeTo1.I tems.Insert(0, new ListItem("Selec t Current User","0"))

CopyResumeTo2.D ataSource=CopyR esumeTo1.Items
CopyResumeTo2.D ataValueField = "Value"
CopyResumeTo2.D ataTextField = "Text"
CopyResumeTo2.D ataBind()

CopyResumeTo3.D ataSource=CopyR esumeTo1.Items
CopyResumeTo3.D ataValueField = "Value"
CopyResumeTo3.D ataTextField = "Text"
CopyResumeTo3.D ataBind()

In DataReader you use the Column name as the source, if you use the
ListItem - there is no property "UserID" or "FullName". There are 3
properties - "Selected", "Value" and "Text". In this case, the Value and
Text properties.

The first one (CopyResumeTo1) is working correctly. It has the
DataValueField (UserID) as an integer and the DataTextFiled (FullName) as
the name and if I look at the ViewSource, it is correct.

But when I look at the other 2 dropdowns, it is putting the FullName in
both the DataValueField and the DataTextField.

Also, I thought my insert would put a 0 in the Value field, but it put a
blank there. Is my format incorrect?
Actually, this format was correct, but I was doing a refresh to check it and
I was not re-loading the dropdowns, once I did, it worked fine.

Tom

CopyResumeTo1.I tems.Insert(0, new ListItem("Selec t Current User","0")

Thanks,

Tom

"tshad" wrote:

"timkling" <ti******@discu ssions.microsof t.com> wrote in message
news:D8******** *************** ***********@mic rosoft.com...
> To bind to a dropdownlist the datasource must implement IListSource or
> IEnumerable. DropDownList.It ems is enumerable.
>
> So this will work:
> ExperienceLevel .DataSource=dbR eader
> ExperienceLevel .DataTextField= "Descriptio n"
> ExperienceLevel .DataValueField ="ExperienceLev elID"
> ExperienceLevel .DataBind()
> ExperienceLevel .Items.Insert(0 , "Select Experience Level")
> ExperienceLevel .Items(0).value = 0
>
> ActualExperienc eLevel.DataSour ce=ExperienceLe vel.Items
> ActualExperienc eLevel.DataBind ()
>

Worked great.

> Don't add your default item because it is already in the list.

Which default item - the insert?

ExperienceLevel .Items.Insert(0 , "Select Experience Level")
Thanks,

Tom
>
> Tim
>
> "tshad" wrote:
>
>> Can you databind a dropdownlist to another dropdownlist?
>>
>> I have 2 identical list. I am getting my data from a DataReader, so
>> as
>> soon
>> as I have bound the first DDL, I can't do it again to the next as the
>> dataReader can only be read once.
>>
>> I tried:
>>
>> ExperienceLevel .DataSource=dbR eader
>> ExperienceLevel .DataTextField= "Descriptio n"
>> ExperienceLevel .DataValueField ="ExperienceLev elID"
>> ExperienceLevel .databind()
>> ExperienceLevel .Items.Insert(0 , "Select Experience Level")
>> ExperienceLevel .Items(0).value = 0
>>
>> ActualExperienc eLevel.DataSour ce=ExperienceLe vel
>> ActualExperienc eLevel.DataText Field= DataTextField
>> ActualExperienc eLevel.DataValu eField=DataValu eField
>> ActualExperienc eLevel.databind ()
>> ActualExperienc eLevel.Items.In sert(0, "Select Experience Level")
>> ActualExperienc eLevel.Items(0) .value = 0
>>
>> But that doesn't seem to work.
>>
>> Thanks,
>>
>> Tom
>>
>>
>>