sql数据库，要用到储存过程
举些例子好吗！
------解决方案--------------------------------------------------------
using (SqlConnection con = new SqlConnection( "xxx "))
{
SqlCommand xx xxxxxxx...........
}
------解决方案--------------------------------------------------------
using (SqlConnection con = new SqlConnection( "xxx "))
{
....
}
1.{....}需要SqlConnetcion这个资源
2.{....}这段语句执行完毕以后立即dispose SqlConnetcion
偶的理解,高手指证.
------解决方案--------------------------------------------------------
要加上CLOSe
因为他是Disponse并没有关闭
------解决方案--------------------------------------------------------
using (SqlConnection conn = new SqlConnection(MyConnectionString))
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = MyStoredProcedureName;
//int rowsAffected = cmd.ExecuteNonQuery();
// ...
}
------解决方案--------------------------------------------------------
public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters) {
SqlCommand cmd = new SqlCommand();
using (SqlConnection conn = new SqlConnection(connectionString)) {
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}
}
/// <summary>
/// Prepare a command for execution
/// </summary>
/// <param name= "cmd "> SqlCommand object </param>
/// <param name= "conn "> SqlConnection object </param>
/// <param name= "trans "> SqlTransaction object </param>
/// <param name= "cmdType "> Cmd type e.g. stored procedure or text </param>
/// <param name= "cmdText "> Command text, e.g. Select * from Products </param>
/// <param name= "cmdParms "> SqlParameters to use in the command </param>
private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, string cmdText, SqlParameter[] cmdParms) {
if (conn.State != ConnectionState.Open)
conn.Open();
cmd.Connection = conn;
cmd.CommandText = cmdText;
if (trans != null)
cmd.Transaction = trans;
cmd.CommandType = cmdType;
if (cmdParms != null) {
foreach (SqlParameter parm in cmdParms)
cmd.Parameters.Add(parm);
}
}
}
}
petshop 4.0中的,我只看见了open,没有看见close.所以偶认为dispose的前提需要关闭连接
------解决方案--------------------------------------------------------
出了using块,会自动销毁掉
------解决方案--------------------------------------------------------
xinshijiuu() ( ) 信誉：100
先搞个数据库的命名空间不就可以USING啦.
======================================================
汗！
using (SqlConnection con = new SqlConnection( "xxx "))
{
....
}
1.{....}需要SqlConnetcion这个资源
2.{....}这段语句执行完毕以后立即dispose SqlConnetcion
偶的理解,高手指证.
---------------------------------