如何将Datatable值插入到多个表中 [英] How to insert Datatable value in to multiple tables

问题描述

大家好我想在2个表中插入一个ID

我的代码如下

Hi All i want to insert one ID in to 2 table
my code are as below

DataTable dt = new DataTable();
                   dt = FnTableIDInsert();
                       SqlConnection connn = new SqlConnection(ConnectionString);
                       connn.Open();
                       string sqlselect = "INSERT INTO tbl_clientcolumnnames(tableid) values('tableid')";
                       SqlCommand cmdselect = new SqlCommand(sqlselect, connn);
                       cmdselect.ExecuteNonQuery();
                       string sqlselect2 = "INSERT INTO tbl_Intellectcolumnnames(tableid) values('tableid')";
                       SqlCommand cmdselect2 = new SqlCommand(sqlselect2, connn);
                       cmdselect2.ExecuteNonQuery();

请帮助我改变我的代码，将数据插入多个表格



编辑（从回答中移出）

---

pls help me wt change i do in my code for insert data into multiple tables

EDIT (Moved from answer)

---

DataTable dt = new DataTable();
                    dt = FnTableIDInsert();
                    foreach (DataRow dr in dt.Rows)
                    {
                        string value = dr["tableid"].ToString();
                        SqlConnection connn = new SqlConnection(ConnectionString);
                        connn.Open();
                        string sqlselect = "INSERT INTO tbl_clientcolumnnames(tableid) values("+value+")";
                        SqlCommand cmdselect = new SqlCommand(sqlselect, connn);
                        cmdselect.ExecuteNonQuery();
                        string sqlselect2 = "INSERT INTO tbl_Intellectcolumnnames(tableid) values(" + value + ")";
                        SqlCommand cmdselect2 = new SqlCommand(sqlselect2, connn);
                        cmdselect2.ExecuteNonQuery();

                    }

i已经对代码进行了更改，知道每件事都很好，但是bata的格式如下： />

i Have done change in code know every thing is okey but bata come like below format

columnintellectid	tableid	ScriptId	ColumnnameInt
8	NULL	8	Name
9	5	NULL	NULL
10	NULL	9	Name
11	6	NULL	NULL

但是我想要

But i want

columnintellectid   tableid ScriptId    ColumnnameInt
8   5    8   Name     
9   6    9   Name 

请回复如果有人知道

pls reply if some know

推荐答案

谢谢大家的支持，很快就看到你的问题已经解决了，我已经解决了上面提到的解决方案

Thank you all for supproty see you soon my problem was solved it from myself already solution mentioned above

如果你想避免空值，请尝试如下

try like below if you want to avoid null values

DataTable dt = new DataTable();
                    dt = FnTableIDInsert();
                    foreach (DataRow dr in dt.Rows)
                    {
                        string value = dr["tableid"].ToString();
                       if(value!=null && value!=string.Empty )
                       {
                        SqlConnection connn = new SqlConnection(ConnectionString);
                        connn.Open();
                        string sqlselect = "INSERT INTO tbl_clientcolumnnames(tableid) values("+value+")";
                        SqlCommand cmdselect = new SqlCommand(sqlselect, connn);
                        cmdselect.ExecuteNonQuery();
                        string sqlselect2 = "INSERT INTO tbl_Intellectcolumnnames(tableid) values(" + value + ")";
                        SqlCommand cmdselect2 = new SqlCommand(sqlselect2, connn);
                        cmdselect2.ExecuteNonQuery();
 
                        }
                   }

这篇关于如何将Datatable值插入到多个表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！