将数据库一张表中多个field中的内容转移到field和值对应的表中

最新推荐文章于 2025-05-28 01:23:38 发布

原创最新推荐文章于 2025-05-28 01:23:38 发布 · 177 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

本文介绍了一种通过从一个数据库表中读取员工的基本信息，并批量插入到另一个表中的方法，涉及数据集操作、数据行编辑及SQL执行过程。


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);
                }
            }
        }