UC知道C#和SQL2000的连接问题 急~~
来源：百度知道 编辑：UC知道 时间：2024/06/01 14:24:11
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace houseAgency.mothedCls
{
class ClsCon
{
public SqlConnection conn;
/// <summary>
/// Connection method
/// </summary>
public void ConDatabase()
{
conn = new SqlConnection("server=.;pwd=;uid=sa;database=db_showHouse");
}
/// <summary>
/// close Connection method
/// </summary>
/// <returns></returns>
public bool closeCon()
{
try
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return true;
}
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace houseAgency.mothedCls
{
class ClsCon
{
public SqlConnection conn;
/// <summary>
/// Connection method
/// </summary>
public void ConDatabase()
{
conn = new SqlConnection("server=.;pwd=;uid=sa;database=db_showHouse");
}
/// <summary>
/// close Connection method
/// </summary>
/// <returns></returns>
public bool closeCon()
{
try
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return true;
}
public void ConDatabase()
{
conn = new SqlConnection("server=.;pwd=;uid=sa;database=db_showHouse");
}
conn.open()在那里？
是不是你的SQL服务器没开啊。。。还有，你try里面写的如果状态为开，则关闭？？你在try里面直接写conn.open()呢，如果还不行，它报的是什么错？
------------
你为什么一定要用conn.State == ConnectionState.Open呢？
直接
try
{
conn.open();
}
catch(Exception ex)
{
messagebox.show(ex.message);
}
finally
{
conn.close();
}
这样就行了啊，简单明了
你没有打开数据库吧
没有conn.open()；这才能打开数据库啊！
要给出错误的信息，别让大家猜。