数据出不来是啥原因？在返回数据时DBM.ExecuteQuery("Class_GetPagedBykeyword", parms);这个参数老为空？取不到值吧

feifeiyaqi3 2010-11-02 05:33:03

数据出不来是啥原因？在返回数据时DBM.ExecuteQuery("Class_GetPagedBykeyword", parms);这个参数老为空？取不到值吧。
谢谢

textbox 用来输入查询的文本框
按钮用来提交事件
datagrid 用来显示数据吧

源码如下：
public DataSet Class_GetPagedBykeyword(string keyword, int pageIndex, int pageSize, out int totalCount)
{
totalCount = 0;
SqlParameter[] parms = new SqlParameter[4];
parms[0] = new SqlParameter("@keyword", SqlDbType.NVarChar, 50);
parms[0].Value = keyword;
parms[1] = new SqlParameter("@PageIndex", SqlDbType.Int);
parms[1].Value = pageIndex;
parms[2] = new SqlParameter("@PageSize", SqlDbType.Int);
parms[2].Value = pageSize;
parms[3] = new SqlParameter("@TotalCount", SqlDbType.NVarChar, 50);
parms[3].Value = totalCount;
return DBM.ExecuteQuery("Class_GetPagedBykeyword", parms);
}

1.

public int totalCount;
public int pageIndex=1 ;
public int pageSize = 8;

public string keyword = "";
protected void Page_Load(object sender, EventArgs e)
{
keyword = Convert.ToString(System.Web.HttpContext.Current.Request["keyword"]);

//pageIndex = Convert.ToInt32(System.Web.HttpContext.Current.Request["pageIndex"]);
totalCount = Convert.ToInt32(System.Web.HttpContext.Current.Request["totalCount"]);
if (!IsPostBack)
{
AspNetPager1.Visible = false;
// bindData();

}
}

public void AspNetPager1_PageChanged(object sender, EventArgs e)
{
bindData();
}

protected void btnSubmit_Click(object sender, EventArgs e)
{
string keyword = this.TextBox4.Text.Trim();

if (keyword == null)
{
DataGrid1.Visible = false;
}
else
{
bindData();
DataGrid1.Visible = true;
}

}

public void bindData()
{

string keyword2 = this.TextBox4.Text.Trim();
int pageIndex2 = pageIndex;
int pageSize2 = pageSize;
int totalCount2 = totalCount;
AspNetPager1.Visible = true;

PublishExam.Operates.imporMeansDAL dal = new imporMeansDAL();
AspNetPager1.RecordCount = totalCount;
DataGrid1.AllowPaging = true;
DataGrid1.PageSize = AspNetPager1.PageSize;
DataGrid1.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
DataGrid1.DataSource = this.classDal.Class_GetPagedBykeyword(keyword2, pageIndex2, pageSize2, out totalCount2);
DataGrid1.DataBind();

}

...全文