我把这断代码放类文件里为什么不能用?
return SqlHelper.ExecuteDataset(SqlHelper.CONN_STRING, CommandType.StoredProcedure, "sp_Pagination", para);
SqlHelper.ExecuteDataset 前面要加什么吗?
return SqlHelper.ExecuteDataset(SqlHelper.CONN_STRING, CommandType.StoredProcedure, "sp_Pagination", para);
SqlHelper.ExecuteDataset 前面要加什么吗?
string spName = "SELECT Name FROM Products " + "WHERE ID=@Id";
SqlParameter[] paramsToStore = new SqlParameter[1];
paramsToStore[0] = New SqlParameter("@Id", SqlDbType.Int);
SqlHelperParameterCache.CacheParameterSet(CONN_STRING, sql, paramsToStore);
SqlParameter storedParams = new SqlParameter[1];
storedParams = SqlHelperParameterCache.GetCachedParameterSet(CONN_STRING, sql);
storedParams(0).Value = 2;
DataSet ds;
ds = SqlHelper.ExecuteDataset(CONN_STRING, CommandType.StoredProcedure,sql, storedParams);