//Excel导入数据库 private DataSet CreateDataSource() { string strCon; strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("/net_admin/exportcj/excel.xls") + "; Extended Properties=Excel 8.0;"; OleDbConnection olecon =
//excel导入数据库
private dataset createdatasource()
{
string strcon;
strcon = "provider=microsoft.jet.oledb.4.0;data source=" + server.mappath("/net_admin/exportcj/excel.xls") + "; extended properties=excel 8.0;";
oledbconnection olecon = new oledbconnection(strcon);
oledbdataadapter myda = new oledbdataadapter("select * from [sheet1$]", strcon);
dataset myds = new dataset();
myda.fill(myds);
return myds;
}
///
/// 字符串过滤
///
/// 传来参数
///
public string FilterStr(string strvalue)
{
string strfilter = ";|%|*|and|exec|insert|select|delete|update|count|chr|mid|master|truncate|char|declare|script";
string[] strfil = strfilter.Split('|');
foreach ( string str in strfil)
{
strvalue = strvalue.Replace(str,"");
}
return strvalue;
}
