将数据库一张表中多个field中的内容转移到field和值对应的表中
Data_basic recordData = new Data_basic(); Data_basic recordData2 = new Data_basic(); recordData.ExecuteDataset(string.Format("select staffID,unitLeader,drawing,teaching,computer from igos_Staff")); DataTable dt = new DataTable(); DataRow rowEdited = dt.NewRow(); if (recordData.AffectedRow > 0) { for (int y = 0; y < recordData.Dataset.Tables.Count; y++) { dt = recordData.Dataset.Tables[y]; for (int x = 0; x < recordData.Dataset.Tables[y].Rows.Count; x++) { rowEdited = dt.Rows[x]; string s = (String.Format(@"insert into igos_StaffType (staffID, items, itemValue) values ( '{0}','{1}','{2}')", rowEdited["staffID"], "unitLeader", rowEdited["unitLeader"])); s += (String.Format(@"insert into igos_StaffType (staffID, items, itemValue) values ( '{0}','{1}','{2}')", rowEdited["staffID"], "drawing", rowEdited["drawing"])); s += (String.Format(@"insert into igos_StaffType (staffID, items, itemValue) values ( '{0}','{1}','{2}')", rowEdited["staffID"], "teaching", rowEdited["teaching"])); s += (String.Format(@"insert into igos_StaffType (staffID, items, itemValue) values ( '{0}','{1}','{2}')", rowEdited["staffID"], "computer", rowEdited["computer"])); recordData2.ExcuteNonQuery(s); } } }