I have a problem populating a dropdownlist with data from a dataset. Here is the code:
I am not really sure what the problem is, the dropdownbox is populated with "System.Data.DataRowView"...!?!PHP Code:string strConnection="user id=logger;password=logger;";
strConnection+="database=MVS;server=4647117000N26";
SqlConnection objSqlConnection = new SqlConnection(strConnection);
objSqlConnection.Open();
DataSet objDataSet = new DataSet();
string strOrderDetails = "SELECT DISTINCT [job_name] FROM [mvs_jobs]";
SqlCommand objOrdDetailCommand = new SqlCommand(strOrderDetails,objSqlConnection);
SqlDataAdapter objODAdapter = new SqlDataAdapter(objOrdDetailCommand);
objODAdapter.Fill(objDataSet);
DropDownList1.DataSource = objDataSet;
DropDownList1.DataBind();
objSqlConnection.Close();
anyone who can help?
kind regards
Henrik




Reply With Quote