在Telerik的radgrid控件还没有附加功能 [英] No add functionality in Telerik RadGrid
问题描述
我已经加入Telerik的GridView和它连接到我的本地SQL Server数据库。问题是我看不到任何添加/插入行功能和无论是我能找到的选项来启用它。这里的radgrid控件code:
< Telerik的:radgrid控件ID =RadGrid1=服务器AllowAutomaticInserts =真AllowFilteringByColumn =真
AllowPaging =真AllowSorting =真AutoGenerateDeleteColumn =真AutoGenerateEditColumn =真
CELLSPACING =0的DataSourceID =SqlDataSource1网格=无皮=丝绸之路WIDTH =987px>
< ExportSettings ExportOnlyData =真OpenInNewWindow =真>
<全文AllowAdd =真AllowCopy =真/>
< / ExportSettings>
< MasterTableView的AutoGenerateColumns =FALSE的DataKeyNames =ID的DataSourceID =SqlDataSource1>
< CommandItemSettings ExportToPdfText =导出为PDF>< / CommandItemSettings>
< RowIndicatorColumn可见=真FilterControlAltText =过滤RowIndicator列>
< HeaderStyle宽度=20像素>< / HeaderStyle>
< / RowIndicatorColumn>
< ExpandCollapseColumn可见=真FilterControlAltText =过滤ExpandColumn列>
< HeaderStyle宽度=20像素>< / HeaderStyle>
< / ExpandCollapseColumn>
<柱体和GT;
< Telerik的:GridBoundColumn数据字段=ID数据类型=System.Int32FilterControlAltText =过滤器的ID列
的HeaderText =ID只读=真SORTEX pression =IDUniqueName =ID>
< ColumnValidationSettings>
< ModelErrorMessage文本=/>
< / ColumnValidationSettings>
< / Telerik的:GridBoundColumn>
< Telerik的:GridBoundColumn数据字段=名称FilterControlAltText =筛选器名称列的HeaderText =姓名
SORTEX pression =名称UniqueName =名称>
< ColumnValidationSettings>
< ModelErrorMessage文本=/>
< / ColumnValidationSettings>
< / Telerik的:GridBoundColumn>
< Telerik的:GridBoundColumn数据字段=形FilterControlAltText =过滤器表列的HeaderText =表
SORTEX pression =形UniqueName =表格>
< ColumnValidationSettings>
< ModelErrorMessage文本=/>
< / ColumnValidationSettings>
< / Telerik的:GridBoundColumn>
< Telerik的:GridBoundColumn数据字段=价格FilterControlAltText =过滤器价格栏的HeaderText =价
SORTEX pression =价格UniqueName =价格>
< ColumnValidationSettings>
< ModelErrorMessage文本=/>
< / ColumnValidationSettings>
< / Telerik的:GridBoundColumn>
< Telerik的:GridBoundColumn数据字段=到期数据类型=System.DateTime的FilterControlAltText =过滤到期
列的HeaderText =到期SORTEX pression =过期UniqueName =到期>
< ColumnValidationSettings>
< ModelErrorMessage文本=/>
< / ColumnValidationSettings>
< / Telerik的:GridBoundColumn>
< Telerik的:GridBoundColumn数据字段=量数据类型=System.Int32FilterControlAltText =过滤器数量
列的HeaderText =数量SORTEX pression =数量UniqueName =数量>
< ColumnValidationSettings>
< ModelErrorMessage文本=/>
< / ColumnValidationSettings>
< / Telerik的:GridBoundColumn>
< /专栏>
< EditFormSettings>
< EditColumn FilterControlAltText =过滤器EditCommandColumn列>< / EditColumn>
< / EditFormSettings>
< PagerStyle PageSizeControlType =radcombobox控件模式=滑块>< / PagerStyle>
< / MasterTableView>
< PagerStyle PageSizeControlType =radcombobox控件模式=滑块>< / PagerStyle>
< FilterMenu EnableImageSprites =FALSE>< / FilterMenu>
< / Telerik的:radgrid控件>
您可以直接在这样的ASPX添加:
< Telerik的:radgrid控件=服务器ID =RadGrid1AllowPaging =真
AllowSorting =真
的AutoGenerateColumns =FALSE
AllowAutomaticInserts =真
AllowAutomaticUpdates =真
AllowAutomaticDeletes =真ShowStatusBar =真
.........
或交替向导按图片,请选择母版页和标志的选项:
此外,请确保您生成所需的CRUD在定义的SqlConnection的参数(高级菜单,生成CRUD说明)。我不认为他们会在你的code。
在<步骤2 href=\"http://www.asp.net/web-forms/tutorials/data-access/accessing-the-database-directly-from-an-aspnet-page/inserting-updating-and-deleting-data-with-the-sqldatasource-cs\"相对=nofollow>这个文章,你会发现如何做到这一点的细节。
I have added Telerik GridView and linked it to my local sql server database. The problem is I can't see any add/insert row functionality and neither can I find the options to enable it. Here's the RadGrid code:
<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticInserts="True" AllowFilteringByColumn="True"
AllowPaging="True" AllowSorting="True" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True"
CellSpacing="0" DataSourceID="SqlDataSource1" GridLines="None" Skin="Silk" Width="987px">
<ExportSettings ExportOnlyData="True" OpenInNewWindow="True">
<Pdf AllowAdd="True" AllowCopy="True" />
</ExportSettings>
<MasterTableView autogeneratecolumns="False" datakeynames="Id" datasourceid="SqlDataSource1">
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="Id" DataType="System.Int32" FilterControlAltText="Filter Id column"
HeaderText="Id" ReadOnly="True" SortExpression="Id" UniqueName="Id">
<ColumnValidationSettings>
<ModelErrorMessage Text="" />
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Name" FilterControlAltText="Filter Name column" HeaderText="Name"
SortExpression="Name" UniqueName="Name">
<ColumnValidationSettings>
<ModelErrorMessage Text="" />
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Form" FilterControlAltText="Filter Form column" HeaderText="Form"
SortExpression="Form" UniqueName="Form">
<ColumnValidationSettings>
<ModelErrorMessage Text="" />
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Price" FilterControlAltText="Filter Price column" HeaderText="Price"
SortExpression="Price" UniqueName="Price">
<ColumnValidationSettings>
<ModelErrorMessage Text="" />
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Expiry" DataType="System.DateTime" FilterControlAltText="Filter Expiry
column" HeaderText="Expiry" SortExpression="Expiry" UniqueName="Expiry">
<ColumnValidationSettings>
<ModelErrorMessage Text="" />
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Quantity" DataType="System.Int32" FilterControlAltText="Filter Quantity
column" HeaderText="Quantity" SortExpression="Quantity" UniqueName="Quantity">
<ColumnValidationSettings>
<ModelErrorMessage Text="" />
</ColumnValidationSettings>
</telerik:GridBoundColumn>
</Columns>
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
<PagerStyle PageSizeControlType="RadComboBox" Mode="Slider"></PagerStyle>
</MasterTableView>
<PagerStyle PageSizeControlType="RadComboBox" Mode="Slider"></PagerStyle>
<FilterMenu EnableImageSprites="False"></FilterMenu>
</telerik:RadGrid>
You can either add it directly in the aspx like this:
<telerik:RadGrid runat="server" ID="RadGrid1" AllowPaging="True"
AllowSorting="True"
AutoGenerateColumns="False"
AllowAutomaticInserts="True"
AllowAutomaticUpdates="True"
AllowAutomaticDeletes="True" ShowStatusBar="True"
.........
or alternatively in the wizard as per picture, select master page and flag the options:
Moreover, make sure you generate the needed CRUD when you define the parameters of the sqlconnection (advanced menu, generate CRUD instructions). I do not see them in your code. In step 2 of this article you will find detail on how to do it.
这篇关于在Telerik的radgrid控件还没有附加功能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!