ServerVersion = “sqlConn.ServerVersion”引发了“System.InvalidOperationException”类型的异常
publicstaticintExecuteQuantity(stringsql,int? timeOut,params SqlParameter[] parameters)
{
using(SqlConnection sqlConn =new SqlConnection())
{
using(SqlCommand cmd =new SqlCommand(sql, sqlConn))
{
try {
sqlConn.Open();
if(timeOut !=null)
cmd.CommandTimeout = (int)timeOut;
foreach(SqlParameter parameterin parameters)
{
if(parameter.Value !=null)
{
cmd.Parameters.Add(parameter);
}
}
return cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw ex;
}
finally {
cmd.Parameters.Clear();
sqlConn.Close();
}
}
}
}
参数sql为:
USE [master];BACKUP DATABASE TO DISK ='D:\云迈项目\FAMS_MVC_1.0.0\FAMS.Web\DBBak\20130315143438.bak'WITH INIT;
请问大侠看看我写的哪里错了,就是报那个错呢?!
ServerVersion = “sqlConn.ServerVersion”引发了“System.InvalidOperationException”类型的异常
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/2310/viewspace-3132234/ ,如需转载,请注明出处,否则将追究法律责任。