Question

C#中DataSet怎么绑定2个值到combobox?

//编写SQL
StringBuilder sb = new StringBuilder();
sb.AppendLine("select RoomId,BedNum,RoomStateName,TypeName,Description");
sb.AppendLine("from Room,RoomState,RoomType");
sb.AppendLine("where Room.RoomStateId=RoomState.RoomStateId");
sb.AppendLine("and Room.RoomTypeId=RoomType.TypeId");
//执行SQL
using (SqlConnection con = new SqlConnection(conString))//连接对象
{
using (SqlDataAdapter adp = new SqlDataAdapter(sb.toString(), con))//操作对象
{
adp.Fill(ds);//数据填充
DataSet ds= new DataSet();//存放数据的容器
this.cmbRoom.DataSource = ds.ables[0];
this.cmbRoom.DisplayMember="Description" +"BedNum"; //问题就在这里。
this.cmbRoom.ValueMember ="RoomId";
}
}
有什么办法同事绑定2个值到控件呢？我还想在绑定的值中间加符号

Answer 1

//编写SQL
            StringBuilder sb = new StringBuilder();
            sb.AppendLine("select RoomId,BedNum,RoomStateName,TypeName,Description");
            sb.AppendLine("from Room,RoomState,RoomType");
            sb.AppendLine("where Room.RoomStateId=RoomState.RoomStateId");
            sb.AppendLine("and Room.RoomTypeId=RoomType.TypeId"); 
            //执行SQL
            using (SqlConnection con = new SqlConnection(conString))//连接对象
            {
                using (SqlDataAdapter adp = new SqlDataAdapter(sb.toString(), con))//操作对象
                {
                    DataSet ds= new DataSet();//存放数据的容器 
                    adp.Fill(ds);//数据填充
                    for(int i = 0;i< ds.ables[0].Rows.Count;i++)
                    {
                      this.cmbRoom.Items.Add(ds.ables[0].Rows[i]["Description"].ToString());
                      this.cmbRoom.Items.Add(ds.ables[0].Rows[i]["BedNum"].ToString());
                    }              
                }
         }

追问

你这样的代码不能达到我的想法啊。我的意思是直接加在同一行

追答

this.cmbRoom.Items.Add(ds.ables[0].Rows[i]["Description"].ToString()+ds.ables[0].Rows[i]["BedNum"].ToString());

追问

this.cmbRoom.DataSource = RoomDs.Tables[0];
this.cmbRoom.DisplayMember = "Description" + "RoomId";//这种方法怎么办呢？
this.cmbRoom.DisplayMember = ""; //显示到控件的值

追答

你非得这麼做吗？ 要是的话给你个思路吧，就是从sql语句下手吧