阅读背景:

如何使用asp.net mvc将多个动态行值导入数据库

来源:互联网 
public void create(account_detail c, int jobcard_id)
{
    SqlConnection con = new SqlConnection(@"Data source =(LocalDB)\v11.0;AttachDbFilename=C:\Users\Wattabyte Inc\Documents\CarInfo.mdf;Integrated Security=True;");

    SqlCommand cmd = new SqlCommand();
    cmd.CommandType = CommandType.Text;
    cmd.Connection = con;

    con.Open();
    string additionalText = string.Empty;
    bool needComma = false;

    foreach (var details in c.Data)
    {
        if (needComma)
        {
            additionalText += ", ";
        }
        else
        {
            needComma = true;
            additionalText += "('" + jobcard_id + "','" + details.completed_by + "','" + details.reporting_time + "','" + details.cost_activity + "','" + details.spared_part_used + "')";
        }

        cmd.CommandText = "insert into child_detail values " + additionalText + ";";
        cmd.ExecuteNonQuery();
    }
public void create(account_detail c, int jobcar



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: