}
}
-------------------------------------------------------------------------------
4.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();
--------------------------------------------------------------------------------
5.C#连接 IBM DB2
程序代码:
--------------------------------------------------------------------------------
OleDbConnection1.Open();
//
打开数据库连接
OleDbDataAdapter1.Fill(dataSet1,"Address");
//将得来的数据填入 dataSet
DataGrid1.DataBind();
//
绑定数据
OleDbConnection1.Close();
//
关闭连接
//
增加数据库数据
在 Web Form 上新增对应字段数量个数的 TextBox,及一个 button,为该按键增加 Click 响应事件代码
如下: