导入:
//Determine the Conditions that may cause some problems in importing file data into table
string path = PortalSettings.HomeDirectoryMapPath;
string fileName = fileup_Import.FileName;
fileup_Import.SaveAs(path + fileName);
StreamReader reader = new StreamReader(path + fileName);
string strFileName = reader.ReadToEnd();
reader.Close();
//string connString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + fileName.Substring(0,fileName.Length-4) + ";Extensions=asc,csv,tab,txt;";
//string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=Text;FMT=Delimited;HDR=YES;";
//string connString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=";
//connString += path + fileName;
//connString += ";Extensions=txt;";
string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=";
strConn += path; //filePath, For example: C:\,不能加fileName
strConn += ";Extensions=asc,csv,tab,txt;";
OdbcConnection objConn = new OdbcConnection(strConn);
DataSet dsCSV = new DataSet();
string strSql = "select * from [" + fileName + "]"; //fileName, For example: 1.csv,不能加path
OdbcDataAdapter odbcCSVDataAdapter = new OdbcDataAdapter(strSql, objConn);
odbcCSVDataAdapter.Fill(dsCSV);
DataTable dt = dsCSV.Tables[0];
存储过程：
--读取库中的所有表名
select name from sysobjects where xtype='u'
--读取指定表的所有列名
select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='表名')
--读取某张表中字段的个数:
select count(name) as fieldcount from syscolumns where id=object_id(@tableName)
--导入的文件id为自增.
SELECT COLUMNPROPERTY( OBJECT_ID('表名'),'列名','IsIdentity')
--获取某张表中字段的相应类型(select a.name as fieldName,b.name as fieldtype from syscolumns a,systypes b where a.xtype=b.xtype and a.id=object_id(@tableName) and b.name !='sysname')
