csv或純文本用C#匯入sqlite怎么撰寫代碼，求大神回復一下
uj5u.com熱心網友回復：
參考這兩個命名空間using System.Collections.Generic;
using System.Data;
安裝：AccessDatabaseEngine 這個插件
代碼如下
static void Main(string[] args)
{
string filePath = @"你放檔案的路徑";
string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1';";
System.Data.OleDb.OleDbConnection myConn = new System.Data.OleDb.OleDbConnection(strCon);
myConn.Open();
DataTable schemaTable = myConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
string tableName = schemaTable.Rows[0][2].ToString().Trim();//標簽名
string strCom = "Select * from [Sheet1$]";//查詢陳述句
System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, myConn);
//創建一個DataSet物件
DataSet myDataSet = new DataSet();
//得到自己的DataSet物件
myCommand.Fill(myDataSet);
//關閉此資料鏈接
myConn.Close();
DataTable dtTask = myDataSet.Tables[0];
List<userInfo> list = new List<userInfo>();
for (int k = 0; k < dtTask.Rows.Count; k++)
{
userInfo model = new userInfo();
model.id =Convert.ToInt32(dtTask.Rows[k]["編號"].ToString());
model.name = dtTask.Rows[k]["姓名"].ToString();
model.identity = dtTask.Rows[k]["身份證"].ToString();
list.Add(model);
}
}
public class userInfo
{
/// <summary>
/// 編號
/// </summary>
public int id { get; set; }
/// <summary>
/// 姓名
/// </summary>
public string name { get; set; }
/// <summary>
/// 身份證
/// </summary>
public string identity { get; set; }
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/171597.html
標籤：ASP.NET
下一篇：.net 雙串口同時接收資料