<ig:webdatagrid ID="dbGridUnit" runat="server" Width="815px" DataKeyFields="UnitNo" AutoGenerateColumns="False" Height="300px" StyleSetName="Office2007Blue"> <Columns> <ig:BoundDataField DataFieldName="UnitNo" Key="UnitNo" Width="65px"><Header Text="Unit #" /></ig:BoundDataField> <ig:BoundDataField DataFieldName="Revision" Key="Revision" Width="55px"><Header Text="Rev" /></ig:BoundDataField> <ig:BoundDataField DataFieldName="Description" Key="Description" Width="180px"><Header Text="Unit Description" /></ig:BoundDataField> <ig:BoundDataField DataFieldName="UnitShn" Key="UnitShn" Width="120px"><Header Text="Cust.Unit # Shn" /></ig:BoundDataField> <ig:BoundDataField DataFieldName="UnitOpp" Key="UnitOpp" Width="120px"><Header Text="Cust.Unit # Opp" /></ig:BoundDataField> <ig:BoundDataField DataFieldName="WDNo" Key="WDNo" Width="65px"><Header Text="WD #" /></ig:BoundDataField> <ig:BoundDataField DataFieldName="ZoneNo" Key="ZoneNo" Width="65px"><Header Text="Zone #" /></ig:BoundDataField> <ig:BoundDataField DataFieldName="StationNo" Key="StationNo" Width="70px"><Header Text="Station #" /></ig:BoundDataField> <ig:BoundDataField DataFieldName="Data" Key="Data" Hidden="true" HtmlEncode="true" Width="40px"></ig:BoundDataField> <ig:BoundDataField DataFieldName="DBType" Key="DBType" Hidden="true" HtmlEncode="true" Width="40px"></ig:BoundDataField> </Columns> <Behaviors> <ig:Activation Enabled="true" /> <ig:Selection RowSelectType="Multiple" Enabled="true" /> <ig:Paging PagerAppearance="Bottom" PageSize="10" Enabled="true" /> <ig:Sorting SortingMode="Single" Enabled="true" /> <ig:ColumnMoving Enabled="true" /> <ig:ColumnResizing Enabled="true" /> <ig:EditingCore> <Behaviors>
<ig:RowAdding Alignment="Top" EditModeActions-EnableF2="true" EditModeActions-EnableOnActive="true" EditModeActions-MouseClick="Single" Enabled="true" > <EditModeActions EnableOnActive="True" MouseClick="Single" /> </ig:RowAdding> <ig:RowDeleting Enabled="true" /> <ig:RowEditingTemplate> <EditModeActions EnableF2="True" RowSelectorMouseClick="Single" /> </ig:RowEditingTemplate> <ig:CellEditing Enabled="true"> <EditModeActions EnableF2="true" EnableOnActive="true" MouseClick="Single" /> <ColumnSettings> <ig:EditingColumnSetting ColumnKey="UnitNo" ReadOnly="true" /> </ColumnSettings> </ig:CellEditing> </Behaviors> </ig:EditingCore> <ig:Filtering Alignment="Top" Visibility="Visible" Enabled="true" AnimationEnabled="true" /> <ig:RowSelectors> </ig:RowSelectors> </Behaviors> <EditorProviders> <ig:WebTextEditProvider ID="WebTextEditProvider2" HorizontalAlign="Left" /> </EditorProviders> </ig:webdatagrid>
Code:
Protected Sub btnLoad_Click(ByVal sender As Object, ByVal e As Infragistics.WebUI.WebDataInput.ButtonEventArgs) Handles btnLoad.Click
Dt = obj.getDatatableByusp("prUnitDtlLoad", hsh)
dbGridUnit.DataSource = dt dbGridUnit.DataBind()
End
Problem for Updating and Deleting...
Thanks in Advance..
Hello Karthik,I know a couple of months have passed since you asked this question but i would be glad if i can help. I see another forum thread where you have asked this question and a reasonable suggestion has been provided - http://community.infragistics.com/forums/t/56895.aspx