datalist分页（cj168.DataAccess.MagsDB中的2个方法）
点击次数：20 次 发布日期：2008-11-26 17:38:36 作者：源代码网
|
{ SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlDataAdapter myCommand = new SqlDataAdapter("GetSearchResult", myConnection); myCommand.SelectCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterTxtSearch = new SqlParameter("@txtSearch", SqlDbType.VarChar, 255); parameterTxtSearch.Value = txtSearch; myCommand.SelectCommand.Parameters.Add(parameterTxtSearch); DataSet myDataSet = new DataSet(); myCommand.Fill(myDataSet, StartIndex, PageSize, "SearchResult"); return myDataSet.Tables["SearchResult"].DefaultView; } public int GetSearchResultCount(String txtSearch) { int intCount ; intCount = 0; SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlCommand myCommand = new SqlCommand("GetSearchResultCount", myConnection); myCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterTxtSearch = new SqlParameter("@txtSearch", SqlDbType.VarChar, 255); parameterTxtSearch.Value = txtSearch; myCommand.Parameters.Add(parameterTxtSearch); myConnection.Open(); SqlDataReader dr =myCommand.ExecuteReader(); if(dr.Read()) { intCount = Int32.Parse(dr["co"].ToString()); } else { intCount = 0; } dr.Close(); return intCount; 源代码网供稿. |
