aspx databinding dropdownlist having issues retrieve real strings System.Data.DataRowView
<p>Here is the behind code i'm using.  The DropDownList gets populated but with "System.Data.DataRowView".  I'm looking for a simple way to fix this, hopefully it isn't much.</p>

<pre><code>public static DropDownList ProjectsDropDownList(DropDownList ProjectsDropDown)//
    {
        DataTable dtTable = new DataTable();
        dtTable = SQLProcessor.QueryDataTable("sqlquery");
        DataView dv = new DataView(dtTable);
        ProjectsDropDown.DataSource = dv;
        ProjectsDropDown.DataBind();
        return ProjectsDropDown;
    }
</code></pre>

<p>here my update:</p>

<pre><code>        DataTable dtTable = new DataTable();
        dtTable.Columns.Add(new DataColumn("ProjectName", typeof(String)));
        dtTable = SQLProcessor.QueryDataTable("query", dtTable);
        ProjectsDropDown.DataSource = dtTable;
        ProjectsDropDown.DataTextField = "ProjectName";
        ProjectsDropDown.DataValueField = "Project";
        ProjectsDropDown.DataBind();
        return ProjectsDropDown;
</code></pre>

<p>Now the results are just whitespace for the row results.</p>

<p>Here is my DataTable population...</p>

<pre><code> public static DataTable QueryDataTable(string sqlquery,DataTable dtTable)
    {
        SqlCommand sqlCMD = new SqlCommand(sqlquery, MasterSqlConnection);
        sqlCMD.CommandTimeout = 24000;
        SqlDataAdapter sqlDataAdp = new SqlDataAdapter(sqlCMD);
        sqlDataAdp.Fill(dtTable);
        return dtTable;

    }
</code></pre>

<p>the query is <code>select distinct fruit from tblFruits</code>
this results in about 36 rows 1 column.</p>

<p>This resolved the issue:</p>

<pre><code>dtTable.Columns.Add(new DataColumn("Project", typeof(String)));
        ProjectsDropDown.DataTextField = "Project";
        ProjectsDropDown.DataValueField = "Project";
</code></pre>
