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);
}
}
}
将数据库一张表中多个field中的内容转移到field和值对应的表中
最新推荐文章于 2021-02-26 16:05:05 发布