title: Concatenate two DataSet Column in dropdownlist DataTextField while Binding
body: <p>I have dropdownlist that i have to bind from back end. I am using DataSet to bind the Data but need concatenate two column data in datatextfield of Dropdownlist. </p>
  
  <p>Here is my Code. </p>
  
  <pre><code>string sqlGetClass = "select * from tbl_studentClass";
  SqlCommand cmdGetClass = new SqlCommand(sqlGetClass, conn);
  conn.Open();
  SqlDataAdapter da = new SqlDataAdapter(cmdGetClass);
  DataSet ds = new DataSet();
  da.Fill(ds);
  ddlClass.DataSource = ds;
  ddlClass.DataTextField = "brachName"+"-"+"classYear";
  ddlClass.DataValueField = "pk_classID";
  ddlClass.DataBind();
  ddlClass.Items.Insert(0, new ListItem("--SELECT--", ""));
  conn.Close();
  </code></pre>
  
  <p>if I use a single column the dropdownlist is binding fine but when concatenate them it is giving error 
  DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'brachName-classYear'.
  whene binding the Data. </p>
  
  <p>Code running fine is: </p>
  
  <pre><code>string sqlGetClass = "select * from tbl_studentClass";
  SqlCommand cmdGetClass = new SqlCommand(sqlGetClass, conn);
  conn.Open();
  SqlDataAdapter da = new SqlDataAdapter(cmdGetClass);
  DataSet ds = new DataSet();
  da.Fill(ds);
  ddlClass.DataSource = ds;
  ddlClass.DataTextField = "brachName";
  ddlClass.DataValueField = "pk_classID";
  ddlClass.DataBind();
  ddlClass.Items.Insert(0, new ListItem("--SELECT--", ""));
  conn.Close();
  </code></pre>
  
  <p>But i need to concatenate branchName and class Like M.Sc-1st Year.
  Please Help. Thanks in advance. </p>