How to combine database table field values and load to a dropdownlist?
![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][1]


  [1]: http://i.stack.imgur.com/riwCZ.png
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
My code is
 

    string[] account_number;
     string account;
    for (int j = 0; j < 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();

Thanks
How to combine database table field values and load to a dropdownlist?
===

![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][1]


  [1]: http://i.stack.imgur.com/riwCZ.png
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
My code is
 

    string[] account_number;
     string account;
    for (int j = 0; j < 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();

Thanks