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

[hwa]

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

[sbv]

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.

[hwa]

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

[sbv]

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]

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

labelname.Text = dropdownlistname.SelectedItem.Value

[hwa]

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]

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

[sbv]

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.

[hwa]

Thanks all

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

Thanks very very much

[srikanthkadem]

hi

[srikanthkadem]

:D

[srikanthkadem]

::D

[hwa]

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]

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]

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]

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]

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]

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