{
string sqlconn = " server = 192.168 . 0 . 254;uid = sapwd =;database = metaCRM5最大池大小= 512;";
SqlConnection sqlCon = new SqlConnection(sqlconn);
sqlCon。open();
string conn = "Provider = Microsoft。Jet . OLEDB.4.0數據源= "+pPath+";擴展屬性= ' Excel 8.0HDR =假;IMEX = 1 ' ";//pPath是EXCEL的地址。
OleDbConnection oleCon =新oledb connection(conn);
奧雷康。open();
string Sql = " select * from["+filename+" $]";//filename是excel的表名。
oledb dataadapter my command = new oledb dataadapter(Sql,oleCon);
數據集ds =新數據集();
我的命令。Fill(ds,"["+filename+" $]");
奧雷康。close();
奧雷康。dispose();
我的命令。dispose();
int query count = 0;//統計導入記錄的數量。
int計數= ds。tables["["+filename+" $]"]. rows . count;
for(int I = 0;我& lt數數;i++)
{
字符串用戶名、數據時間、時隙、登錄、註銷;
int IsLater,IsLost
username = change username(ds . tables["["+filename+" $]"]。行[i] ["name" ]。ToString()。trim());
data time = ds . tables["["+filename+" $]"]。第[i]行["日期"]。ToString()。trim();
時隙= ds . tables["["+文件名+"$]"]。第[i]行["相應的時間段"]。ToString()。trim();
sign in = ds . tables["["+filename+" $]"]。第[i]行["簽到時間"]。ToString()。trim();
sign out = ds . tables["["+filename+" $]"]。第[i]行["結帳時間"]。ToString()。trim();
I slater = change is(ds . tables["["+filename+" $]"]。rows [I] ["late time" ]。ToString()。trim());
is lost = change is(ds . tables["["+filename+" $]"]。行[I] ["曠工"]。ToString()。trim());
string excelsql = " insert into check work(created by,created,Idowner,dchworkdata,stimeslot,ssignintime,ssignouttime,slate,sskipwork,sip)值(' admin ',getdate(),' "+ UserName +" ',' "+ DataTime +" ',' "+ Timeslot +" ',' "+ SignIn +" ',' "+ SignOut +" ',' "+ IsLater +" ','+ IsLost +" ',' "+ sip +" '
SqlCommand cmd = new SqlCommand(excelsql,sqlCon);
cmd。ExecuteNonQuery();
query count = I+1;
cmd。dispose();
}
回應。Write("成功導入"+querycount+"記錄");
sqlCon。close();
sqlCon。dispose();
}