程序为:
openFileDialog1.ShowDialog();
string fileName = openFileDialog1.FileName;
List<string[]> ls = new List<String[]>();
StreamReader fileReader = new StreamReader(fileName);
string strLine = "";
while (strLine != null)
{
strLine = fileReader.ReadLine();
if (strLine != null && strLine.Length > 0)
{
ls.Add(strLine.Split('|'));
}
}请问之后如何入数据库,是否只能一个字段一个字段的ls"[i][j]"录入,还是有其他方式
openFileDialog1.ShowDialog();
string fileName = openFileDialog1.FileName;
List<string[]> ls = new List<String[]>();
StreamReader fileReader = new StreamReader(fileName);
string strLine = "";
while (strLine != null)
{
strLine = fileReader.ReadLine();
if (strLine != null && strLine.Length > 0)
{
ls.Add(strLine.Split('|'));
}
}请问之后如何入数据库,是否只能一个字段一个字段的ls"[i][j]"录入,还是有其他方式
public static DataSet CsvReader(string sql, string cvsFilePath)
{
OleDbConnection OleCon = new OleDbConnection();
OleDbCommand OleCmd = new OleDbCommand();
OleDbDataAdapter OleDa = new OleDbDataAdapter();
DataSet CsvData = new DataSet();
OleCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties='Text;FMT=Delimited;HDR=YES;'";
OleCon.Open();
OleCmd.Connection = OleCon;
OleCmd.CommandText = sql;
OleDa.SelectCommand = OleCmd;
try
{
OleDa.Fill(CsvData, "Csv");
return CsvData;
}
catch
{
return CsvData;
}
finally
{
OleCon.Close();
OleCmd.Dispose();
OleDa.Dispose();
OleCon.Dispose();
}
}