sql="select datediff(ss,登录时间,getdate()) from 登录人员管理 where 登录者='111'";
string strTemp = "-1";
System.Data.SqlClient.SqlDataReader reader = null;
if (sql != null && sql.Trim() != "")
{
if (sqlConnection.State.ToString() != "Open") sqlConnection.Open();
System.Data.SqlClient.SqlCommand cmd = new SqlCommand();//(sql, sqlConnection);
cmd.Connection = sqlConnection;
cmd.CommandText = sql;
try
{
strTemp = "";
reader = cmd.ExecuteReader(); //错误!!!!!!!!!!!!!!!!!!!!!!!!
if (reader.Read())
{
strTemp = reader.GetValue(0).ToString();
}
reader.Close();
sqlConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
return strTemp;错误内容:在向服务器发送请求时发生传输级错误。 (provider: TCP 提供程序, error: 0 - 远程主机强迫关闭了一个现有的连接。)
string strTemp = "-1";
System.Data.SqlClient.SqlDataReader reader = null;
if (sql != null && sql.Trim() != "")
{
if (sqlConnection.State.ToString() != "Open") sqlConnection.Open();
System.Data.SqlClient.SqlCommand cmd = new SqlCommand();//(sql, sqlConnection);
cmd.Connection = sqlConnection;
cmd.CommandText = sql;
try
{
strTemp = "";
reader = cmd.ExecuteReader(); //错误!!!!!!!!!!!!!!!!!!!!!!!!
if (reader.Read())
{
strTemp = reader.GetValue(0).ToString();
}
reader.Close();
sqlConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
return strTemp;错误内容:在向服务器发送请求时发生传输级错误。 (provider: TCP 提供程序, error: 0 - 远程主机强迫关闭了一个现有的连接。)
--恢复数据库
declare hcforeach cursor global for select 'kill '+rtrim(spid)
from master.dbo.sysprocesses where dbid=db_id(@newName)
exec sp_msforeach_worker '?'
if(@strIsReplace='1')
begin
exec ('RESTORE DATABASE '+@newName+' FROM DISK = '''+@SourceFilePath+''' WITH password=''Reco'',REPLACE')
end
else
begin
exec ('RESTORE DATABASE '+@newName+' FROM DISK = '''+@SourceFilePath+''' WITH password=''Reco'',MOVE '''+@logicalname_db+''' TO '''+@DestFilePath1+''',
MOVE '''+@logicalname_log+''' TO '''+@DestFilePath2+'''')
exec('alter database '+@newName+' modify file(name='+@logicalname_db+',newname='+@newName+'_Data)')
exec('alter database '+@newName+' modify file(name='+@logicalname_log+',newname='+@newName+'_Log)')
exec('update '+@newName+'.dbo.项目信息 set 项目编号='''+@newName+'''')
end
我恢复完数据库后等一会,在mmc 中刷新,只要把数据库刷新出来,就能连上
若果刷新不出来,就不能连上,其间没有做任何操作。