向数据库中批量录入数据

来源：互联网发布：电脑垃圾清理软件编辑：程序博客网时间：2024/05/05 15:04

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;

public partial class 导入数据 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //分隔字符
        string[] zi=new string[TextBox1.Text.Length];
        for (int i = 0; i < TextBox1.Text.Length; i++)
        {
            zi[i] = TextBox1.Text.Substring(i,1);
        }
        //for (int j = 0; j < TextBox1.Text.Length; j++)
        //{
        //    Response.Write(zi[j] + "<br/>");
        //}
        string str = ConfigurationManager.ConnectionStrings["sqlcnn"].ConnectionString;
        using (SqlConnection cnn = new SqlConnection(str))
        {
            cnn.Open();
            for (int j = 0; j < TextBox1.Text.Length; j++)
            {
                SqlCommand cmd = cnn.CreateCommand();
                cmd.CommandText = "insert into simple (jiantizi) values('" + zi[j].ToString() + "')";
                cmd.ExecuteNonQuery();
            }
            Response.Write("录入成功！");
        }
    }
}