Question

想用VB做个酒店管理系统,怎么跟数据库连接啊？？

Answer 1

1.C#连接Access

程序代码：

using System.Data;

using System.Data.OleDb;

..
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";

strConnection+=@"Data Source=C:BegASPNETNorthwind.mdb";
OleDbConnection objConnection=new OleDbConnection(strConnection);

..
objConnection.Open();

objConnection.Close();
2.C#连接SQL Server

程序代码：

using System.Data;

using System.Data.SqlClient;

..
string strConnection="user id=sa;password=;";

strConnection+="initial catalog=Northwind;Server=YourSQLServer;";

strConnection+="Connect Timeout=30";
SqlConnection objConnection=new SqlConnection(strConnection);

..
objConnection.Open();

objConnection.Close();
3.C#连接MySQL

程序代码：

using MySQLDriverCS;
// 建立数据库连接

MySQLConnection DBConn;

DBConn = new MySQLConnection(new MySQLConnectionString
("localhost","mysql","root","",3306).AsString);

DBConn.Open();
// 执行查询语句

MySQLCommand DBComm;

DBComm = new MySQLCommand("select Host,User from user",DBConn);
// 读取数据

MySQLDataReader DBReader = DBComm.ExecuteReaderEx();
// 显示数据

try

{

while (DBReader.Read())

{

Console.WriteLine("Host = {0} and User = {1}",
DBReader.GetString(0),DBReader.GetString(1));

}

}

finally

{

DBReader.Close();

DBConn.Close();

}
//关闭数据库连接

DBConn.Close();

Answer 2

楼上的真是热心。。。

Answer 3

哦,我是 C#写的VB 也差不多的,就改一点点...