.net 获取获取list的值

Question

var ShangJiaoRenShu = string.Format(@"select u.Codefrom I_SalesForecast sf left join OT_User u on sf.CreatedBy=u.ObjectIDwhere sf.CreatedByParentId='{0}' and sf.CreatedTime>='{1}' and sf.CreatedTime<='{2}'", CreatedByParentId, Begin, End);SqlConnection conn1 = new SqlConnection(ConnectionString);conn1.Open();SqlCommand comm = new SqlCommand(ShangJiaoRenShu, conn1);SqlDataAdapter adapter = new SqlDataAdapter(comm);DataSet ds = new DataSet();//datatableadapter.Fill(ds);var newTabel = ds.Tables[0];//处理报错问题!List<Dictionary<string, object>> list1 = new List<Dictionary<string, object>>();foreach (DataRow dr in newTabel.Rows)//每一行信息，新建一个Dictionary<string,object>,将该行的每列信息加入到字典{Dictionary<string, object> result = new Dictionary<string, object>();foreach (DataColumn dc in newTabel.Columns){result.Add(dc.ColumnName, dr[dc].ToString());}list1.Add(result);} foreach (var item in list1){UserName2 += item.ToString();} list1里有4个值 分别是 王金龙 赵海伟 王楠 孟岩 请问我怎么把这4个值赋给UserName2