DEVELOPERS FORUM - I am using Aras PLM software. I want to get DropDown Values from Database table using Aras PLM software.

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

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 work why?how can i solve the problem?