Hello
In my webgrid, when i set the Multiple Data Key Fields, can not cause the updatecell event to fire
<igtbl:UltraWebGrid ID="UltraWebGrid1" runat="server" Height="200px" Width="325px" DataKeyField="CurrencyCode,ChangeDate" onupdatecell="UltraWebGrid1_UpdateCell"> <bands> <igtbl:UltraGridBand DataKeyField="CurrencyCode,ChangeDate" > <Columns> <igtbl:UltraGridColumn AllowUpdate="No" BaseColumnName="CurrencyCode" IsBound="True" > </igtbl:UltraGridColumn> <igtbl:UltraGridColumn AllowUpdate="No" BaseColumnName="ChangeDate" IsBound="True" DataType="System.DateTime"> <Footer> <RowLayoutColumnInfo OriginX="1" /> </Footer> <Header> <RowLayoutColumnInfo OriginX="1" /> </Header> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn BaseColumnName="Rate" IsBound="True" DataType="System.Decimal"> <Footer> <RowLayoutColumnInfo OriginX="2" /> </Footer> <Header> <RowLayoutColumnInfo OriginX="2" /> </Header> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn BaseColumnName="Memo" IsBound="True" > <Footer> <RowLayoutColumnInfo OriginX="3" /> </Footer> <Header> <RowLayoutColumnInfo OriginX="3" /> </Header> </igtbl:UltraGridColumn> </Columns> <addnewrow view="NotSet" visible="NotSet"> </addnewrow> </igtbl:UltraGridBand> </bands> <displaylayout allowcolsizingdefault="Free" allowcolumnmovingdefault="OnServer" allowdeletedefault="Yes" allowsortingdefault="OnClient" allowupdatedefault="Yes" bordercollapsedefault="Separate" headerclickactiondefault="SortMulti" name="UltraWebGrid1" rowheightdefault="20px" rowselectorsdefault="No" selecttyperowdefault="Extended" stationarymargins="Header" stationarymarginsoutlookgroupby="True" tablelayout="Fixed" version="4.00" viewtype="OutlookGroupBy" CellClickActionDefault = "Edit" > <framestyle backcolor="Window" bordercolor="InactiveCaption" borderstyle="Solid" borderwidth="1px" font-names="Microsoft S***rif" font-size="8.25pt" height="200px" width="325px"> </framestyle> <pager minimumpagesfordisplay="2"> <PagerStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px"> <borderdetails colorleft="White" colortop="White" widthleft="1px" widthtop="1px" /> </PagerStyle> </pager> <editcellstyledefault borderstyle="None" borderwidth="0px"> </editcellstyledefault> <footerstyledefault backcolor="LightGray" borderstyle="Solid" borderwidth="1px"> <borderdetails colorleft="White" colortop="White" widthleft="1px" widthtop="1px" /> </footerstyledefault> <headerstyledefault backcolor="LightGray" borderstyle="Solid" horizontalalign="Left"> <borderdetails colorleft="White" colortop="White" widthleft="1px" widthtop="1px" /> </headerstyledefault> <rowstyledefault backcolor="Window" bordercolor="Silver" borderstyle="Solid" borderwidth="1px" font-names="Microsoft S***rif" font-size="8.25pt"> <padding left="3px" /> <borderdetails colorleft="Window" colortop="Window" /> </rowstyledefault> <groupbyrowstyledefault backcolor="Control" bordercolor="Window"> </groupbyrowstyledefault> <groupbybox> <boxstyle backcolor="ActiveBorder" bordercolor="Window"> </boxstyle> </groupbybox> <addnewbox hidden="False"> <boxstyle backcolor="Window" bordercolor="InactiveCaption" borderstyle="Solid" borderwidth="1px"> <borderdetails colorleft="White" colortop="White" widthleft="1px" widthtop="1px" /> </boxstyle> </addnewbox> <activationobject bordercolor="" borderwidth=""> </activationobject> <filteroptionsdefault> <filterdropdownstyle backcolor="White" bordercolor="Silver" borderstyle="Solid" borderwidth="1px" customrules="overflow:auto;" font-names="Verdana,Arial,Helvetica,s***rif" font-size="11px" height="300px" width="200px"> <padding left="2px" /> </filterdropdownstyle> <filterhighlightrowstyle backcolor="#151C55" forecolor="White"> </filterhighlightrowstyle> <filteroperanddropdownstyle backcolor="White" bordercolor="Silver" borderstyle="Solid" borderwidth="1px" customrules="overflow:auto;" font-names="Verdana,Arial,Helvetica,s***rif" font-size="11px"> <padding left="2px" /> </filteroperanddropdownstyle> </filteroptionsdefault> </displaylayout> </igtbl:UltraWebGrid>
--------------------------------------------------------------------------------------------------------------------------
private DataSet _Data;private SqlCommand SelectCommand1;private SqlConnection con;private SqlDataAdapter da;
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ExpenseLineConnectionString3"].ConnectionString); _Data = new DataSet(); da = new SqlDataAdapter(); SelectCommand1 = new SqlCommand(); this.SelectCommand1.Connection = con; this.SelectCommand1.CommandText = "SELECT CurrencyCode,ChangeDate,Rate,Memo FROM TCurrencyRate"; this.da.SelectCommand = this.SelectCommand1; this.da.Fill(this._Data);
UltraWebGrid1.DataSource = _Data.Tables[0].DefaultView; this.UltraWebGrid1.DataBind(); } } protected void UltraWebGrid1_UpdateCell(object sender, Infragistics.WebUI.UltraWebGrid.CellEventArgs e) { string aa = ((object[])e.Cell.Row.DataKey)[0].ToString() + ((object[])e.Cell.Row.DataKey)[1].ToString();
}
Hello,
That's no use for this problem.
In my webgrid, when i set the Data Key Fields to "CurrencyCode" or "ChangeDate", the updatecell method fired successfully.
Obviously,the data can not be updated correctly,because the Key has only single.
And when UltraWebGrid1.Bands[0].DataKeyField = "CurrencyCode,ChangeDate"; is used ,the method can not fire.
Hi,
Add the following line in InitializeComponent() mothod of page.
UltraWebGrid1.UpdateCell += new UpdateCellEventHandler(UltraWebGrid1_UpdateCell);
Also set ALLOWUPDATEDEFAULT="Yes" for the grid
Is anyone here?
I have been puzzling ablout this question for one week.
Help me please.