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:

Forms Data Controls :: Ask For Confirm On Gridview Pageindexchanging

Mar 23, 2010

Ask for confirm on Gridview pageindexchanging

View 5 Replies

Forms Data Controls :: GridView PageIndexChanging Not Firing

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

Forms Data Controls :: Filling A GridView And Its PageIndexChanging

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

Forms Data Controls :: PageIndexChanging And Other Events Of Gridview Is Not Working

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

Forms Data Controls :: Pass Datatable Value To Gridview Pageindexchanging Event?

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

Forms Data Controls :: GridView PageIndexChanging And RowCommand Not Returning E.CommandArgument

Dec 1, 2010

I have GridView in UserControl (ascx) who is in another ascx.

[Code]....

View 2 Replies

Forms Data Controls :: GridView1 On First Page Fired Event PageIndexChanging Which Wasn't Handled

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

Web Forms :: Error On Clicking Link-Cant Redirect To Target Page-Error Page Is Shown?

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

Forms Data Controls :: The GridView "gridData" Fired Event PageIndexChanging Which Wasn't Handled

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

Forms Data Controls :: Select A Row In A Gridview By Clicking Anywhere On It?

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

Forms Data Controls :: Clicking A GridView Hyperlink To Go To Another WizardStep?

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

Forms Data Controls :: Hidden Cells Become Visible When PageIndexChanging Fired?

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

Forms Data Controls :: Get Cellindex In Dynamic Gridview After Clicking A Hyperlink On It?

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

Forms Data Controls :: Change Gridview Datasource By Clicking A Link?

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

Forms Data Controls :: GridView1 Fired Event PageIndexChanging Which Wasn't Handled

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

Forms Data Controls :: Pass Value From SQL Server Table To Textbox By Clicking Gridview Row

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

Forms Data Controls :: Clicking Edit Changes GridView Back To Original Query?

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

Forms Data Controls :: GridView Not Updating / After Clicking Update Command Field?

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

Forms Data Controls :: Clicking On Gridview Item To Retrieve Info From Database?

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

Forms Data Controls :: Gridview Row Height Get Increased And Color Of The Row Become Red While Clicking On Edit Button?

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

Forms Data Controls :: Select Row On GridView By Clicking Next Button / Want To Display 3rd Row Results In A Panel

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

Forms Data Controls :: Getting Error On Changing Page In Gridview

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

Forms Data Controls :: How To Restore Gridview Vertical Position After Clicking Edit Link Button

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

Forms Data Controls :: Webpage Not Found When Clicking Sort Or Pagination Links On Gridview Control

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







Copyrights 2005-15 www.BigResource.com, All rights reserved