sqlConnection = new SqlConnection();
sqlConnection.ConnectionString = ConfigurationSettings.AppSettings["connectionStrsearch"];
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("pageSplit_Proc", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@aTableName", DbType.String).Value = "gs_zhaopin";
sqlCommand.Parameters.AddWithValue("@aGetFields", DbType.String).Value = "*";
sqlCommand.Parameters.AddWithValue("@anOrderField", DbType.String).Value = "datetime";
sqlCommand.Parameters.AddWithValue("@aPageSize", DbType.Int32).Value = 10;
sqlCommand.Parameters.AddWithValue("@aPageIndex", DbType.Int32).Value = page;
sqlCommand.Parameters.AddWithValue("@anIsCount", DbType.Boolean).Value = 1;
sqlCommand.Parameters.AddWithValue("@anIsDESC", DbType.Boolean).Value = 1;
sqlCommand.Parameters.AddWithValue("@aQuery", DbType.String).Value = "cdetail like '%" + txt + "%'";
sqlCommand.Parameters.AddWithValue("@aCount", DbType.Int32).Value = 0;
sqlCommand.Parameters["@aCount"].Direction = ParameterDirection.Output;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
//sqlDataAdapter.SelectCommand = sqlCommand;
DataSet ds = new DataSet();
sqlDataAdapter.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
}这样返回的ItemArray 是1,正确的应该是返回一行里面所有的列的维数..如果表有15列,返回的ItemArray就是15,为什么会只返回这个?
sqlConnection.ConnectionString = ConfigurationSettings.AppSettings["connectionStrsearch"];
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("pageSplit_Proc", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@aTableName", DbType.String).Value = "gs_zhaopin";
sqlCommand.Parameters.AddWithValue("@aGetFields", DbType.String).Value = "*";
sqlCommand.Parameters.AddWithValue("@anOrderField", DbType.String).Value = "datetime";
sqlCommand.Parameters.AddWithValue("@aPageSize", DbType.Int32).Value = 10;
sqlCommand.Parameters.AddWithValue("@aPageIndex", DbType.Int32).Value = page;
sqlCommand.Parameters.AddWithValue("@anIsCount", DbType.Boolean).Value = 1;
sqlCommand.Parameters.AddWithValue("@anIsDESC", DbType.Boolean).Value = 1;
sqlCommand.Parameters.AddWithValue("@aQuery", DbType.String).Value = "cdetail like '%" + txt + "%'";
sqlCommand.Parameters.AddWithValue("@aCount", DbType.Int32).Value = 0;
sqlCommand.Parameters["@aCount"].Direction = ParameterDirection.Output;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
//sqlDataAdapter.SelectCommand = sqlCommand;
DataSet ds = new DataSet();
sqlDataAdapter.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
}这样返回的ItemArray 是1,正确的应该是返回一行里面所有的列的维数..如果表有15列,返回的ItemArray就是15,为什么会只返回这个?
解决方案 »
- 如何实现C# devexpress控件的多语言
- c#中timer的tick事件不触发的原因
- Socket超时问题
- C#菜鸟问题,如何循环获得文本框的值
- 我是新手,作了个自定义控件,将他拖入table中时候,发现他居然占了2行位置,控件占了一行,然后第二行是空白,想把空白的去掉如何做啊?
- C#没的指针怎么会有char*呢?
- 跪求C#书籍
- 有关.NET使用的Forms身份验证cookie(包含身份验票)的疑问?
- 看到个比较激动和恐怖的消息
- 急问:Web方式中报表问题
- 怎么做不规则窗体... 谢谢
- 找不到文件“Microsoft.Windows.CommonLanguageRuntime, Version=2.0.50727.0”。
sqlConnection.ConnectionString = ConfigurationSettings.AppSettings["connectionStrsearch"];
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("pageSplit_Proc", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@aTableName", DbType.String).Value = "gs_zhaopin";
sqlCommand.Parameters.AddWithValue("@aGetFields", DbType.String).Value = "*";
sqlCommand.Parameters.AddWithValue("@anOrderField", DbType.String).Value = "datetime";
sqlCommand.Parameters.AddWithValue("@aPageSize", DbType.Int32).Value = 10;
sqlCommand.Parameters.AddWithValue("@aPageIndex", DbType.Int32).Value = page;
sqlCommand.Parameters.AddWithValue("@anIsCount", DbType.Boolean).Value = 1;
sqlCommand.Parameters.AddWithValue("@anIsDESC", DbType.Boolean).Value = 1;
sqlCommand.Parameters.AddWithValue("@aQuery", DbType.String).Value = "cdetail like '%" + txt + "%'";
sqlCommand.Parameters.AddWithValue("@aCount", DbType.Int32).Value = 0;
sqlCommand.Parameters["@aCount"].Direction = ParameterDirection.Output;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
//sqlDataAdapter.SelectCommand = sqlCommand;
DataSet ds = new DataSet();
sqlDataAdapter.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
} 你的存储过程返回的是什么呢
按照你这样的写法应该是返回取得的数量把..所以当然是1
sqlCommand.Parameters["@aCount"].Direction = ParameterDirection.Output; 这个是返回的其中一个..如果一行有15列..不加这个@aCount则返回的ItemArry就是15..加了应该显示的就是16了@aCount是存储过程里面的其中一个sql语句返回的结果应该返回的是一行所有的数据加上@aCount