如何从升C到SQL Server 2008中插入列表？ [英] How to insert list from C sharp into SQL Server 2008?

问题描述

我在C＃创建的列表，现在我需要插入表到SQL Server 2008的
是这可能吗？请用一个简单的例子来说明

I have created a list in c#, now I need to insert the list into SQL Server 2008. Is this possible? please explain with a simple example.

推荐答案

下面是一个简单的例子：

Here's a simple example:

List<String> list = new List<String>() { "A", "B", "C" };
using (var con = new SqlConnection(connectionString))
{
    con.Open();
    using (var cmd = new SqlCommand("INSERT INTO TABLE(Column)VALUES(@Column)", con))
    {
        cmd.Parameters.Add("@Column", SqlDbType.VarChar);
        foreach (var value in list)
        {
            cmd.Parameters["@Column"].Value = value;
            int rowsAffected = cmd.ExecuteNonQuery();
        }
    }
}

这只是遍历所有项目在列表中，并执行一个接一个插入命令与 <$ C 。$ C>的ExecuteNonQuery

This just loops through all items in the list and executes one insert-command after the other with ExecuteNonQuery.

修改：如果你想知道最有效方法插入阵列（或列表）到SQL服务器，你一定要读这： HTTP：//www.sommarskog .SE /阵列 - 在SQL-2008.html

Edit: If you want to know the most efficient ways to insert arrays(or lists) into sql-server, you should definitely read this: http://www.sommarskog.se/arrays-in-sql-2008.html

如果你以后有一个具体的问题，你可回来了，告诉你已经试过什么

If you have a specific question later, you can come back and show what you've tried.

这篇关于如何从升C到SQL Server 2008中插入列表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！