类的全部代码如下
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
namespace SeaMIS
{
/// <summary>
/// 数据库连接类
/// </summary>
class Conn
{
private SqlConnection myConn;
/// <summary>
/// 服务器连接字任串
/// </summary>
private string ServerStr;
/// <summary>
/// 服务器地址
/// </summary>
static string server;
/// <summary>
/// 数据库登陆用户名
/// </summary>
static string uid;
/// <summary>
/// 登陆密码
/// </summary>
static string pwd;
/// <summary>
/// 数据库名
/// </summary>
static string database;
/// <summary>
/// 构造函数
/// </summary>
public Conn()
{
ServerStr = "server=" + server + ";uid=" + uid + ";password=" + pwd + ";database=" + database;
myConn = new SqlConnection(ServerStr);
}
/// <summary>
/// 打开连接
/// </summary>
public void Open()
{
myConn.Open();
}
/// <summary>
/// 测试数据库
/// </summary>
public int tOpen()
{
try
{
myConn.Open();
return 1;
}
catch
{
return 0;
}
}
/// <summary>
/// 关闭连接
/// </summary>
public void Close()
{
myConn.Close();
}
/// <summary>
/// 把自义类转化为SqlConnection类
/// </summary>
/// <returns>SqlConnection</returns>
public SqlConnection ChangeType()
{
return myConn;
}
/// <summary>
/// 设置服务器地址
/// </summary>
/// <param name="Server">服务器地址</param>
public static void setServer(string Server)
{
server=Server;
}
/// <summary>
///设置登陆用户名
/// </summary>
/// <param name="Uid">用户名</param>
public static void setUid(string Uid)
{
uid=Uid;
}
/// <summary>
/// 设置登陆密码
/// </summary>
/// <param name="Pwd">密码</param>
public static void setPwd(string Pwd)
{
pwd=Pwd;
}
/// <summary>
/// 设置数据库
/// </summary>
/// <param name="Database">数据库名</param>
public static void setDatabase(string Database)
{
database=Database;
}
}
}
以上是用C#连接SQL SERVER 2000数据库类的代码
调用很简单 下面举例说明:
//首先初始化连接字符串
Conn.setServer("127.0.0.1");
Conn.setUid("sa");
Conn.setPwd("SQL SERVER 2000超级管理员密码");
Conn.setDatabase("数据库名");
//可以对数据库进行操作,这里的例子是一个查询的
Conn myconn = new Conn();
myconn.Open();
string sel = "SQL语句";
SqlDataAdapter aCommand = new SqlDataAdapter(sel, myconn.ChangeType());
aCommand.SelectCommand.CommandType = CommandType.Text;
SqlDataReader datareader = aCommand.SelectCommand.ExecuteReader();
if (datareader.Read() == true)//查询成功
{
datareader.Close();
//操作
}
else//没查询到SQL语句要求的内容
{
//操作
}
myconn.Close();
粗体部分自己修改 如有不懂的地方请跟帖