eInfoDesigns.dbProvider:"Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false"
This one is used with eInfoDesigns dbProvider, an add-on to .NET
Declare the MySqlConnection:C#:
using eInfoDesigns.dbProvider.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connectionstring";
oMySqlConn.Open();
VB.NET:
Imports eInfoDesigns.dbProvider.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "my connectionstring"
oMySqlConn.Open()
This one is used with eInfoDesigns dbProvider, an add-on to .NET
Declare the MySqlConnection:C#:
using eInfoDesigns.dbProvider.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connectionstring";
oMySqlConn.Open();
VB.NET:
Imports eInfoDesigns.dbProvider.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "my connectionstring"
oMySqlConn.Open()
using 指令或程序集引用?)
using 具体用在哪里?
"Trusted_Connection=false;" +
"user id=" + strYourSQLUser + ";" +
"password=" + strYourSQLPassword + ";" +
"database=" + strYourDatabaseName;
SqlConnection con = new SqlConnection(strConnectionString);
con.Open(); //打开连接SqlCommand cmd = new SqlCommand("select * from YourTable",con);
cmd.CommandType = CommandType.Text; //如果是存储过程CommandType.StoreProcedure
SqlDataAdapter objAdapter = new SqlDataAdapter();
objAdapter.SelectCommand = cmd;
DataTable tblTest = new DataTable();
objAdapter.Fill(tblTest);至此,tblTest里已经填充了资料了.
当然你可以用DataTable等其它
using System.Data.SqlClient;如果引用里没有System.Data则要添加引用System.Data
MySQLConnection conn;
string connstr = "Data Source=MySQL;Password=test;User D=test;Location=localhost";
conn = new MySQLConnection(constr);
conn.Open();编译器错误信息: CS1003: 语法错误,应输入“(”