将EXCEL中的sheet1$导入到SQL2000中,excel的文件路径是浏览得到的。 DataSet ds = new DataSet();
OleDbConnection MyOleDbConnection = new OleDbConnection();
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=\"Excel 8.0;MAXSCANROWS=1000;MINSCANROWS=1000;HDR=YES;IMEX=1\";";
strConn = strConn + "Data Source=" + path;
MyOleDbConnection.ConnectionString = strConn;
MyOleDbConnection.Open();
OleDbCommand MyOleDbCommand = new OleDbCommand("Select * from [Sheet1$]", MyOleDbConnection);
OleDbDataAdapter myData = new OleDbDataAdapter(MyOleDbCommand);
myData.Fill(ds);
.....这个函数后面怎么处理ds呢。求教下。
OleDbConnection MyOleDbConnection = new OleDbConnection();
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=\"Excel 8.0;MAXSCANROWS=1000;MINSCANROWS=1000;HDR=YES;IMEX=1\";";
strConn = strConn + "Data Source=" + path;
MyOleDbConnection.ConnectionString = strConn;
MyOleDbConnection.Open();
OleDbCommand MyOleDbCommand = new OleDbCommand("Select * from [Sheet1$]", MyOleDbConnection);
OleDbDataAdapter myData = new OleDbDataAdapter(MyOleDbCommand);
myData.Fill(ds);
.....这个函数后面怎么处理ds呢。求教下。
{
//遍历每一行,然后插入到数据库里
}
{
...
string srtnum = ds.Tables[0].Columns[i].ColumnName
sql = string.Format("insert into tongzhou_sim_org_cfg t values ('{0}','{1}',sysdate)",
dr[0].ToString().Trim(), strnum);
..
}
有没有具体的代码?主要是怎么连我的数据库??
SqlConnection con=new SqlConnection(strConn);
con.Open();
SqlCommand cmd=con.CreateCommand();
foreach(DataRow dr in ds.Tables[0].Rows)
{
//遍历每一行,然后插入到数据库里 ,举个例子
string id=dr[0].ToString();
string name=dr[1].ToString();
string sql="Insert Into Yourtable (ID,NAME) Values ('{0}','{1}')";
cmd.CommandText=string.Format(sql,id,name);
cmd.ExecuteNonQuery();
}