/// <summary> /// 绑定数据 /// </summary> private void BindGame() { StringBuilder strWhere = new StringBuilder(); strWhere.Append(" 1=1 "); IList <MySqlParameter> parm = new List <MySqlParameter>(); if (!string.IsNullOrEmpty(this.txtCnname.Text.Trim())) { //strWhere.Append(" And gm.Gm_name like '%" + this.txtCnname.Text.Trim() + "%'"); strWhere.Append(" And gm.Gm_name like @Cnname"); parm.Add(new MySqlParameter("@Cnname", "%" + this.txtCnname.Text.Trim() + "%")); } if (this.rblState.SelectedValue == "0") //0启用1停用 默认0 { strWhere.Append(" And gm.Gm_state = 0"); } else { strWhere.Append(" And gm.Gm_state = 1"); } strWhere.Append(" And gm.Gm_del = 0 "); //DataView view = gameMessage.GetTable(strWhere.ToString()).DefaultView; string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"]; // view = gameMessage.GetTable(strWhere.ToString(),parm,sort); //view.Sort = sort; this.gvGame.DataSource = gameMessage.GetTable(strWhere.ToString(), parm);; this.gvGame.DataBind(); }