資源簡介
常用數據庫 SQL Server、Oracle、Access、SQLite 的連接測試及數據表顯示工具。
適合初學ADO.NET的同學學習conn、com、da、ds、DataGridView等的基本應用。
環境:vs2012 .net3.5 sqlite3
注意:Access若連接失敗應要下載AccessDatabaseEngine安裝
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Data.SqlClient;
using?System.Data.OracleClient;
using?System.Data.OleDb;
using?System.Data.SQLite;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;?
namespace?Adolinker
{
????public?partial?class?FormMain?:?Form
????{
????????public?FormMain()
????????{
????????????InitializeComponent();
????????}
????????private?void?BtnSqlConn_Click(object?sender?EventArgs?e)
????????{
????????????dataGridView.DataSource?=?null;
????????????string?dbSqlServer?=?txtSqlServer.Text.Trim();
????????????string?dbSqlName?=?txtSqlDbName.Text.Trim();
????????????string?dbSqlUser?=?txtSqlDbUser.Text.Trim();
????????????string?dbSqlPwd?
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-01-08?12:09??Adoli
?????文件????????3971??2020-01-08?08:49??Adoli
?????文件???????16958??2020-01-08?02:12??Adoli
?????文件???????42800??2020-01-08?12:09??Adoli
?????文件???????12776??2020-01-08?12:09??Adoli
?????文件???????31555??2020-01-08?12:09??Adoli
?????文件?????????493??2020-01-07?20:00??Adoli
?????目錄???????????0??2020-01-07?16:19??Adoli
?????文件????????1310??2020-01-07?16:19??Adoli
?????文件????????2831??2020-01-07?16:19??Adoli
?????文件????????5612??2020-01-07?16:19??Adoli
?????文件????????1096??2020-01-07?16:19??Adoli
?????文件?????????249??2020-01-07?16:19??Adoli
?????目錄???????????0??2020-01-07?20:00??Adoli
?????目錄???????????0??2020-01-08?12:09??Adoli
?????文件???????60928??2020-01-08?12:09??Adoli
?????文件???????44544??2020-01-08?12:09??Adoli
?????文件??????904704??2010-04-18?13:58??Adoli
?????文件??????184765??2010-04-18?13:34??Adoli
?????目錄???????????0??2020-01-08?12:09??Adoli
?????目錄???????????0??2020-01-07?16:19??Adoli
?????目錄???????????0??2020-01-08?12:09??Adoli
?????文件???????????0??2020-01-08?12:09??Adoli
?????文件?????????850??2020-01-08?12:09??Adoli
?????文件????????6502??2020-01-08?12:09??Adoli
?????文件???????17524??2020-01-08?12:09??Adoli
?????文件?????????180??2020-01-08?12:09??Adoli
?????文件?????????909??2020-01-08?12:09??Adoli
?????文件???????60928??2020-01-08?12:09??Adoli
?????文件???????44544??2020-01-08?12:09??Adoli
?????文件?????????855??2020-01-08?08:26??Adoli
............此處省略3個文件信息
評論
共有 條評論