I am facing a pagination issue on my code. This is my code.
Data is coming on first redirect pagination working. as 1 and 2 but when i am clicking on 2 it redirecting to same page(page 1). then i am again clicking on 2 then it showing the 1st value of the same page. and when i click on page 1 then it showing some data and rest showing blank.
Can anyone help me on this?
Thanks
AllowSorting="true" AutoGenerateColumns="false" DataKeyNames="Currentmatch_Id" PageSize="10"
OnPageIndexChanging="grdlistTeam_PageIndexChanging"
OnRowDataBound="grdlistTeam_RowDataBound1" ShowHeader="false"
Width="100%">
Font-Underline="false" ForeColor="White"
PostBackUrl='<%# Eval("TournamentId","TournamentSubHome.aspx?TournamentId={0}") %>'
Text='<%#Eval("TournamentName")%>'>
style="margin-left: 2px;">
<%# Eval("Team1Total")%>/<%# Eval("FirstInningwickets")%>
<%# Eval("BallplayedTeam1")%>Ov
Font-Size="100%" Font-Underline="false" ForeColor="#0d2549"
PostBackUrl='<%# Eval("Team1_Id","TeamDetails.aspx?TeamId={0}") %>'
Text='<%#Eval("Team1") %>'>
v/s
Font-Size="100%" Font-Underline="false" ForeColor="#0d2549"
PostBackUrl='<%# Eval("Team2_Id","TeamDetails.aspx?TeamId={0}") %>'
Text='<%#Eval("Team2") %>'>
<%# Eval("Team2Total")%>/<%# Eval("SecondInningwickets")%>
<%# Eval("BallplayedTeam2")%>Ov
this the .cs code
/////
private void bindRecentMatches()
{
SqlConnection objCon;
SqlCommand objCmd;
string strQuery;
DataSet objDs = new DataSet();
SqlDataAdapter objDa;
int i = 0;
try
{
strQuery = "select_recent_match_by_eventorganizer";
using (objCon = new SqlConnection(ConfigurationManager.ConnectionStrings["sports"].ToString()))
{
objCon.Open();
using (objCmd = new SqlCommand(strQuery, objCon))
{
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@eventorganizer", username);
using (objDa = new SqlDataAdapter(objCmd))
{
i = objDa.Fill(objDs);
if (objDs.Tables[0].Rows.Count > 0)
{
if (grdlistTeam != null)
{
grdlistTeam.DataSource = objDs.Tables[0].DefaultView;
grdlistTeam.DataBind();
}
}
else
{
}
}
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
////////////
protected void grdlistTeam_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grdlistTeam.PageIndex = e.NewPageIndex;
bindRecentMatches();
}
/////
private void bindRecentMatches()
{
SqlConnection objCon;
SqlCommand objCmd;
string strQuery;
DataSet objDs = new DataSet();
SqlDataAdapter objDa;
int i = 0;
try
{
strQuery = "select_recent_match_by_eventorganizer";
using (objCon = new SqlConnection(ConfigurationManager.ConnectionStrings["sports"].ToString()))
{
objCon.Open();
using (objCmd = new SqlCommand(strQuery, objCon))
{
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@eventorganizer", username);
using (objDa = new SqlDataAdapter(objCmd))
{
i = objDa.Fill(objDs);
if (objDs.Tables[0].Rows.Count > 0)
{
if (grdlistTeam != null)
{
grdlistTeam.DataSource = objDs.Tables[0].DefaultView;
grdlistTeam.DataBind();
}
}
else
{
}
}
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
////////////
protected void grdlistTeam_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grdlistTeam.PageIndex = e.NewPageIndex;
bindRecentMatches();
}
sooraj singhPosted Sep 15, 2014, 2:30 PM
objCmd.Parameters.AddWithValue("@eventorganizer", username);
here "username" is never defined..
and
what does this mean?
Please Check it...it would be help if provide the database structure also...