bind two column into a dropdown
<p>I want to bind two column from database into dropdownlist. Here's my code:</p>

<pre><code>SqlConnection con=new SqlConnection(CommonRefference.Constr());
string query = "Select Id,Name+' ('+Distribution_name+') 'as Name1 from BR_supervisor  ";

SqlCommand cmd = new SqlCommand(query,con);
con.Open();

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())
{
        DropDownList3.DataSource = query;
        DropDownList3.DataTextField = "name1";
        DropDownList3.DataValueField = "Id";
        DropDownList3.DataBind();
}
con.Close();
</code></pre>

<p>But it gives the following error</p>

<blockquote>
  <p><em>DataBinding: 'System.Char' does not contain a property with the name 'name1'</em></p>
</blockquote>

<p>How to do it? Anyone helps me is highly appreciated</p>
