Forms Data Controls :: PageIndexChanging For Gridview - Error While Clicking To Page
Jan 19, 2011
i have a gridview which Pagesize set to 5. There will be some error while i click to page2, i knew it was caused by what but i got no good idea how to solve it.
Me.GridView.DataSource = DT.DefaultView
Me.GridView.DataBind()
For x As Integer = 0 To DT.Rows.Count - 1
If DT.Rows(x).Item("status") = "Verifying" Then
Me.GridView.Rows(x).BackColor = Drawing.Color.Tomato
ElseIf DT.Rows(x).Item("status") = "Processed" Then
Me.GridView.Rows(x).BackColor = Drawing.Color.CadetBlue
End If
Next
View 1 Replies
Similar Messages:
Mar 23, 2010
Ask for confirm on Gridview pageindexchanging
View 5 Replies
Nov 3, 2010
I cant for the life of me get the PageIndexChanging event to fire. Please advice.
<asp:GridView ID="gridViewTransactionList" runat="server" AutoGenerateColumns="False"
AllowPaging="True" BackColor="White" BorderColor="#3366CC" BorderStyle="Solid"
BorderWidth="1px" CellPadding="4" PageSize="10"
onpageindexchanging="gridViewTransactionList_PageIndexChanging"
ondatabinding="gridViewTransactionList_DataBinding"
onpageindexchanged="gridViewTransactionList_PageIndexChanged">
<Columns>
<asp:BoundField ItemStyle-Width = "150px" DataField = "RowNumber" HeaderText = "RowNumber" />
</Columns>
<RowStyle BackColor="#D7E5F5" ForeColor="#0F253F" CssClass="gridViewTransactionList" />
<AlternatingRowStyle BackColor="#F5F9FD" ForeColor="#0F253F" />
<FooterStyle BackColor="#99CCCC" ForeColor="#0F253F" />
<PagerStyle BackColor="#99CCCC" ForeColor="#0F253F" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<HeaderStyle BackColor="#538ED5" Font-Bold="True" ForeColor="#0F253F" />
</asp:GridView>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="btnConfirmDeletetransaction" EventName="Click" />
<asp:AsyncPostBackTrigger ControlID="gridViewTransactionList"
EventName="PageIndexChanging" />
</Triggers>
</asp:UpdatePanel>
protected override void OnInit(EventArgs e)
{
gridViewTransactionList.PageIndexChanging += new GridViewPageEventHandler(gridViewTransactionList_PageIndexChanging);
gridViewTransactionList.DataBind();
}
protected void gridViewTransactionList_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
DataTable dataTable;
gridViewTransactionList.PageIndex = e.NewPageIndex;
if (Session["TransactionDataTable"] != null)
{
dataTable = (DataTable)Session["TransactionDataTable"];
gridViewTransactionList.DataSource = dataTable;
gridViewTransactionList.DataBind();
}
}
View 6 Replies
Feb 14, 2010
In a webform I have two textbox (txtDNI and txtAPE), 2 buttons (b1 and b2), 1 gridview (myGV) and 2 functions (dt1 and dt2) that return a DataTable txtDNI will be a parameter for dt1 function and txtAPE will be a parameter for dt2 function
DNI [_______] (b1)
APE [_______] (b2)
[NOM |APE |DNI |DIR |OCUP ]
============================
[ | | | | ]
[ | | | | ]
[ | | | | ]
[ | | | | ]
============================
[ 1 2 3 4... ]
When I press b1 myGV will be fill with the dt1 function's datatable and when I press b2 myGV will be fill with the dt2 function's datatable myGV allows paging=true and when I press the next index (2 or other) It appears a PageIndexChanging error. So the pagination isn't automatic and I have to code the PageIndexChanging event When I use a ObjectDataSource and I connect it with myGV the PageIndexChanging error dessapears and the pagination is automatic The problem is the ODS only have a one selectfunction (dt1 or dt2) but not both and the configuration is on design time
The same happen with the PageIndexChanging event where I fill myGV again (with dt1 or dt2) and set the new index (myGV.PageIndex = e.NewPageIndex) and What is the problem?? ... the problem is, for example, when the user erase txtDNI and change index of pagination ... the PageIndexChanging event is fired and call the dt1 function but the txtDNI(parameter) is empty and occurs an error, the function returns an empty datatable and myGV is empty too for avoid this I create viewstates variables for each function, so I have a 2 viewstates and fill them when the user press b1 or b2 When user press the pagination, the PageIndexChanging event catch the viewstate variable and convert it into a datatable and the problem of the automatic pagination is controled The problem is I don't have 1GV in the webForm I have 5GV in some pages... and I try to avoid...
1. all the code in the PageIndexChanging events of each GV in the webform.
2. use the viewstate variables
View 3 Replies
Jun 3, 2010
I am working on object data source and datagridview. I have given object data source to the grid view as the data source of grid. The issue which i m facing is that whenever i click on next page(like 2 or 3 or 1) it takes lot of time to fire. although it is fired but I have to wait a minute or two and then it fired.
Whenever I click any event(e.g. next page , page 5 ,3 or edit etc) of gridview it does not give response. If I wait for a minute then click one of event then it performs, and then again I have to wait to fire other event.
View 22 Replies
Apr 14, 2010
i am trying to set paging using the following code in pageload event.
GridView1.DataSource = ourdataset.Tables("Products")
GridView1.DataBind()
when i select the page button the parameter value ourdataset.Tables("Products") is set to nothing ?
Protected
Sub GridView1_PageIndexChanging1(ByVal sender
As
Object,
ByVal e
As System.Web.UI.WebControls.GridViewPageEventArgs)
Handles
GridView1.PageIndexChanging
GridView1.DataSource = SortDataTable(ourdataset.Tables("Products"),
True)
View 6 Replies
Dec 1, 2010
I have GridView in UserControl (ascx) who is in another ascx.
[Code]....
View 2 Replies
Feb 8, 2011
I am getting this error when click on page no 2 of grid view on first page it is working correctly My source code of grid view is
<asp:GridView ID="GridView1" runat="server" Width="738px" CellPadding="4" ForeColor="#333333" AllowPaging="True" >
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
And c# code is
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class Time_keeping_system : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
private void Page_PreInit(object sender, EventArgs e)
{
if (Session["USERNAME"] == null)
{
this.MasterPageFile = "MasterPage.master";
}
else
{
this.MasterPageFile = "MasterPage2.master";
}
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
//TextBox1.Text = Calendar1.SelectedDate.ToShortDateString();
TextBox1.Text = Calendar1.SelectedDate.ToString("dd/MM/yyyy");
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text == "*")
{
SqlCommand cmd;
SqlConnection con = new SqlConnection("Data Source=SUNTECH-812ECD7\SQLEXPRESS;Initial Catalog=suntech;Integrated Security=True;");
cmd = new SqlCommand("select ld.username, ld.login_date,ld.login_time,wp.Project_Id,wp.Project_Of,wp.Project_Name,wp.Start_time,wp.end_time, bd.break_for,bd.break_time,bd.break_over_time,l.logout_time from login_details ld inner join working_projects
wp on ld.login_date= wp.Date join break_details bd on ld.login_date = bd.login_date join logout l on bd.login_date= l.logout_date where ld.username ='" + DropDownList1.SelectedValue + "'");
//cmd = new SqlCommand("Select * from " + DropDownList3.SelectedItem + " where project_name like ''" + TextBox1.Text + "''");
//cmd.ExecuteNonQuery();
con.Open();
cmd.Connection = con;
//SqlDataReader reader = cmd.ExecuteReader();
//GridView1.DataSource = reader;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
// reader.Close();
}
else
{
SqlCommand cmd;
SqlConnection con = new SqlConnection("Data Source=SUNTECH-812ECD7\SQLEXPRESS;Initial Catalog=suntech;Integrated Security=True;");
cmd = new SqlCommand("select ld.username, ld.login_date,ld.login_time,wp.Project_Id,wp.Project_Of,wp.Project_Name,wp.Start_time,wp.end_time, bd.break_for,bd.break_time,bd.break_over_time,l.logout_time from login_details ld inner join working_projects
wp on ld.login_date= wp.Date join break_details bd on ld.login_date = bd.login_date join logout l on bd.login_date= l.logout_date where ld.username = '" + DropDownList1.SelectedValue + "' AND ld.login_date = '" + TextBox1.Text + "'");
//cmd = new SqlCommand("Select * from " + DropDownList3.SelectedItem + " where project_name like ''" + TextBox1.Text + "''");
//cmd.ExecuteNonQuery();
con.Open();
cmd.Connection = con;
//SqlDataReader reader = cmd.ExecuteReader();
//GridView1.DataSource = reader;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
// reader.Close();
}
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
}
}
View 10 Replies
Nov 30, 2010
my C# console appliccation code is shown below :-
[Code]....
In my application a mail message send to particular recipeeient with msg body contains a hyper link.. when the recipent click on this link,it will redirect to another form(InternalForm.aspx)... bt when clicking the link error is occured,whuy its happening???? In InternalForm.aspx,page load portion access the link content(badgeno).. page load portion code of InternalForm.aspx is shown below:-
[Code]....
View 7 Replies
Feb 11, 2011
I Read This [URL] but when i click next page mygird be Empty and blank
<asp:GridView ID="grdData" runat="server" AutoGenerateColumns="False" GridLines="None"
View 1 Replies
Sep 7, 2010
I want to give my users the ability to select a row by clicking anywhere on the GridView.
So based on the selected Row i will change one particular column value based on my validation.
How can i add the click event on the GridView?
View 4 Replies
Oct 9, 2010
Within a WizardStep in the AccountManagement.aspx page, I have the following Gridview:
[Code]....
When a UserName HyperLinkField is clicked, I want to go to the another WizardStep.
With DataNavigateUrlFormatString="AccountManagement.aspx?user={0}, I think the page refreshes rather than posts back.
How do I get to another WizardStep? Do I have to cause a PostBack rather than a refresh?
View 1 Replies
Oct 7, 2010
I am having an issue with hidden cells when a PageIndexChanging event is fired in a gridview.
On the page_load I am setting the visibility of an edit button in a cell of a gridview to true or false depending on a users credentials.
Everything works as intended when the page is first loaded. When I click to a different page index the edit button is visible in all cells when it shouldn't be. The edit button is then visible in all cells even if I navigate back to the first page.
Here is the pageindexchanging event:
protected void GridView_EmployeeList_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView_EmployeeList.PageIndex = e.NewPageIndex;
GridView_EmployeeList.DataBind();
}
Here is some code from the page_load:
protected void Page_Load(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView_EmployeeList.Rows)
{
If(row.Cells[1] == "Manager")
{
row.Cells[13].Visible = true;
}
else
{
row.Cells[13].Visible = false;
}
}
}
View 3 Replies
Jun 29, 2010
i have a problem with my asp project.i have a gridview that is created dynamically and all rows cells contain hyperlinks that are created dynamically also
all i wanna do is after clicking at any on this hyperlinks i can get the index of the cell where this hyperlink i clicked exist or even the text of the hyperlink i clicked but i don't know how i can do this
The eventhandler for the hyperlink is as follow:
[Code]....
i write in this code selectedrow.cells[0] but this is not what i want.What i need to replace 0 with the index of the cell i clicked
View 10 Replies
Apr 20, 2010
i'm working in visual studio 2005 c#
how do i change gridview datasource by clicking a link ;
how do i insert code to the onclick evvent to change the data source ?
View 2 Replies
Feb 8, 2011
GridView1 fired event PageIndexChanging which wasn't handled
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class View_Project : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USERNAME"] == null)
{
Response.Redirect("Home.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
fillgrid();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
fillgrid();
}
private void fillgrid()
{
if (TextBox1.Text == "*")
{
SqlCommand cmd;
SqlConnection con = new SqlConnection("Data Source=SUNTECH-812ECD7\SQLEXPRESS;Initial Catalog=suntech;Integrated Security=True;");
cmd = new SqlCommand("Select * from " + DropDownList3.SelectedItem + " where project_name like '" + TextBox1.Text + "'");
con.Open();
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
else
{
SqlCommand cmd;
SqlConnection con = new SqlConnection("Data Source=SUNTECH-812ECD7\SQLEXPRESS;Initial Catalog=suntech;Integrated Security=True;");
cmd = new SqlCommand("Select * from " + DropDownList3.SelectedItem + " where project_name like '" + TextBox1.Text + "'");
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
}
}
View 4 Replies
Mar 20, 2010
[Code]....
So it works fine i can hover on gridview rows. Now I need to add OnClick event. When Row is clicked I need to pass value from SQL server table to textbox. How can I Add something like onrowclickevent? where I can use clicked row arguments?
View 7 Replies
May 28, 2010
I have a gridview that I have bound to a sqldatasource. However I have the gridview changing data shown per a drop down list and textbox so I can choose how I am searching.
My code includes changing the select command of the data source and rebinding the gridview.
My issue is that if I implement the edit button and click edit the grid view seems to resort back to the original select command that was entered when I created the datasource.
Is there any way to get the gridview to do what I want it to?
View 11 Replies
Mar 12, 2011
I have a gridview and sqldatasource in a form. My sqldatasource has select,delete and update command. The delete command is working but the update doest not work when I click the update command field.
Here is my code [Code]....
View 3 Replies
Feb 4, 2011
I am Working on a ASP.net project(VB.net), i have a gridview to display names of "Patients". Each patient has a unique "labID",
I have stored the patients "diagnosis" information in seperate tables( stool,urine, blood etc)
what I need is to retrieve this info when I click on a patients name in gridview.
View 6 Replies
Jun 3, 2010
I created a grid and successfully done update, delete, filled functionality.
But whenever I m clicking on Gridview row, its hieght get increased and color of the row become red while clicking on edit button. But this problem is occuring in Mozilla,IE7 not in IE6. Project is running good in IE6. What could be the solution for this.
View 8 Replies
Oct 27, 2010
I have a button called Next outside the GridView. If I click on Next, I want to highlite the 2nd row and display the details of the 2nd row below in panel. If again I click on Nextm i want to highlite 3rd row and want to display 3rd row results in a panel
View 8 Replies
Mar 9, 2011
When I try to change a page on my gridview, I keep getting this error: Index was out of range. Must be non-negative and less than the size of the collection. How can I fix this? The line the error highlights is the one below:
[Code]....
View 2 Replies
Oct 15, 2010
Is there any way to stop Gridview to turn back to first row when user click edit link button. Say there are 50 rows in gridview, user scrolled down to 45th row then click edit button. Gridview shifted to editmode but user need to roll down back again to reach the row 45th.
View 1 Replies
Feb 3, 2011
I have created a website that has some gridview controls that call stored procedures in a SQL db and display the results of the procedures. Two of the gridview controls have sorting enabled, and one has pagination enabled.
The site loads for all users who have tried it so far.
However, one user gets a "webpage not found" (HTTP 400 Bad request) error whenever they click on the pagination links or sorting links on the gridview control. It seems like it's not a security issue because the website runs as a user with permission to the database.
View 3 Replies
