如何从通用列表中将数据插入数据库表 [英] How to insert data to a database table from a generic list

问题描述

我在人中有300个数据的通用列表，

如何将列表加载到表中（INSERT INTO People（codPersona，tipoPersona，nombre，apPaterno，apMaterno） ，nombreCompleto）值（））
我的数据库DBrarg在SQL服务器或ACCESS中的
。

帮助我!!

 private void button1_Click（object sender，EventArgs e）
 {
 int codSchool = 7; 
列表< AlumnosModel> people = new List< AlumnosModel>（）; 
 
 HttpWebRequest request =（HttpWebRequest）WebRequest.Create（@http://rarg.org/Services/students.svc/People/+ codSchool）; 
 using（HttpWebResponse response =（HttpWebResponse）request.GetResponse（））
 using（Stream stream = response.GetResponseStream（））
 using（StreamReader reader = new StreamReader（stream））
 {
 var json = reader.ReadToEnd（）; 
 people = JsonConvert.DeserializeObject< List< AlumnosModel>>（json）; 
} 
 dataGridView1.DataSource = people; 
} 

我的尝试：

 private void button1_Click（object sender，EventArgs e）
 {
 int codSchool = 7; 
列表< AlumnosModel> people = new List< AlumnosModel>（）; 
 
 HttpWebRequest request =（HttpWebRequest）WebRequest.Create（@http://rarg.org/Services/students.svc/People/+ codSchool）; 
 using（HttpWebResponse response =（HttpWebResponse）request.GetResponse（））
 using（Stream stream = response.GetResponseStream（））
 using（StreamReader reader = new StreamReader（stream））
 {
 var json = reader.ReadToEnd（）; 
 people = JsonConvert.DeserializeObject< List< AlumnosModel>>（json）; 
} 
 dataGridView1.DataSource = people; 
} 

解决方案

好吧，一种方法是将List转换为DataTable：将列表转换为DataTable [ ^ ]然后使用 SqlBulkCopy类（System.Data.SqlClient） [ ^ ]以插入数据

I have a generic list in "people" with 300 data,
How can I load the list into a table (INSERT INTO People (codPersona,tipoPersona,nombre,apPaterno,apMaterno,nombreCompleto) values (" "))
of my database "DBrarg" in SQL server or in ACCESS.
Help me!!

private void button1_Click(object sender, EventArgs e)
        {
            int codSchool = 7;
            List<AlumnosModel> people = new List<AlumnosModel>();

            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(@"http://rarg.org/Services/students.svc/People/"+codSchool);
            using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
            using (Stream stream = response.GetResponseStream())
            using (StreamReader reader = new StreamReader(stream))
            {
                var json = reader.ReadToEnd();
                people = JsonConvert.DeserializeObject<List<AlumnosModel>>(json);
            }
            dataGridView1.DataSource = people;
        }

What I have tried:

private void button1_Click(object sender, EventArgs e)
        {
            int codSchool = 7;
            List<AlumnosModel> people = new List<AlumnosModel>();

            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(@"http://rarg.org/Services/students.svc/People/"+codSchool);
            using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
            using (Stream stream = response.GetResponseStream())
            using (StreamReader reader = new StreamReader(stream))
            {
                var json = reader.ReadToEnd();
                people = JsonConvert.DeserializeObject<List<AlumnosModel>>(json);
            }
            dataGridView1.DataSource = people;
        }

解决方案

Well, one way is to convert your List to a DataTable: Converting a List to a DataTable[^] and then use the SqlBulkCopy Class (System.Data.SqlClient)[^] to insert the data.

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