古詩詞大全網 - 成語經典 - c#怎麽使用oledbconnection

c#怎麽使用oledbconnection

關於使用ADO.NET創建並寫入Excel文件與普通數據庫操作極為類似,參見以下代碼:

String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +

"Data Source=c:/test.xls;" +

"Extended Properties=Excel 8.0;";

OleDbConnection cn = new OleDbConnection(sConnectionString);

string sqlCreate = "CREATE TABLE TestSheet ([ID] INTEGER,[Username] VarChar,[UserPwd] VarChar)";

OleDbCommand cmd = new OleDbCommand(sqlCreate, cn);

//創建Excel文件:C:/test.xls

cn.Open();

//創建TestSheet工作表

cmd.ExecuteNonQuery();

//添加數據

cmd.CommandText = "INSERT INTO TestSheet VALUES(1,'elmer','password')";

cmd.ExecuteNonQuery();

//關閉連接

cn.Close();