DEVELOPERS FORUM - Retrieve value from a dropdown list

Arasuser - Thursday, February 19, 2009 4:29 AM:

Hi

I got an issue.

I have created a from . In that there is a textbox control , whose value i am going to set later with a method.

The method actually does this, it takes the value of another 3 controls say customercode(textbox),productname(dropdownlist) and a sequence number ,then add it(string concatination) and set that value in the tb control. I am using serverevent "OnBeforeAdd" to set the vlaue.

But in result i can see only the customercode (the string value) in that control, I could not get the value of the productname and the sequencenumber added to it. I am just using VB scipt Me.getProperty("propertyname","")

1. How will i get the value of selected item in the dropdown list ?

2. Is it possible to retrive the value of the sequence number before it is getting added?

Appreciate any helop on this.

thanks

Nila

mbeaulieu - Thursday, February 26, 2009 1:12 PM:

You should be able to get the value of the dropdown list using me.getProperty("propname"). This is true for any property on the item/form.  Make sure that you are using the correct property name (not label name) in your getProperty call.

As far as the sequence goes, you need to make a call to get the next sequence before your concatenation using method code similar to

arun - Thursday, July 26, 2012 7:10 AM:

I am using Aras PLM software. I want to get DropDown Values from Database table using Aras PLMsoftware.

using(System.Data.SqlClient.SqlConnection con=new SqlConnection("Data Source=BARUN-PC;Initial Catalog=InnovatorSolutions;User ID=sa;Password=15848;")

{

System.Data.SqlClient.SqlCommand cmd = new SqlCommand("select First_name from user",con);

con.Open();

 System.Data.SqlClient.SqlDataAdapter da = new SqlDataAdapter(cmd);

  System.Data.DataTable dt = new DataTable();

  da.Fill(dt);

  person.DataTextField = "first_name";

  person.DataValueField = "first_name";

  person.DataSource = dt;

  person.DataBind();

}

i am using this code in method ..but does not wrok