我是将数据库 放到工程下的一个文件夹内的。
如果用这种连接数据库的方法,在服务器上还能连接上数据库么?
public class DB
{
private const string CONKEY = "SqlConnStr";
SqlConnection conn = null;
SqlCommand cmd = new SqlCommand(); //HttpContext.Current /// <summary>
/// 构造函数
/// </summary>
public DB()
{
try
{
string ConnStr = "server=.;database=Shcool;uid=sa;pwd=sa";
conn = new SqlConnection(ConnStr);
conn.Open(); }
catch
{ }
}
/// <summary>
/// 析构函数
/// </summary>
~DB()
{
// CloseConn();
}
/// <summary>
/// 返回Connection对象
/// </summary>
/// <returns></returns>
public SqlConnection GetConnection()
{
return (conn);
}
/// <summary>
/// 返回Command对象
/// </summary>
/// <param name="strsql"></param>
/// <returns></returns>
public SqlCommand GetCommand(string strsql)
{ try
{
SqlCommand SqlComm = new SqlCommand(strsql, conn); return (SqlComm);
}
catch
{
return (null);
}
}
如果用这种连接数据库的方法,在服务器上还能连接上数据库么?
public class DB
{
private const string CONKEY = "SqlConnStr";
SqlConnection conn = null;
SqlCommand cmd = new SqlCommand(); //HttpContext.Current /// <summary>
/// 构造函数
/// </summary>
public DB()
{
try
{
string ConnStr = "server=.;database=Shcool;uid=sa;pwd=sa";
conn = new SqlConnection(ConnStr);
conn.Open(); }
catch
{ }
}
/// <summary>
/// 析构函数
/// </summary>
~DB()
{
// CloseConn();
}
/// <summary>
/// 返回Connection对象
/// </summary>
/// <returns></returns>
public SqlConnection GetConnection()
{
return (conn);
}
/// <summary>
/// 返回Command对象
/// </summary>
/// <param name="strsql"></param>
/// <returns></returns>
public SqlCommand GetCommand(string strsql)
{ try
{
SqlCommand SqlComm = new SqlCommand(strsql, conn); return (SqlComm);
}
catch
{
return (null);
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货