c#调用mysql分页存储过程_C# MySql分页存储过程的应用

protected voidget_data()

{string strWhere = "where idmde='" + DropDownList1.SelectedValue + "' and idmke='" + DropDownList2.SelectedValue + "'";string fldName = "iduse,uname,email,euser,werks";int pageSize = 5;int pageCount = 1;int pageCountMod = 0;int doCount = 0;int pageIndex =System.Convert.ToInt32(pageIndexLab.Text.ToString());

myco= newmysqlConnection(strconn);

myco.Open();

mycomm= new MySqlCommand("GetRecordCount", myco);

mycomm.CommandType=CommandType.StoredProcedure;

MySqlParameter[] para= newMySqlParameter[]{new MySqlParameter("@tbName",MySqlDbType.VarChar,20),new MySqlParameter("@strWhere",MySqlDbType.VarChar,500)};

para[0].Value = "uinfo";

para[1].Value =strWhere;

mycomm.Parameters.AddRange(para);

MySqlDataReader mydr=mycomm.ExecuteReader();while(mydr.Read()){

pageCount= System.Convert.ToInt32(mydr["countStr"].ToString()) ;

pageCountMod= pageCount %pageSize;

pageCount= pageCount/pageSize;if (pageCount == 0)

{//pageCount++;

}else{if (pageCountMod != 0)

{

pageCount++;

}

}

pageCountLab.Text=pageCount.ToString();

}if (pageIndex == 0)

{

pageIndex++;

}

mydr.Close();

mycomm.Dispose();

mycomm= new MySqlCommand("GetRecordAsPage", myco);

mycomm.CommandType=CommandType.StoredProcedure;

para.Initialize();

para= newMySqlParameter[]{new MySqlParameter("@tbName",MySqlDbType.VarChar,20),new MySqlParameter("@fldName",MySqlDbType.VarChar,1000),new MySqlParameter("@strWhere",MySqlDbType.VarChar,500),new MySqlParameter("@pageIndex",MySqlDbType.Int32),new MySqlParameter("@pageSize",MySqlDbType.Int32),new MySqlParameter("@orderType",MySqlDbType.Int16),new MySqlParameter("@sortName",MySqlDbType.VarChar,50)};

para[0].Value = "uinfo";

para[1].Value =fldName;

para[2].Value =strWhere;

para[3].Value =pageIndex;

para[4].Value =pageSize;

para[5].Value = 0;

para[6].Value = "iduse";

mycomm.Parameters.AddRange(para);

MySqlDataAdapter myAdapter= newMySqlDataAdapter(mycomm);

DataSet myDataSet= newDataSet();

DataView m_DataView= newDataView();

myAdapter.Fill(myDataSet);

m_DataView= myDataSet.Tables[0].DefaultView;

GridView1.DataSource=m_DataView;

GridView1.DataBind();

GridView2.DataSource=m_DataView;

GridView2.DataBind();

GridView3.DataSource=m_DataView;

GridView3.DataBind();

DropDownpage.Items.Clear();if (pageCount != 0)

{

doCount= 0;while (doCount

{

doCount++;

DropDownpage.Items.Add(new ListItem(doCount.ToString()+"页", doCount.ToString()));

}

}if (pageIndex == 1)

{

Button_IndexFirst.Enabled= false;

Button_IndexPrevious.Enabled= false;

Button_IndexNext.Enabled= true;

Button_IndexLast.Enabled= true;

}else if (pageIndex ==pageCount)

{

Button_IndexFirst.Enabled= true;

Button_IndexPrevious.Enabled= true;

Button_IndexNext.Enabled= false;

Button_IndexLast.Enabled= false;

}else{

Button_IndexFirst.Enabled= true;

Button_IndexPrevious.Enabled= true;

Button_IndexNext.Enabled= true;

Button_IndexLast.Enabled= true;

}if (pageCount == 0 || pageCount == 1)

{

pageIndex=pageCount;

Button_IndexFirst.Enabled= false;

Button_IndexPrevious.Enabled= false;

Button_IndexNext.Enabled= false;

Button_IndexLast.Enabled= false;

DropDownpage.Enabled= false;

}else{

DropDownpage.Enabled= true;

}

pageIndexLab.Text=pageIndex.ToString();if (pageIndex != 0)

{

DropDownpage.SelectedItem.Selected= false;

DropDownpage.Items.FindByValue(pageIndex.ToString()).Selected= true;

}

myco.Close();

}protected void Button_IndexFirst_Click(objectsender, EventArgs e)

{

pageIndexLab.Text= "1";if (pageCountLab.Text.Equals("0"))

{

pageIndexLab.Text= "0";

}

get_data();

}protected void Button_IndexPrevious_Click(objectsender, EventArgs e)

{int pageIndex =System.Convert.ToInt32(pageIndexLab.Text.ToString());

pageIndex--;if (pageIndex < 0)

{

pageIndex= 0;

}

pageIndexLab.Text=pageIndex.ToString();

get_data();

}protected void Button_IndexNext_Click(objectsender, EventArgs e)

{int pageIndex =System.Convert.ToInt32(pageIndexLab.Text.ToString());int pageCount =System.Convert.ToInt32(pageCountLab.Text.ToString());

pageIndex++;if (pageIndex >pageCount)

{

pageIndex=pageCount;

}

pageIndexLab.Text=pageIndex.ToString();

get_data();

}protected void Button_IndexLast_Click(objectsender, EventArgs e)

{int pageIndex =System.Convert.ToInt32(pageIndexLab.Text.ToString());int pageCount =System.Convert.ToInt32(pageCountLab.Text.ToString());

pageIndex=pageCount;

pageIndexLab.Text=pageIndex.ToString();

get_data();

}protected void DropDownpage_SelectedIndexChanged(objectsender, EventArgs e)

{

pageIndexLab.Text=DropDownpage.SelectedValue;

get_data();

}