Could someone help me how to add value to A item based on other selected value??(c#)

Question

hwa 0 Newbie Poster

16 Years Ago

My problem is I want to add in a value to a LABEL based on selected value in the DropDownList !!

Example:

tbl_abc

ID Sequence Name
-----------------------------------------------
1 2 Michael
2 3 Jenny
3 4 Max
4 4 Max
5 2 Michael
6 4 Max
7 3 Jenny
8 5 Alice
-----------------------------------------------

ID-(asp:label)
Sequence-(asp:label)
Name-(asp:DropDownList)

-If I choose Max from the DropDownList then the Sequence_label will automatically generate the 4.
-If I choose Michael from the DropDownLst then the Sequence_label will automatically generate the 2.

Can anyone help me to solve this problem??

Thanks in advance !!

asp.net

4 Contributors
17 Replies
164 Views
1 Week Discussion Span
Latest Post 16 Years Ago Latest Post by hwa

All 17 Replies

sbv 5 Junior Poster

16 Years Ago

Hi
You can do this on change event of Ur DropdownList.

Like
on DD1.selectedindex_chnged()
if DD1.selectedvalue == 1 then
{
lbl1.text = DD1.selectedValue()
}

Try this and if need more help then i am here.

Best Luck.

sbv 5 Junior Poster

16 Years Ago

hi hwa,
ok. But the meathod i told is right.
You can assign any value to label using this.
Is all values are in Db table? If yes then fetch it as per Records selected in DropDown.
As... on Selected index change.
fire a query something like...

"select Squesnce from tbl_abc where ID = " + DD1.Selectedvalue

and assign its value to label.

Now i have given right solution or still not. Still you need something different ?
If so then i am sorry. I am not clear with your requirement.

Have a good time. Bye.

SheSaidImaPregy 28 Veteran Poster

16 Years Ago

you can do it by exactly what he said. An example of this would be:

labelname.Text = dropdownlistname.SelectedItem.Value

sbv 5 Junior Poster

16 Years Ago

My problem is I want to add in a value to a LABEL based on selected value in the DropDownList !!

Example:
tbl_abc
ID Sequence Name
-----------------------------------------------
1 2 Michael
2 3 Jenny
3 4 Max
4 4 Max
5 2 Michael
6 4 Max
7 3 Jenny
8 5 Alice
-----------------------------------------------
ID-(asp:label)
Sequence-(asp:label)
Name-(asp:DropDownList)

-If I choose Max from the DropDownList then the Sequence_label will automatically generate the 4.
-If I choose Michael from the DropDownLst then the Sequence_label will automatically generate the 2.

Can anyone help me to solve this problem??
Thanks in advance !!

Hi,

Do you want to assign ID and Sequence values both to the label depending upon the selection of DropDownLst?

As you said here -
ID-(asp:label)
Sequence-(asp:label)
Name-(asp:DropDownList)

I consider yes.

As i told you in my last post. On DropDownList's selected index change event
you need to do 2 things.
1) fetch ID and Sequence from db depending upon the DropdownLst value
2) Then assign it to your labels.

srikanthkadem 0 Junior Poster in Training

16 Years Ago

hi

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

hwa 0 Newbie Poster · Answer 1 · 2008-03-12T13:50:28+00:00

Hi sbv,

If I follow the your statement then I only can get the drop down list value and add into the label but what I want is not this.

I want is like this that I mentioned above:
-If I choose Max from the DropDownList then the Sequence_label will automatically generate the 4.
-If I choose Michael from the DropDownLst then the Sequence_label will automatically generate the 2.

Thanks ya

hwa 0 Newbie Poster · Answer 2 · 2008-03-13T07:50:22+00:00

you can do it by exactly what he said. An example of this would be:
labelname.Text = dropdownlistname.SelectedItem.Value

Hi,

-May I know that this code only can retrieve the selected value in DropDown to the Label right???

-Actually is my misunderstanding or yours not clear about my requirement??

-the data inside tbl_abc is fix !!

-sorry, can yours give more clearly about that

Thanks ya

hwa 0 Newbie Poster · Answer 3 · 2008-03-13T09:07:58+00:00

Hi sbv,

Can you explain more clearly about it because I still confuse about it.

-I retrieve the tbl_abc from sqlDatabase
-I using SqlDataSource(is it needed??)
-I using <asp:Label> for the Sequence (this label will show the value based on the Selected value in the DropDown)
-I using <asp:DropDownList> for the Name (this will choose by the user)

All I do is in the <InsertItemTemplate>

Thanks for give me a hand !!

hwa 0 Newbie Poster · Answer 4 · 2008-03-13T12:43:04+00:00

Thanks all

I had solve my problem. Yours are right.
Thats all is my mistake

Thanks very very much

srikanthkadem 0 Junior Poster in Training · Answer 5 · 2008-03-14T17:18:17+00:00

srikanthkadem 0 Junior Poster in Training

16 Years Ago

:D

srikanthkadem 0 Junior Poster in Training · Answer 6 · 2008-03-14T17:18:38+00:00

srikanthkadem 0 Junior Poster in Training

16 Years Ago

::D

hwa 0 Newbie Poster · Answer 7 · 2008-03-17T14:03:45+00:00

Hi,
Do you want to assign ID and Sequence values both to the label depending upon the selection of DropDownLst?
I consider yes.
As i told you in my last post. On DropDownList's selected index change event
you need to do 2 things.
1) fetch ID and Sequence from db depending upon the DropdownLst value
2) Then assign it to your labels.

Hi sbv,

I had problem again, can you show me the code in the step 1??

Thanks

sbv 5 Junior Poster · Answer 8 · 2008-03-17T18:11:52+00:00

Hi
ok. here it is....

on selected index change of ur dd. write a query llike

SQL="select * from tble where id(pk)=" & dd.selectedvalue
rd = clsComm.GetReader(sql) 'excute query
If rd.Read = True Then
If Not IsDBNull(rd("Sequence")) Then lblSequence.Text = "R-" & rd("Sequence")
'same for other
If rd.IsClosed = False Then rd.Close()

hwa 0 Newbie Poster · Answer 9 · 2008-03-19T06:27:48+00:00

Hi
ok. here it is....

on selected index change of ur dd. write a query llike
SQL="select * from tble where id(pk)=" & dd.selectedvalue
rd = clsComm.GetReader(sql) 'excute query
If rd.Read = True Then
If Not IsDBNull(rd("Sequence")) Then lblSequence.Text = "R-" & rd("Sequence")
'same for other
If rd.IsClosed = False Then rd.Close()

Hi sbv,

this seem not like c# code, can you show in c# !!
Thanks

sbv 5 Junior Poster · Answer 10 · 2008-03-19T10:58:29+00:00

hi
ur right its a vb.net code
here is c# code.

SQL == "select * from tble where id(pk)=" + dd.selectedvalue
//excute query 
rd == clsComm.GetReader(sql)
    if (rd.Read == true)
 { 
        if (!Information.IsDBNull(rd("Sequence"))) 
            lblSequence.Text = rd("Sequence"); 
        //same for other 
    } 
    if (rd.IsClosed == false) 
        rd.Close();

sbv 5 Junior Poster · Answer 11 · 2008-03-19T10:59:51+00:00

i have used code converter here. please verify code.

if u need then here is the link of online code converter
http://labs.developerfusion.co.uk/convert/csharp-to-vb.aspx

best luck

hwa 0 Newbie Poster · Answer 12 · 2008-03-19T11:44:03+00:00

hi
ur right its a vb.net code
here is c# code.
SQL == "select * from tble where id(pk)=" + dd.selectedvalue
//excute query
rd == clsComm.GetReader(sql)
if (rd.Read == true)
{
if (!Information.IsDBNull(rd("Sequence")))
lblSequence.Text = rd("Sequence");
//same for other
}
if (rd.IsClosed == false)
rd.Close();

Hi sbv,

Actually my code is something as below:

<asp:TemplateField HeaderText="AREA_BUCKET" SortExpression="AREA_BUCKET">
                    <EditItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("AREA_BUCKET") %>'></asp:Label>
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        <asp:DropDownList ID="DropDownList_AreaBucket" runat="server" DataSourceID="AreaBucket_SqlDataSource"
                            DataTextField="AREA_BUCKET" DataValueField="AREA_BUCKET" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"
                             SelectedValue='<%# Bind("AREA_BUCKET") %>' Width="140px" AutoPostBack="true">
                        </asp:DropDownList>&nbsp;&nbsp;
                            
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("AREA_BUCKET") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>


<asp:TemplateField HeaderText="SEQUENCE" SortExpression="SEQUENCE">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("SEQUENCE") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        &nbsp;&nbsp;
                        <asp:Label ID="Sequence_label" runat="server" Text='<%# Bind("SEQUENCE") %>'></asp:Label>
                        
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("SEQUENCE") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>

My code behind is here:

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
       SQL == "select * from tble where id(pk)=" + dd.selectedvalue
      //excute query 
       rd == clsComm.GetReader(sql)
        if (rd.Read == true)
        { 
        if (!Information.IsDBNull(rd("Sequence"))) 
            lblSequence.Text = rd("Sequence"); 
        //same for other 
        } 
          if (rd.IsClosed == false) 
           rd.Close();
}

the code behind doesnt work at all
May you help

Could someone help me how to add value to A item based on other selected value??(c#)

Recommended Answers Collapse Answers

All 17 Replies

Recommended Answers