求 net 连接数据库代码

来源：百度知道 编辑：UC知道 时间：2024/05/16 17:14:52
DBhelper 这个类全部 考下来,
声明 从网上其他地方考下来的不算,要自己写的.
如下格式:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
namespace servicedal
{
public class DBhelper
{
SqlConnection con = null;
public SqlConnection conn()
{
string con= ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;
//SqlConnection conn = new SqlConnection();
//conn.ConnectionString = "server=127.0.0.1;uid=sa;pwd=12;database=li1";
return con;
}

/// <summary>
/// 更 删 插 调用此方法
/// </summary>
/// <returns></returns>
public int ExecuteSql(String sql)
{
int i = 0;

using System;
using System.Data;
using System.Data.SqlClient;

namespace JSCCRefer.SqlConn
{
/// <summary>
/// Access SQL DataBase
/// </summary>
public class DBase
{

private SqlConnection conn;

/// <summary>
/// Construct Function
/// </summary>
/// <param name="strConn">Connection CharacterString</param>
public DBase(string strConn)
{

conn = new SqlConnection(strConn);
}

/// <summary>
/// Connection DataBase
/// </summary>
/// <returns>0:Success; 1:False</returns>
private int ConnectDBase()
{
try
{

if (conn.State == ConnectionState.Closed)
{