How to combine database table field values and load to a dropdownlist?
<p><img src="http://i.stack.imgur.com/riwCZ.png" alt="This is my database table. Now I want to combine Branch_Id, Acc_no and Acc_Type like 000178963503 and 000211111102 and display it in a dropdownlist"></p>

<p>This is my database table. Now I want to combine Branch_Id, Acc_no and Acc_Type so that it looks like 000178963503 or 000211111102 and display it in a dropdownlist
My code is</p>

<pre><code>string[] account_number;
 string account;
for (int j = 0; j &lt; dtAcc.Rows.Count;j++)
                    {
                        account = Convert.ToString(dtAcc.Rows[j][2])+Convert.ToString(dtAcc.Rows[j][5]) + Convert.ToString(dtAcc.Rows[j][3]);   ///Account Number
                        account_number =account.Split(' ');                                              
                    }
Drp_AccType.DataSource = account_number;
                    Drp_AccType.DataBind();
</code></pre>

<p>Thanks</p>
