将多行从数据表插入数据库 [英] Inserting multiple row from datatable to database

问题描述

嗨

我必须将网格文本框值从数据表插入数据库.
但是我的代码对单行有效，对多行无效.
你能说对吗

Hi

I have to insert grid textbox value from datatable to database.
But my code is working for single row for multi row it is not working.
Could you pls correct

const string insertsql = "INSERT INTO Items(Description,ItemNo,Qty)VALUES (";
        sb.AppendFormat("{0}", insertsql);
        foreach (string item in sc)
        {
            if (item.Contains(","))
            {
                splitItems = item.Split(",".ToCharArray());
                sb.AppendFormat("''{0}'',''{1}'',''{2}'');", splitItems[0], splitItems[1], splitItems[2]);


            }
        }

在字符串生成器中，我得到以下值是示例

In string builder i am getting the values below is example

INSERT INTO Items(Description,ItemNo,Qty)VALUES (''1'',''DHDHJDHJ'',''1'');''2'',''BHHHH'',''2'');"

这是我的错误msg "2"附近的语法不正确.

谢谢

This is my error msg Incorrect syntax near ''2''.

Thanks

推荐答案

以这种方式进行操作将使您获得正确的查询.

Doing it this way would get you proper query.

foreach (string item in sc)
{
    string insertsql = "INSERT INTO Items(Description,ItemNo,Qty)VALUES (";
    sb.AppendFormat("{0}", insertsql);
    if (item.Contains(","))
    {
        splitItems = item.Split(",".ToCharArray());
        sb.AppendFormat("'{0}','{1}','{2}');", splitItems[0], splitItems[1], splitItems[2]);


    }
}

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