ASP.NET Real World Controls

New Post: Using BulkEditGridView in Dynamic Data site

marqis — Mon, 08 Dec 2008 12:33:18 GMT

I tried using the BulkEditGridView within a dynamic data site. Everything is displayed correctly, and can be edited, only the changes are not saved to the database.

I traced the problem to BulkEditGridView.cs / AddChangedHandlers(). For the changed-handler to attach to a control, this control needs to implement IEditableTextControl, but Dynamic Data uses DynamicControl, which has no such interface. Also there seem to be no change-events available on DynamicControl.

Has anyone else encountered this problem, or does anyone know a way around this, so I can use the BulkEditGridView with Dynamic Data?

Created Issue: BulkEditGridView Checkbox Check/Uncheck All

sfhou — Wed, 10 Sep 2008 17:33:56 GMT

Greetings Intelligencia!

I'm a newbie building a web app using VS 2008, SQL Server 2000, C# .Net 2.0. I found and implemented BulkEditGridView which works great. It contains an updatable Checkbox. Now I want to add 'Check/Uncheck All' logic but I'm messing up somewhere. I tried the following:
foreach (GridViewRow row in EditableGrid.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
// Access the CheckBox
CheckBox cb = (CheckBox)row.FindControl("HasSecurity");
if (cb != null)
cb.Checked = checkState;
}
}
but DataItem is always null. Then I found RecursiveFindControl and I think maybe that's my answer but I don't know. As you can probably tell, I know only enough to be dangerous! :-)

Any/all help is greatly appreciated!

Sincerely,
Sam

P.S. Please forgive me if I am doing this wrong. I just joined the group. Let me know if I have done this the wrong way and I will fix it!

Created Issue: BulkEditGridView not working with javascript

astha — Fri, 29 Aug 2008 02:37:20 GMT

I have a bulkeditgridview on my aspx page with a checkbox column. The header of the checkbox column is a SelectAll checkbox, for which I have written an javascript function to select all the checkboxes. Now, if the javascript function is invoked and all the rows in the gridview gets modified then dirtyrows do not get created. But if I ignore the Select All checkbox at the header and just modify few/all rows manually then the bulkedit works fine.

I tried searching for BulkEditGridView + Javascript, but found nothing. I am really crushed under a stiff deadline, immediate help would really be appreciated.

Thanks!

New Post: freezing footer?

jlaius — Fri, 15 Aug 2008 21:44:25 GMT

I have got 99% of this down but can't get the proper css expression to position the footer as frozen... anybody figured this one out?

Created Issue: FrozenGridView does not allow using Sorting anymore

c_marius — Wed, 30 Jul 2008 18:56:15 GMT

As I deployed the FrozenGrid, it was impossible to make Sorting to work, at least for me!

Commented Issue: TwoHeadedGridView: when canceling changes the wrong row is editable when the page refreshes.

jhilden — Tue, 15 Jul 2008 20:02:03 GMT

create a TwoHeadedGridView and then create an onUpdating EventHandler. In the onUpdating delegate set e.cancel = true. When you go to edit the 5th row in the gridview and hit the update button the onUpdating event will cancel the update and when the page comes back instead of the 5th row being open to editing the 4th row is open.
Comments: ** Comment from web user: jhilden **

sorry, my last attachment was missing an if statement. corrected attachment is up now.

Commented Issue: TwoHeadedGridView: when canceling changes the wrong row is editable when the page refreshes.

jhilden — Tue, 15 Jul 2008 19:58:27 GMT

The current code creates the 2nd header on the OnDataBound event. I fixed this issue by creating the 2nd header in the onRowCreated event.

Created Issue: TwoHeadedGridView: when canceling changes the wrong row is editable when the page refreshes.

jhilden — Tue, 15 Jul 2008 19:55:57 GMT

NEW POST: Dynamically Binding Error

pacifistk — Thu, 22 May 2008 13:44:37 GMT

Error Message: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control

I have the following TemplateField:
<asp:TemplateField HeaderText="Style">
    <EditItemTemplate>
        <asp:DropDownList ID="ddlAssetStyle" runat="server" DataSourceID="SqlDataSourceAssetStyle"
            DataTextField="StyleNme" DataValueField="id_AssetStyle" SelectedValue='<%# Bind("AssetStyleID") %>'
                        AppendDataBoundItems="true" EnableViewState="true">
                    </asp:DropDownList>
                <asp:SqlDataSource ID="SqlDataSourceAssetStyle" runat="server" SelectCommand="p_Data"
            SelectCommandType="StoredProcedure" ConnectionString="<%$ ConnectionStrings:Dev01ConnectionString %>">
        </asp:SqlDataSource>
    </EditItemTemplate>
</asp:TemplateField>

This is the only column that is data bound and must be causing the error. This field works fine with a normal GridView.
I bind the gridview programmatically using a LINQ query.

Thanks in advance.

NEW POST: Help with OnRowUpdating

MayFisto — Sat, 10 May 2008 00:02:33 GMT

121212

judahr wrote:
Few things to check:
1. Make sure DataKeys is set.
2. Make sure the overridden Gridview you are using has the following:
a. OnRowUpdating has to explicitly call this.ExtractRowValues(e.NewValues, this.Rowse.RowIndex, true, true);
b. I also use this and call it from OnRowUpdating:
private void PopulateRowValueKeys(IOrderedDictionary Keys, int RowIndex)
{
foreach (string DataKeyName in this.DataKeyNames)
{
if (this.DataSource is DataView)
{
DataView dv = this.DataSource as DataView;
Keys.Add(DataKeyName, dvRowIndex DataKeyName);
}
else if (this.DataSource is DataTable)
{
DataTable dv = this.DataSource as DataTable;
Keys.Add(DataKeyName, dv.RowsRowIndex DataKeyName);

}
}

}

CREATED ISSUE: expression() statements are supported only in IE and not in Firefox

Sivi — Thu, 17 Apr 2008 15:37:44 GMT

I downloaded the FrozenGridView and tested it. The code "expression(this.offsetParent.Top)" is supported only in IE but not in Firefox. Is there any workaround for this piece of code to make it work in FireFox.

NEW POST: BulkEditGridView + InsertRows + Current Row Index by Container.DataItemIndex

pulla — Tue, 08 Apr 2008 08:08:26 GMT

I am using the GridView for editing multiple lines. Basically the whole thing works fine. It displays the lines from the datasource plus a certain number of insert lines. Perfect. But there is one think which I could not solve till now.

Following, I have a column with an image button. If I click on the button I call a javascript function. I want to provide the current row index to the function. It looks like this:

<controls:BulkdEditGridView ID="GridView" runat="server" DataSourceID="ObjDataSource" AutoGenerateColumns="false" ...>
<Columns>
...
<asp:TemplateField>
<itemtemplate>
<img id="imgBtn" alt="Some Text" src="/at.gv.noe/Images/Delete.gif" onclick="DoSomething(<%# Container.DataItemIndex + (GridView.ShowHeader ? 1 : 0) %>)" />
</itemtemplate>
</asp:TemplateField>
...
</Columns>
</controls:BuilEditGridView>

So If I click on line 2 the function is called with parameter value 2. That is want I want to have. But it does not work if I click on an Insert Row. That means for instance I set the insertrowcount to 5 and I get 5 additional lines. If I click on one of the insert lines the Container.DataItemIndex always returns something like undefined. But never the actual RowIndex.

How can I solve this?

br
Thomas

NEW POST: ASP.Net Ajax 2.0

pulla — Tue, 08 Apr 2008 07:52:10 GMT

I don't know if this issue is still pending. However, I had the same issue.

Following, the AddChangedHandler ist called by InitializeRow. For each row you call AddChangeHandler with its controls. But in case of an Update Panel the controls do not exist yet. Therefore, I take the concrete row from the InnerTable instead. If you access the Controls from the InnerTable all Controls are present.

Hope this helps.

br
Thomas

COMMENTED ISSUE: Insert Row Dropdowns Not Populating

r_jitu — Thu, 03 Apr 2008 15:01:39 GMT

I want to use the insert row, but it will not populate my drop down lists with any values. It will actually insert a row, but I need the drop down lists populated. Any ideas?
Comments: ** Comment from web user: r_jitu **

Finally got the dropdown solution.

using System;
using System.Collections.Generic;
using System.Text;
using System.Web.UI.WebControls;
using System.Web.UI;
using System.Collections;

namespace ABC
{
public class DropDownField : BoundField
{
//DataSourceView dataView;

#region Properties

public string ListDataTextField
{
get
{
object val = this.ViewState["ListDataTextField"];
if (null == val)
{
return String.Empty;
}

return (string)val;
}
set
{
if (0 != String.CompareOrdinal(value, this.ListDataTextField))
{
this.ViewState["ListDataTextField"] = value;
base.OnFieldChanged();
}
}
}

public string ListDataValueField
{
get
{
object val = this.ViewState["ListDataValueField"];
if (null == val)
{
return String.Empty;
}

return (string)val;
}
set
{
if (0 != String.CompareOrdinal(value, this.ListDataValueField))
{
this.ViewState["ListDataValueField"] = value;
base.OnFieldChanged();
}
}
}

[IDReferenceProperty(typeof(DataSourceControl)), Themeable(false)]
public string ListDataSourceID
{
get
{
object val = this.ViewState["ListDataSourceID"];
if (null == val)
{
return String.Empty;
}

return (string)val;
}
set
{
if (0 != String.CompareOrdinal(value, this.ListDataSourceID))
{
this.ViewState["ListDataSourceID"] = value;
base.OnFieldChanged();
}
}
}

#endregion

protected override object GetDesignTimeValue()
{
return 0;
}

protected override void InitializeDataCell(DataControlFieldCell cell, DataControlRowState rowState)
{
if ((!this.ReadOnly && (0 != (rowState & DataControlRowState.Edit)))
|| 0 != (rowState & DataControlRowState.Insert))
{
DropDownList ddl = new DropDownList();
ddl.ToolTip = this.HeaderText;
//ddl.ID = "ddlList";

if (!String.IsNullOrEmpty(this.DataField) && 0 != (rowState & DataControlRowState.Edit))
{
ddl.Load += new EventHandler(ddl_Load);
ddl.DataBinding += new EventHandler(HandleDataBinding);
ddl.DataBound += new EventHandler(HandleDataBound);
}

cell.Controls.Add(ddl);
}
else if (!String.IsNullOrEmpty(this.DataField))
{
Label lbl = new Label();
lbl.DataBinding += new EventHandler(HandleDataBinding);
cell.Controls.Add(lbl);
}
}

public override void ExtractValuesFromCell(System.Collections.Specialized.IOrderedDictionary dictionary, DataControlFieldCell cell, DataControlRowState rowState, bool includeReadOnly)
{
if (cell.HasControls() && cell.Controls[0] is DropDownList)
{
DropDownList ddl = (DropDownList)cell.Controls[0];
dictionary[this.DataField] = String.IsNullOrEmpty(ddl.SelectedValue) ? null : ddl.SelectedValue;
}
}

void ddl_Load(object sender, EventArgs e)
{
Control ctrl = (Control)sender;
//ctrl.Load -= new EventHandler(ddl_Load);
if (ctrl.NamingContainer is GridViewRow && ((GridViewRow)ctrl.NamingContainer).DataItem == null && ((GridViewRow)ctrl.NamingContainer).RowState == (DataControlRowState.Edit | DataControlRowState.Insert))
{ // databind list because this is insert row
ctrl.DataBind();
}
}

//void ddl_Load(object sender, EventArgs e)
//{
// Control ctrl = (Control)sender;
//}

/// <summary>
/// Callback from the datasourceview.
/// </summary>
/// <param name="data"></param>
void DataSourceCallback(IEnumerable data)
{
this.data = data;
}

IEnumerable data = null;

void HandleDataBinding(object sender, EventArgs e)
{
Control ctrl = (Control)sender;
if (null == data)
{
//Cache the data from the DataSourceControl, so that we only get the data once. If
//we just set the DataSourceID on the dropdown, the select command would get called
//once for each row.
DataSourceControl dsc = WebControlHelper.RecursiveFindControl(this.Control.NamingContainer, this.ListDataSourceID) as DataSourceControl;
if (null != dsc)
{
DataSourceView dsv = ((IDataSource)dsc).GetView("DefaultView");
dsv.Select(DataSourceSelectArguments.Empty, new DataSourceViewSelectCallback(this.DataSourceCallback));
}
}

if (ctrl is DropDownList)
{
DropDownList ddl = (DropDownList)ctrl;
ddl.DataTextField = this.ListDataTextField;
ddl.DataValueField = this.ListDataValueField;
ddl.DataSource = this.data;
}
else if (ctrl is Label)
{
Label lbl = (Label)ctrl;

DropDownList temp = new DropDownList();
temp.DataTextField = this.ListDataTextField;
temp.DataValueField = this.ListDataValueField;
temp.DataSource = this.data;
temp.Visible = false;

lbl.Controls.Add(temp);
temp.DataBind();
object rawVal = GetValue(ctrl.NamingContainer);
string val = (null == rawVal ? null : rawVal.ToString());

lbl.Text = String.Empty;
foreach (ListItem li in temp.Items)
{
if (0 == String.Compare(li.Value, val))
lbl.Text = li.Text;
}
}
}

void HandleDataBound(object sender, EventArgs e)
{
Control ctrl = (Control)sender;
if (!(ctrl.NamingContainer is GridViewRow) || ((GridViewRow)ctrl.NamingContainer).DataItem != null)
{
//string val = GetValue(ctrl.NamingContainer) as string;
string val = GetValue(ctrl.NamingContainer).ToString();
DropDownList ddl = ctrl as DropDownList;
if (null != ddl)
{
//make sure the appropriate value is selected
ListItem li = ddl.Items.FindByValue(val);
if (null != li)
{
li.Selected = true;
}
}
}
}

}
}

NEW POST: FrozenGridView in an UpdatePanel

simm0n — Tue, 01 Apr 2008 17:21:00 GMT

Hi

Has anyone managed to freeze the header of a FrozenGridView in an UpdatePanel? Mine just scrolls as in an ordinary GridView after I put it inside an UpdatePanel.

Thanks
Simon

NEW POST: DropDownField - Binding

TocydLive — Fri, 14 Mar 2008 14:01:49 GMT

I'm a new user of the Real World Controls and I'm trying to use a DropDownField in one of the columns of
a BulkEditViewControl.

The problem is that even if the drop down is populated, no value is selected when the web page was loaded and when I'm saving the BulkEditViewControl
all the other binded field are saved to the database but nothing is saved for field of type DropDownField.

Probably I'm missing something... How could I setup this field to have a selected value and save the data in his related row data item on datasource row inserting?

Here is the Aspx DropDownField declaration:

<cc1:DropDownField DataField="ClienteleTypeID" ListDataSourceID="dsClienteleType" ListDataTextField="Description"
ListDataValueField="ClienteleTypeID" HeaderText="ClienteleTypeID" SortExpression="ClienteleTypeID" >
</cc1:DropDownField>

How could I achieve databinding on DropDownField ?

Thank's a bunch!

Simon Rousseau
CSSMI

NEW POST: FrozenGridView empty when Binding to dataset.table[n]

josema — Fri, 14 Mar 2008 12:22:44 GMT

Hi,
I'm using the frozengridview as follow:

DataSet dsXml = new DataSet();
dsXml.ReadXml(new StringReader(xmlResult));
uxSearchDataResultsList.DataSource = dsXml.Tables"REGISTER";
uxSearchDataResultsList.DataBind();

That code works properly with an asp:gridview but with FrozenGridView shows empty. Debugging i've seen that CreateChildControls() returns -1.

Any suggestion for do this item working?
Thanks.

NEW POST: Error adding new columns... 'Error Invoking 'Edit Columns

jmarcum — Tue, 11 Mar 2008 13:35:35 GMT

I've attempted to use the FrozenGridView class. I've successfully registered the control in a VS2005 test website and I"m able to add the control to a webpage but when I try to add a column I receive an error message: Error invoking 'Edit Columns....' Details: The method or operation is not implemented.

As a workaround, I can take a standard Gridview control, and create the required columns. If I cut and paste the "rwg:FrozenGridView" tag prefix on to the standard gridview control, it doesn't have the above problem unless I then try to add an additional column. I can compile the page and it will render the grid, columns, data and freeze the column header as intended.

Anyone have any suggestions?

NEW POST: Response.Redirect after PostBack

UR1Down — Mon, 10 Mar 2008 17:11:10 GMT

My compliments on the RealWorlds.Grid project!!! I am attempting to do a Response.Redirect in the PostBack after the records are updated when I use the BulkEditGridView. Could you direct me to where I need to make this call?

NEW POST: Dynamic Datasource Binding, Rowupdating problem

Kythor — Mon, 10 Mar 2008 13:02:14 GMT

Hi guys, I have searched for hours and days to solve this problem, but haven't found any clear solution.

The problem is simple:

I add a SQL datasource to the bulkedit gridview at runtime. Everything works fine untill I want to save the changes.
I get the error stating that the event RowUpdating is not handled.
Some solutions say you have to build your own updating method. But I'm at a loss here.

Do I create an eventhandler for RowUpdating in the source code for BulkEditGridview, or should I do this in the code behind file of the ASPX where I use the control.

How do i get the Newvalues collection in this method?

I someone could show me some sample code, it would be most helpfull.