我的代码是
SqlConnection Conn= new SqlConnection("server=localhost;database=DB;user id=sa;pwd=sa");
在建立对象时,跟踪发现报了如象错误:
conn.ServerVersion”引发了“System.InvalidOperationException”类型的异常
string {System.InvalidOperationException}
base {"无效操作。连接被关闭。"} System.SystemException {System.InvalidOperationException}跪求,解决方法!!
SqlConnection Conn= new SqlConnection("server=localhost;database=DB;user id=sa;pwd=sa");
在建立对象时,跟踪发现报了如象错误:
conn.ServerVersion”引发了“System.InvalidOperationException”类型的异常
string {System.InvalidOperationException}
base {"无效操作。连接被关闭。"} System.SystemException {System.InvalidOperationException}跪求,解决方法!!
SqlConnection conn=new SqlConnection("server=localhost;database=DB;user id=sa;pwd=sa");
SqlCommand comm=new SqlCommand(sql,conn);
int count=0;
try
{
conn.Open();
count=(int)comm.ExecuteScalar();}
catch(Exception ex)
{
}
finally
{
conn.Close();
}
return count;
要么去看看你是Sql服务器是不是已经启动了。
问题就在这句话上,你用server=.;database=DB;user id=sa;pwd=sa 试试!
还有请重新给数据库起个名字DB,这个名字不好!
server=localhost这个一般情况下容易出现错误啊!
{
string sql="select count(*) from TABLE1";
SqlConnection conn=new SqlConnection("server=localhost;database=DB;user id=sa;pwd=sa");
conn.Open();
SqlCommand comm=new SqlCommand(sql,conn);
int count=0;
count=(int)comm.ExecuteScalar();}
catch(Exception ex)
{
}
finally
{
conn.Close();
}
return count;
{ SqlConnection conn = new SqlConnection("server=.;database=pubs;user id=sa;pwd=sa"); conn.Open();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
} finally
{
}
郁闷一天了,,,,我现在该为这样,在单步跟踪时,还是发如题情况,,工作没有办法进行下去了,,,
server=.database=pubs;user=sa;password=sa