Hello Friends,

I'm implementing custom paging in my GridView. Paging numbering(in-built paging numbering) does not display but it brings the records are queried . Below giving my code please let me know what changes i should make in my code. But if i use in-built paging(normal paging) then that's working fine......

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
lblMsg.Text = e.NewPageIndex.ToString();
int pageNumber=Convert.ToInt32(e.NewPageIndex);
int recordPerPage= 4;
int startRecord = (pageNumber) * recordPerPage + 1;
int maxRecord = startRecord + recordPerPage;

bindGridView1(startRecord,maxRecord);
}

public void bindGridView1(int startRecord,int maxRecord)
{
string connectionString = "server=.;database=Auto_New;uid=sa;pwd=;";

using(SqlConnection mCon = new SqlConnection(connectionString))
{
SqlCommand mDataCom = new SqlCommand();

mDataCom.Connection = mCon;

mDataCom.CommandType = CommandType.StoredProcedure;
mDataCom.CommandText = "SP_Select1";
mDataCom.Parameters.AddWithValue("@startRecord", startRecord);
mDataCom.Parameters.AddWithValue("@maxRecord", maxRecord);

SqlDataAdapter da = new SqlDataAdapter(mDataCom);
DataSet ds = new DataSet();
da.Fill(ds);

GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}

Hi Friend,

u are not able to see the current page index inside gridview, this is the only issue with you....

Thanks
-Pankaj

__________________
Thanks
-Pankaj Bahuguna

one more thing is needed to see here please put the aspx code

<asp:Gridview.................></GridView>

that will really help to get the scenario......

__________________
Thanks
-Pankaj Bahuguna

Here i'm giving my GridView code

<asp:GridViewID="GridView1"runat="server"AutoGenerateColumns="False"AllowPaging="True"onpageindexchanging="GridView1_PageIndexChanging"
PageSize="4"ondatabound="GridView1_DataBound">
<Columns>
<asp:BoundFieldDataField="RNo"HeaderText="RNO"/>
<asp:BoundFieldDataField="ID"HeaderText="ID"/>
<asp:BoundFieldDataField="Name"HeaderText="Name"/>
</Columns></asp:GridView>