#region 带output参数的存储过程 public string getStoredProcedure2(string storedProcedureName)
{
getcon();
string strReturnRows = "";
string sql = String.Format("EXECUTE " + storedProcedureName + " @allRows OUTPUT"); //执行的T-SQL串
SqlCommand cmd = new SqlCommand(sql, My_con);
cmd.Parameters.Add(new SqlParameter("@allRows", SqlDbType.Int));
cmd.Parameters["@allRows"].Direction = ParameterDirection.Output;
cmd.CommandTimeout = 1000; cmd.ExecuteNonQuery(); //worker.ReportProgress((int) cmd.Parameters["@allRows"].Value);
strReturnRows = cmd.Parameters["@allRows"].Value.ToString();
con_close();
return strReturnRows;
} #endregion
{
getcon();
string strReturnRows = "";
string sql = String.Format("EXECUTE " + storedProcedureName + " @allRows OUTPUT"); //执行的T-SQL串
SqlCommand cmd = new SqlCommand(sql, My_con);
cmd.Parameters.Add(new SqlParameter("@allRows", SqlDbType.Int));
cmd.Parameters["@allRows"].Direction = ParameterDirection.Output;
cmd.CommandTimeout = 1000; cmd.ExecuteNonQuery(); //worker.ReportProgress((int) cmd.Parameters["@allRows"].Value);
strReturnRows = cmd.Parameters["@allRows"].Value.ToString();
con_close();
return strReturnRows;
} #endregion
2、使用BackgroundWorker 找度娘,很简单的
如果要求不高的话:http://blog.csdn.net/xianfajushi/article/details/7679637
http://blog.csdn.net/poloyzhang/article/details/7748132http://download.csdn.net/detail/poloyzhang/4429572
http://download.csdn.net/detail/poloyzhang/4429572为了更好的和大家共享我到时候做一个单独的解决方案打包供大家下载下.