dbserver

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace 线程
{
class DBserver
{
private SqlConnection sc = new SqlConnection();

public DBserver()
{

sc.ConnectionString = "server=.;database=test;uid =sa;pwd=123456; ";//Trusted_Connection=true;
}

public void Open()
{
sc.Open();

}

public void Close()
{
sc.Close();
}

public DataSet DoSearch(string sql)
{
DataSet ds = new DataSet();
try
{
SqlDataAdapter sda = new SqlDataAdapter(sql, sc);
sda.Fill(ds);
Close();
}
catch (Exception e)
{
throw e;
}
finally
{
Close();
}
return ds;
}

public int Updata(string sql)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = sc;
cmd.CommandText = sql;
Open();
int i = cmd.ExecuteNonQuery();
return i;
}
catch (Exception e)
{
throw e;
}
finally
{
Close();
}
}

}
}