Forms Data Controls :: GridView's RowDataBound Event Fired Twice?
Apr 20, 2010
I have a very simple asp.net page, just some buttons and one GridView on it. The logic is a user click the QUery button,then the button click event was trigured to populate the gridview with data queried from database via LINQ. for a user friendly interface, in RowDataBound event, I visit every row, change a boolean value into checkbox represention. But it seem that the RowDataBound run twice, because the checkboxs were inserted twice for every row in one cell. so why? the source code snippet as follow:
protected void btnSelect_Click(object sender, EventArgs e)
{
RetiredEmployeeDataContext db = new RetiredEmployeeDataContext();
GridView1.DataSource = db.ENTUserAccountSelectAll();//userAccounts;
GridView1.DataBind();
}
protected void GridView1_OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
CheckBox chkActive = new CheckBox();
chkActive.Checked = ((ENTUserAccount)e.Row.DataItem).IsActive;
chkActive.Enabled = false;
e.Row.Cells[5].Controls.Add(chkActive);
}
}
View 9 Replies
Similar Messages:
Apr 21, 2010
Why wasn't my GridView's RowDataBound event fired? I have a masterpage on whick i have a query button, and I have a content page on which i have a customized GridView(named cgvEmployees,derived from GridView). The logic is when user click the button, the button click event triggered that search the underlying database and populate the GridView.
Everything runs great except that RowDataBound event isn't triggered. Because I have to change some cells' representations in RowDataBound event handler. I have surfed so much pages to find the answer but failed. Below is what i have already done:
1. set the autoeventwireup to true;
2. i have a cgvEmployees.bind() sentence in the button click event handler;
3. i have OnRowDataBound="cgvEmployees_OnRowDataBound" in the content page GridView tag attribute
by the way, the database query is coded by Linq Dynamic Query (please google 'dynamic Linq').
void Master_QueryButton_Click(object sender, EventArgs e)
{
RetiredEmployeeDataContext db = new RetiredEmployeeDataContext();
NameValueCollection nvcQueryKeyValue = getNVCQueryKeyValue();
Expression<Func<RetiredEmployee, bool>> searchPredicate = getLambdaExpr(nvcQueryKeyValue);
IQueryable<RetiredEmployee> retireds = db.RetiredEmployees;
Expression expr = Expression.Call(typeof(Queryable), "Where",
new Type[] { typeof(RetiredEmployee) }, Expression.Constant(retireds), searchPredicate);
IQueryable<RetiredEmployee> query = db.RetiredEmployees.AsQueryable().Provider.CreateQuery<RetiredEmployee>(expr);
List<RetiredEmployee> employeeList = new List<RetiredEmployee>(query);
List<RetiredEmployeeEO> employees = new List<RetiredEmployeeEO>();
foreach (RetiredEmployee employee in employeeList)
{
RetiredEmployeeEO employeeEO = new RetiredEmployeeEO();
employeeEO.MapEntityToProperties(employee);
employees.Add(employeeEO);
}
cgvEmployees1.ListClassName = typeof(RetiredEmployeeEOList).AssemblyQualifiedName;
cgvEmployees1.LoadMethodName = "LoadFromQuery";
cgvEmployees1.LoadMethodParameters.Clear();
cgvEmployees1.LoadMethodParameters.Add(employees);
cgvEmployees1.DataBind();
}
protected void cgvEmployees1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//Add the edit link to the action column.
HyperLink editLink = new HyperLink();
if (((BasePage)this.Page).ReadOnly)
{
editLink.Text = "View";
}
else
{
editLink.Text = "Edit";
}
editLink.NavigateUrl = "employee.aspx" + EncryptQueryString("id=" + ((RetiredEmployeeEO)e.Row.DataItem).ID.ToString());
if(e.Row.Cells[0].Controls.Count==0)
e.Row.Cells[0].Controls.Add(editLink);
//Add checkbox to display the isactive field.
CheckBox chkActive = new CheckBox();
chkActive.Checked = ((RetiredEmployeeEO)e.Row.DataItem).liveOrDead;
chkActive.Enabled = false;
if(e.Row.Cells[24].Controls.Count==0)
e.Row.Cells[24].Controls.Add(chkActive);
if (((RetiredEmployeeEO)e.Row.DataItem).gender.Equals((byte)1))
e.Row.Cells[2].Text = "Male";
else
e.Row.Cells[2].Text = "Female";
if (((RetiredEmployeeEO)e.Row.DataItem).retiredOr.Equals((byte)1))
e.Row.Cells[14].Text = "Retired1";
else
e.Row.Cells[14].Text = "Retired2";
if (((RetiredEmployeeEO)e.Row.DataItem).birthday.Equals("1753-01-01"))
e.Row.Cells[3].Text = "";
if (((RetiredEmployeeEO)e.Row.DataItem).dayToEmployed.Equals("1753-01-01"))
e.Row.Cells[6].Text = "";
if (((RetiredEmployeeEO)e.Row.DataItem).dayRetired.Equals("1753-01-01"))
e.Row.Cells[7].Text = "";
if (((RetiredEmployeeEO)e.Row.DataItem).dayParty.Equals("1753-01-01"))
e.Row.Cells[13].Text = "";
if (((RetiredEmployeeEO)e.Row.DataItem).daytoassign.Equals("1753-01-01"))
e.Row.Cells[17].Text = "";
}
}
View 22 Replies
Jan 5, 2011
I have a page on which everything is loaded dynamically.
There is a Gridview (AutoGenerateColumns=true) and in the RowDataBound I check every column for a boolean datatype. If found I add a checkbox (autopostback=true) to the cell and register the CheckedChanged event.
The problem is, that I only get the CheckedChanged event, if I reload the grid in Page_Load:
protected void Page_Load(object sender, EventArgs e) {
LoadGrid();
}
But this is very expensive and causes that the db request will be executed twice. If I changed the code to what I want:
protected void Page_Load(object sender, EventArgs e) {
if (!this.IsPostBack)
loadGrid();
}
I get no CheckedChanged event.
Is there a possibility to get:
- Adding a Checkbox in RowDataBound
- Only "LoadGrid()" if it is no PostBack
- Getting the CheckedChanged event of the relevant row
View 2 Replies
Jul 19, 2010
why the gridview RowDataBound event fires during a select command. I only expect it to run when the gridview is being populated with data. Is there some way to stop it from running when the select command is triggered?
View 3 Replies
Feb 17, 2010
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
}
<asp:GridView ID="grdMain"
runat="server"
OnRowDataBound="grdMain_RowDataBound"
View 6 Replies
May 17, 2010
When a Gridview row is in edit, I need to default an empty textbox to today's date. I am close, but the defaulted date is is not saved to the database. I can key in the date and the date is displayed and saved to the database. Even more interesting:
1. The date is defaulted to - 5/17/2010
2. If I erase the month and key the "5" back in the data is not saved.
3. If I erase the month and then change the month to "6", the data is saved to the database. If any value is changed in the date the save works.
[Code]....
View 6 Replies
Mar 16, 2010
I use linq query as below and bind it to listview. I have 2 label control (name,remain).I want to check in code behind if p.count<200 then remain ="Sample text1"if price <300 then "sample text2".I know that I could do it before linq in gridview RowDataBound event
Dim prod= From p In db.products _
Select New With {p.name p.category, p.count}
postlist.DataSource = prod
postlist.DataBind()
View 1 Replies
Feb 22, 2010
How to get the DataKey value in RowDataBound event for GridView
View 3 Replies
Mar 3, 2010
I am NOT formatting at DECLARATIVE time
The following code works perfectly
[Code]....
Can I directly format e.RowDataItem.
I don't want to format by using e.Row.Cells[4].Text
View 3 Replies
Feb 5, 2010
How do I access GridView Page Index in RowDataBound event? I am assigning PageIndex to hyperlink on the gridview, for this I was planning to use "GridView1.PageIndex" in rowdatabound event. Problem is when I got second page in gridview (10 rows per page), the first row in the page shows page index as "0" and from second row it becomes 1. And if I goto third page, the first row in the page shows page index as "1" and from second row it becomes 2.
View 13 Replies
Feb 5, 2011
I have a Gridview with edit and update feature enabled. It displays the data correctly but when I click on the Edit linkbutton(to edit the data), I get the error "Object reference not set to an instance of an object".
I tried debugging and found that the row which I click (say editindex is 1) loses its value. I could identify this while debugging the code, when the code flow moves to the rowdatabound event, the label (or for that matter any control in the rowdatabound event) shows a null value and eventually errors out.
I am unable to figure out as to why the control specified in the rowdatabound event loses its value when editing. Note: The lost valueow data is the one which I tried editing.
I am attaching the code which I have written for the rowdatabound event.
[Code]....
View 6 Replies
Feb 4, 2010
Can I call a javascript function in the RowDatabound event of the Gridview?
I am currently enabling/disabling buttons in each of my gridview rows based on a status value from the database.I need to fire a javascript function (say alert('current status')) when the status is 0,else dont fire that function.Can I achieve this in the row databound event?
View 9 Replies
Dec 19, 2010
I want to have a total in the gridview footer of the duration of the employees. As the rowdatabound goes through the cycles I can see it reading the correct times from each row but it is not totalling in totalTime and I get 0:00:00 in the footer.
[Code]....
View 2 Replies
Aug 18, 2015
How to generate "Gridview1.row_bound" event in gridview?
View 1 Replies
Mar 7, 2010
I have database status field Bit(0/1) this values binding to gridview column. i want to show record status instead of 0 and 1 display open or close
View 5 Replies
Dec 20, 2010
I have a Gridview which contains templated column that has 5 checkboxes in it. When you click on one checkbox, I want to uncheck the other 4.
I am using the Item Template for this. I don't want the user to have to Select a row, before clicking on the checkboxes. Here is my non-working code to uncheck the other checkboxes. I realize it's not "SelectedRow" that I want since there's no selected row, so how do I find the row containing the checkbox that fired off CheckChanged?
[code]....
View 2 Replies
Aug 5, 2010
I've got a gridview that returns student order history which works just fine. It pulls the StudentId from a hidden field on page load. I have a link button that ADDS AN ORDER when clicked. It calls a stored procedure, inserts the record, then rebinds the gridview and displays the new record at the top of the list.
Problem is when I go to EDIT it, i get this error... "The GridView 'GridViewOrderHistory' fired event RowEditing which wasn't handled." But the interesting thing is the error doesn't occur if I close the browser and reload the page and then click on that new record that was created. Obviously I'm missing something in my code when the new order is created. Here are the 2 subs involved in the process.
[Code]....
View 8 Replies
Jul 21, 2010
since APS.Net 4.0 I have a curious problem with an event.
There is a FormView and inside of the EditItem there is a GridView. In the Footer of the GridView I put Controls for inserting records.
But when I fire a markup defined RowCommand of that GridView then the same event is getting fired for the Parent FormView. First I had 'Insert' as the CommandName and so I was getting the Error that my FormView had to be in insert mode to insert a record. Then I changed the RowCommand of the GridView to 'xxx' and I got also the RowCommand 'xxx' at the RowCommand eventhandler of the Parent FormView.
The project was migrated from .Net 3.5 a few days ago, but nothing was manually changed in the code/markup. And the problem was not there with the "old" framework.
[Code]....
Of course, I could simply change the CommanName of the LinkButton e.g. to 'InsertChild' but I would like to know:
Is this a known change or a bug of ASP.Net 4.0?
View 1 Replies
Aug 28, 2013
I know the way how to find the value of a control in gridview RowDataBound()
as
<asp:Label ID="ControlId" runat="server" Text='<%#Eval("Field") %>'></asp:Label>
in RowDataBound() i can access the value as
Label lbl= (Label)e.Row.FindControl("ControlId");
But ,I want to access the value in gridview RowDataBound()
as
var value=eval("Field")
Is there any way doing like this ....
View 1 Replies
Oct 28, 2010
So I have a GridView control with autogenerated column set to true, it also has autogenerated Edit and Delete buttons, sorting and paging, and also I am binding this same gridview to multiple data sources at runtime. All is working well.
Now I am adding a dynamically generated footer row at runtime. This footer row will allow users to add new record regardless which data source it binds to. So it is working as well except there's a small bug I couldn't figure out why. It's when I navigate to the last page of the gridview, if the rows on the last page is less than the page size, for example, I have page size 10 and the rows in last page is 9, then when I click the 'Add' linkbutton, the Add event does not fire, instead, it fill the last page with additional blank rows, that means if the last page has 5 rows, it will fill 5 blank rows below, if it has 9 rows, it will fill 1 blank row below. Then if you click the add again, it will work. If the last page already has 10 rows then, it works just fine.
Below is the code I used to dynamically add footer row:
[Code]....
View 9 Replies
Dec 4, 2013
I have a Master/Slave GrisViews or some say Parent/Child GridViews.
i want to set my button visible=false in the child gridview if data is not exist.
i try this:
Protected Sub gv_child_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs)
If e.Row.RowType = DataControlRowType.DataRow Then
e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#FFC080';")
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='';")
Dim lblitemid As Label = CType(e.Row.Cells(1).Controls(1), Label)
Dim lblphoto As Label = CType(e.Row.Cells(11).Controls(1), Label)
[Code]......
but it does not working. the button is still there.
View 1 Replies
Jul 30, 2013
On Row databound i want to show some rows in If and Hide in some rows in else conditon. But it generate an exception that (Index was out of range. Must be non-negative and less than the size of the collection Parameter name: index.
protected void gvHotels_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataTable dt = new DataTable();
if (e.Row.RowType == DataControlRowType.DataRow)
[code]...
View 1 Replies
Jul 17, 2015
I have a gridview, I would like to call an event gridview rowdatabound on button click, but in gridview are edittemplate that uses textbox.
Is when I can call event RowDataBound on button click, edittemplate value in gridview can calculate?
here's my code
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {
decimal d1 = 0, d1e = 0, d2e = 0, d3e = 0, d4e = 0, d5e = 0, d6e = 0, d7e = 0, d8e = 0;
decimal d1f = 0, d2f = 0, d3f = 0, d4f = 0, d5f = 0, d6f = 0, d7f = 0, d8f = 0;
decimal tv = 0;
decimal harga = 0;
decimal totalval = 0;
[CODE]
View 1 Replies
Dec 20, 2010
I am populating the gridview on the basis of listbox selection . However, I am setting the datasource in the click event after listbox entry. When i am trying to update any record in the gridview this error gets thrown because the datasourceid from the aspx page has been removed. Code for reference -
protected void btn_save_Click(object sender, EventArgs e)
{
ArrayList list = new ArrayList();
foreach (object o in ListBox2.Items)
{
list.Add(o);
}
string str2 = null, str, host;
string str1 = "SELECT SYSTEMNAME, DATETIME, PDOWNTIME, UDOWNTIME, SYSDOWNMINS, REASON FROM PLANNED_DOWNTIME where ";
host = Convert.ToString(list[0]);
str2 = " ( SYSTEMNAME like '" + host + "'";
for (int i = 1; i < list.Count; i++)
{
host = Convert.ToString(list[i]);
str2 = str2 + " or SYSTEMNAME LIKE'" + host + "'";
}
str = str1 + str2 + " )";
string connectstring = "Data Source=SRCPA035\ovops;Initial Catalog=reporter;Persist Security Info=True;User ID=sa;Password=ril123";
DataTable dt = new DataTable();
SqlConnection connection = new SqlConnection(connectstring);
try
{
connection.Open();
SqlCommand sqlCmd = new SqlCommand(str, connection);
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
sqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
GridView1.DataSource = SqlDataSource1;
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Fetch Error:";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
connection.Close();
}
}
View 6 Replies
Nov 17, 2010
If the grid column is clicked to sort i dont want to retireve data agian, i can get it from viewstate, but i dont know if that triggered the post back or if the ImageButton on the page triggered it
View 5 Replies