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("录入成功!");
}
}
}