一.这个为c#连接winform
注意点：（1）调用时必须引用此类的命名空间
（2）类中引用的命名空间
using System;
using System.Data;
using System.Data.SqlClient;
（3）调用示例：
DataSet ds =new DataSet();
string sql="select * from [user]";
ds=DoDataBase.GetDataSet(sql);
dataGrid1.DataSource=ds.Tables[0].DefaultView;
//以上四行为用02wangluo数据库中user表来填充DataSet后绑定到dataGrid1
//这是调用的GetDataSet方法-->此方法主要面对的是查(select)
string sql="insert into test(test_xingming) values ("+txtUserID.Text+")";
DoDataBase.ExecuteSQL(sql);
//以上两行是调用DoDataBase数据库操作类中的ExecuteSQL方法来执行对数据库的增，删，改等操作，一般写到button_click中
（3）具体操作类代码：
public class DoDataBase
{
public DoDataBase()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static DataSet GetDataSet(string sql)
{
SqlConnection conn=new SqlConnection();
DataSet ds=new DataSet();
try
{
conn=new SqlConnection("server=localhost;uid=sa;pwd=;database=02wangluo");
SqlDataAdapter sda=new SqlDataAdapter(sql,conn);
sda.Fill(ds);
return ds;
}
catch(Exception ex)
{
throw(ex);
}
finally
{
conn.Close();
}
}
public static int ExecuteSQL(string sql)
{
SqlConnection conn=new SqlConnection();
try
{
conn=new SqlConnection("server=localhost;uid=sa;pwd=;database=02wangluo");
SqlCommand sqlCmd =new SqlCommand(sql,conn);
conn.Open();
return sqlCmd.ExecuteNonQuery();
}
catch(Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
}
二asp.net中c#操作SQL SERVER 2000数据库的操作类
（1）类中命名空间：
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using System.Configuration;
（2）在web.config中的
1<configuration>下面一行加入数据库连接字符串
2<appsettings>
3<add key="sqlConn" value="data source=(local); initial catalog=02wangluo;user id=sa; password="></add>
4</appsettings>
5（2）操作类代码：
6public class DoDataBase
7{
8public static SqlConnection sqlConn = new SqlConnection();
9public DoDataBase()
10{
11
12}
13public static DataSet GetDataSet(string sql)
14{
15DataSet ds = new DataSet();
16
17try
18{
19sqlConn = new SqlConnection(ConfigurationSettings.AppSettings["sqlConn"]);
20SqlDataAdapter sqlApt = new SqlDataAdapter(sql, sqlConn);
21sqlApt.Fill(ds);
22return ds;
23}
24catch (Exception ex)
25{
26throw (ex);
27}
28}
29
30public static int ExecuteSQL(string sql)
31{
32try
33{
34sqlConn = new SqlConnection(ConfigurationSettings.AppSettings["sqlConn"]);
35SqlCommand sqlCmd =new SqlCommand(sql,sqlConn);
36sqlConn.Open();
37return sqlCmd.ExecuteNonQuery();
38}
39catch (Exception ex)
40{
41throw (ex);
42}
43finally
44{
45sqlConn.Close();
46}
47}
48}
49(4)调用示例：略</configuration>