using
System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Food.BLL;
using Food.Models;
using Food.DAL;
public partial class test_ImportXls : System.Web.UI.Page
{
protected void Page_Load( object sender, EventArgs e)
{
ImportData();
}
private DataSet xsldata( string filepath)
{
string strCon = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + filepath + " ;Extended Properties='Excel 8.0;IMEX=1' " ;
System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strCon);
string strCom = " SELECT * FROM [Sheet1$] " ;
Conn.Open();
System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, Conn);
DataSet ds = new DataSet();
myCommand.Fill(ds, " [Sheet1$] " );
Conn.Close();
return ds;
}
private void ImportData()
{
// 批量添加
try
{
string fileurl = @" C:\Documents and Settings\Administrator\桌面\InsideLink.xls " ;
DataSet ds = new DataSet(); // 取得数据集
ds = xsldata(fileurl);
for ( int i = 0 ; i < ds.Tables[ 0 ].Rows.Count; i ++ )
{
string typename = ds.Tables[ 0 ].Rows[i][ " 类名 " ].ToString();
if (typename.Length > 0 )
{
string linkvalue = ds.Tables[ 0 ].Rows[i][ " 链接 " ].ToString();
DBHelper.ExecuteCommand( " Insert Into replacekeyword values(' " + typename + " ',' " + linkvalue + " ','','','',1,1) " );
// dbhelper里面包含连接字符串
}
else
{
break ;
}
}
Response.Write( " OK " );
}
catch (Exception err)
{
Response.Write( " Error " );
}
}
}
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Food.BLL;
using Food.Models;
using Food.DAL;
public partial class test_ImportXls : System.Web.UI.Page
{
protected void Page_Load( object sender, EventArgs e)
{
ImportData();
}
private DataSet xsldata( string filepath)
{
string strCon = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + filepath + " ;Extended Properties='Excel 8.0;IMEX=1' " ;
System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strCon);
string strCom = " SELECT * FROM [Sheet1$] " ;
Conn.Open();
System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, Conn);
DataSet ds = new DataSet();
myCommand.Fill(ds, " [Sheet1$] " );
Conn.Close();
return ds;
}
private void ImportData()
{
// 批量添加
try
{
string fileurl = @" C:\Documents and Settings\Administrator\桌面\InsideLink.xls " ;
DataSet ds = new DataSet(); // 取得数据集
ds = xsldata(fileurl);
for ( int i = 0 ; i < ds.Tables[ 0 ].Rows.Count; i ++ )
{
string typename = ds.Tables[ 0 ].Rows[i][ " 类名 " ].ToString();
if (typename.Length > 0 )
{
string linkvalue = ds.Tables[ 0 ].Rows[i][ " 链接 " ].ToString();
DBHelper.ExecuteCommand( " Insert Into replacekeyword values(' " + typename + " ',' " + linkvalue + " ','','','',1,1) " );
// dbhelper里面包含连接字符串
}
else
{
break ;
}
}
Response.Write( " OK " );
}
catch (Exception err)
{
Response.Write( " Error " );
}
}
}