62,052
社区成员
发帖
与我相关
我的任务
分享
string sqlconn = "server=127.0.0.1;user id=sa;password=123;database=test;";
SqlDataAdapter ad = new SqlDataAdapter("select Name,code,NickName,Title,http from wind where 1<>1", sqlconn);//取个结构
DataTable dt = new DataTable();
SqlCommandBuilder cmb = new SqlCommandBuilder(ad);//这一句很关键,必不可少。
ad.Fill(dt);
//由于没有XLS数据,自己凑了一行数据出来,你那块这里直接写你的就成
//凑数据开始
DataTable dtSouce = new DataTable();
dtSouce.Columns.Add("Name",typeof(string));
dtSouce.Columns.Add("code", typeof(string));
dtSouce.Columns.Add("NickName", typeof(string));
dtSouce.Columns.Add("Title", typeof(string));
dtSouce.Columns.Add("http", typeof(string));
DataRow drSouce = dtSouce.NewRow();
drSouce["Name"] = "aaa";
drSouce["code"] = "123";
drSouce["NickName"] = "fff";
drSouce["Title"] = "eee";
drSouce["http"] = "ccc";
dtSouce.Rows.Add(drSouce);
//凑数据结束
//你可以用你的DataTable dtSouce = xls_to_dtab(FileUpload1.PostedFile.FileName).Tables[0];
//来代替上边的开始到结束
for (int i = 0; i < dtSouce.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr["Name"] = dtSouce.Rows[i][0].ToString();
dr["code"] = int.Parse(dtSouce.Rows[i][1].ToString());//对int进行转型~
dr["NickName"] = dtSouce.Rows[i][2].ToString();
dr["Title"] = dtSouce.Rows[i][3].ToString();
dr["http"] = dtSouce.Rows[i][4].ToString();
dt.Rows.Add(dr);
}
ad.Update(dt);
Console.WriteLine("OK");
Console.Read();
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("select top 1 * from wind where 1<>1", conn);
DataTable dt = xls_to_dtab(FileUpload1.PostedFile.FileName).Tables[0];
DataTable dtt = new DataTable();
da.Fill(dtt);
SqlCommandBuilder cmd = new SqlCommandBuilder(da);
da.Fill(dt);
for (int i = 1; i < dt.Rows.Count; i++)
{
dtt.Rows.Add(dt.Rows[i].ToString());
}
da.Update(dtt);
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace InsertData
{
class Program
{
static void Main(string[] args)
{
string sqlconn = "server=127.0.0.1;user id=sa;password=xxx;database=test;";
SqlDataAdapter ad = new SqlDataAdapter("select top 1 * from test where 1<>1", sqlconn);//取个结构
DataTable dt = new DataTable();
SqlCommandBuilder cmb = new SqlCommandBuilder(ad);//这一句很关键,必不可少。
ad.Fill(dt);
for (int i = 1; i < 10; i++)
{
DataRow dr = dt.NewRow();
dr["id"] = i;
dt.Rows.Add(dr);
}
ad.Update(dt);
Console.WriteLine("OK");
Console.Read();
}
}
}
SqlDataAdapter ad = new SqlDataAdapter("select top 1 * from users where 1<>1", sqlconn);//取个结构
DataTable dt = new DataTable();
SqlCommandBuilder cmb = new SqlCommandBuilder(ad);//这一句很关键,必不可少。
ad.Fill(dt);
int i;
for (i = 1; i < 10; i++)
{
DataRow dr = dt.NewRow();
dr["uid"] = "nid" + i.ToString();
dt.Rows.Add(dr);
}
ad.Update(dt);