我有一个c#编的asp.net定义类的文件,但是它只能和access数据库连用,有高手可以帮我改成跟sql连的吗? 文件在里面! 写明白一点可以吗?谢谢

[wsonline]

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Text.RegularExpressions;
using System.Data.OleDb;
namespace DBConnect
{
/// <summary>
/// DBConnect 的摘要说明。
/// </summary>
public class DBConnection
{
private OleDbConnection objConnection;

public DBConnection()
{
//
// TODO: 在此处添加构造函数逻辑
//
objConnection=new OleDbConnection(ConfigurationSettings.AppSettings["netlx"]);
//objConnection=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("exexchange.mdb"));

//Access :Provider=Microsoft.Jet.OLEDB.4.0; Data Source=test
//Oracle: Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=huoche;Password=huoche;Data Source=huoche
}


public void Open()
{

}



public void ExecNonQuery(string strSQL) //执行不返回结果
{
objConnection.Open();
OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection);
objCommand.ExecuteNonQuery();
objConnection.Close();
}

public DataSet CreateDataSet(string strSQL, string strTableName) //返回结果 select
{
objConnection.Open();
OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSQL,objConnection);
DataSet ds = new DataSet();
MyAdapter.Fill(ds,strTableName);
objConnection.Close();

return ds;
}



public int Lenx(string str) //变量长度
{
int theLen = 0;
char[] str2=str.ToCharArray();
foreach (char b in str2)
{
if ((short)b<0||(short)b>255)
{
theLen=theLen+2;
}
else
{
theLen=theLen+1;
}
}
return(theLen);
}

public string CheckInvalidChar(string strInput) //替换'
{
string strTemp = strInput;

strTemp = strTemp.Replace("'","''");
//strTemp = Server.HtmlEncode(strTemp);

return strTemp;
}

public string EncryptPasswd(string str)//用于mD5加密
{
string passwd2;
passwd2 = FormsAuthentication.HashPasswordForStoringInConfigFile(str,"MD5");
return passwd2;

}
public bool isint(string num) //是否为整数
{
Regex reg=new Regex("^[0-9]*$");
return reg.IsMatch(num);
}
public bool isnum(string num) //是否为小数
{
Regex reg=new Regex("^([0-9]*).([0-9]*)$");
return reg.IsMatch(num);
}
public bool isdate(string num) //是否为合法日期
{
Regex reg=new Regex(@"^(?:(?:1[6-9]|[2-9]\d)?\d{2}[\/\-\.](?:0?[1,3-9]|1[0-2])[\/\-\.](?:29|30))(?: (?:0?\d|1\d|2[0-3])\:(?:0?\d|[1-5]\d)\:(?:0?\d|[1-5]\d)(?: \d{1,3})?)?$|^(?:(?:1[6-9]|[2-9]\d)?\d{2}[\/\-\.](?:0?[1,3,5,7,8]|1[02])[\/\-\.]31)(?: (?:0?\d|1\d|2[0-3])\:(?:0?\d|[1-5]\d)\:(?:0?\d|[1-5]\d)(?: \d{1,3})?)?$|^(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])[\/\-\.]0?2[\/\-\.]29)(?: (?:0?\d|1\d|2[0-3])\:(?:0?\d|[1-5]\d)\:(?:0?\d|[1-5]\d)(?: \d{1,3})?)?$|^(?:(?:16|[2468][048]|[3579][26])00[\/\-\.]0?2[\/\-\.]29)(?: (?:0?\d|1\d|2[0-3])\:(?:0?\d|[1-5]\d)\:(?:0?\d|[1-5]\d)(?: \d{1,3})?)?$|^(?:(?:1[6-9]|[2-9]\d)?\d{2}[\/\-\.](?:0?[1-9]|1[0-2])[\/\-\.](?:0?[1-9]|1\d|2[0-8]))(?: (?:0?\d|1\d|2[0-3])\:(?:0?\d|[1-5]\d)\:(?:0?\d|[1-5]\d)(?: \d{1,3})?)?$");
return reg.IsMatch(num);
}
public string filestype(string files1) //带点的文件扩展名
{
return files1.Substring(files1.LastIndexOf('.'),files1.Length-files1.LastIndexOf('.'));
}
}
}

[lovefootball]

OleDb
----
sql

然后引入命名空间就可以了

[greennetboy]

using System.Data.OleDb;
using System.Data.SqlClient;
//objConnection=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("exexchange.mdb"));
//sqlConnection=new SqlConnection("Server=127.0.0.1;uid=sa;pwd=123;DataBase=NorthWind");

[shibettle]

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Text.RegularExpressions;
using System.Data.SqlClient;
namespace DBConnect
{
/// <summary>
/// DBConnect 的摘要说明。
/// </summary>
public class DBConnection
{
private SqlConnection objConnection;

public DBConnection()
{
//
// TODO: 在此处添加构造函数逻辑
//
objConnection=new SqlConnection("server=localhost;uid=huoche;pwd=huoche;database=(sql数据库名)");
//objConnection=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("exexchange.mdb"));

//Access :Provider=Microsoft.Jet.OLEDB.4.0; Data Source=test
//Oracle: Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=huoche;Password=huoche;Data Source=huoche
}


public void Open()
{

}



public void ExecNonQuery(string strSQL) //执行不返回结果
{
objConnection.Open();
SqlCommand objCommand = new SqlCommand(strSQL, objConnection);
objCommand.ExecuteNonQuery();
objConnection.Close();
}

public DataSet CreateDataSet(string strSQL, string strTableName) //返回结果 select
{
objConnection.Open();
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSQL,objConnection);
DataSet ds = new DataSet();
MyAdapter.Fill(ds,strTableName);
objConnection.Close();

return ds;
}



public int Lenx(string str) //变量长度
{
int theLen = 0;
char[] str2=str.ToCharArray();
foreach (char b in str2)
{
if ((short)b<0||(short)b>255)
{
theLen=theLen+2;
}
else
{
theLen=theLen+1;
}
}
return(theLen);
}

public string CheckInvalidChar(string strInput) //替换'
{
string strTemp = strInput;

strTemp = strTemp.Replace("'","''");
//strTemp = Server.HtmlEncode(strTemp);

return strTemp;
}

public string EncryptPasswd(string str)//用于mD5加密
{
string passwd2;
passwd2 = FormsAuthentication.HashPasswordForStoringInConfigFile(str,"MD5");
return passwd2;

}
public bool isint(string num) //是否为整数
{
Regex reg=new Regex("^[0-9]*$");
return reg.IsMatch(num);
}
public bool isnum(string num) //是否为小数
{
Regex reg=new Regex("^([0-9]*).([0-9]*)$");
return reg.IsMatch(num);
}
public bool isdate(string num) //是否为合法日期
{
Regex reg=new Regex(@"^(?:(?:1[6-9]|[2-9]\d)?\d{2}[\/\-\.](?:0?[1,3-9]|1[0-2])[\/\-\.](?:29|30))(?: (?:0?\d|1\d|2[0-3])\:(?:0?\d|[1-5]\d)\:(?:0?\d|[1-5]\d)(?: \d{1,3})?)?$|^(?:(?:1[6-9]|[2-9]\d)?\d{2}[\/\-\.](?:0?[1,3,5,7,8]|1[02])[\/\-\.]31)(?: (?:0?\d|1\d|2[0-3])\:(?:0?\d|[1-5]\d)\:(?:0?\d|[1-5]\d)(?: \d{1,3})?)?$|^(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])[\/\-\.]0?2[\/\-\.]29)(?: (?:0?\d|1\d|2[0-3])\:(?:0?\d|[1-5]\d)\:(?:0?\d|[1-5]\d)(?: \d{1,3})?)?$|^(?:(?:16|[2468][048]|[3579][26])00[\/\-\.]0?2[\/\-\.]29)(?: (?:0?\d|1\d|2[0-3])\:(?:0?\d|[1-5]\d)\:(?:0?\d|[1-5]\d)(?: \d{1,3})?)?$|^(?:(?:1[6-9]|[2-9]\d)?\d{2}[\/\-\.](?:0?[1-9]|1[0-2])[\/\-\.](?:0?[1-9]|1\d|2[0-8]))(?: (?:0?\d|1\d|2[0-3])\:(?:0?\d|[1-5]\d)\:(?:0?\d|[1-5]\d)(?: \d{1,3})?)?$");
return reg.IsMatch(num);
}
public string filestype(string files1) //带点的文件扩展名
{
return files1.Substring(files1.LastIndexOf('.'),files1.Length-files1.LastIndexOf('.'));
}
}
}



====CSDN 小助手 V2.0 2005年10月16日发布====
CSDN小助手是一款脱离浏览器也可以访问Csdn论坛的软件
界面：http://blog.csdn.net/Qqwwee_Com/archive/2005/10/16/504620.aspx
下载：http://szlawbook.com/csdnv2/csdnv2.rar

为神六喝彩，向所有科技工作者致敬！
拒绝日货。