LinqDataSource class example
本文关键字:example class LinqDataSource | 更新日期: 2023-09-27 18:09:20
刚刚开始研究使用LinqDataSource为GridView,我正在寻找如何设置我的数据源更多的例子。
我希望以后使用它对SharePoint列表,但现在我只是在一些详细的例子,一个类,我可以检索数据和更新。
这是一个来自ms的示例类,我只是在多个示例之后,所以我更好地了解这是如何工作的。
一个简单的例子,已知是有效的,有点复杂,将是伟大的
public class MovieLibrary
{
string[] _availableGenres = { "Comedy", "Drama", "Romance" };
public MovieLibrary()
{
}
public string[] AvailableGenres
{
get
{
return _availableGenres;
}
}
}
欢呼
我使用LinqDataSource与SPGridView这是我的代码。
<SharePoint:SPGridView runat="server" ID="spgvUserTrainingLists" AutoGenerateColumns="false"
DataSourceID="linqDsEmployeeTrainingLists" DataKeyNames="RowId" OnRowDataBound="spgvUserTrainingLists_RowDataBound"
AllowSorting="true" AllowPaging="true" PageSize="15" AllowFiltering="true" FilteredDataSourcePropertyName="Where"
FilteredDataSourcePropertyFormat='{1} == "{0}"' FilterDataFields=",TrainingType,,Trainer,Status">
<Columns>
<SharePoint:SPBoundField HeaderText="Ref #" SortExpression="RefNo" DataField="RefNo" />
<SharePoint:SPBoundField HeaderText="Type" SortExpression="TrainingType" DataField="TrainingType" />
<asp:TemplateField HeaderText="Training" SortExpression="TrainingTitle">
<ItemTemplate>
<asp:HyperLink ID="hlTrainingDetail" runat="server" Text='<%# Eval("TrainingTitle") %>'
NavigateUrl="#" />
</ItemTemplate>
</asp:TemplateField>
<SharePoint:SPBoundField HeaderText="Trainer" SortExpression="Trainer" DataField="Trainer" />
<SharePoint:SPBoundField HeaderText="Status" SortExpression="Status" DataField="Status" />
<asp:TemplateField>
<ItemTemplate>
<asp:ImageButton ID="imgDelete" ImageUrl="~/_layouts/images/DELITEM.GIF" runat="server"
UseSubmitBehaviour="false" CommandValue='<%# Eval("RowId") %>' OnClientClick="javascript:DeleteTraining(this);" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EmptyDataTemplate>
No training yet.
</EmptyDataTemplate>
</SharePoint:SPGridView>
<SharePoint:SPGridViewPager ID="SPGridViewPager1" runat="server" GridViewId="spgvUserTrainingLists" />
<aspweb:LinqDataSource runat="server" ID="linqDsEmployeeTrainingLists" OnSelecting="linqDs_Selecting" />
在LinqDataSource selection事件中是发生数据绑定的地方
protected void linqDs_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
object parameter = null;
if (e.SelectParameters.TryGetValue("employee", out parameter))
{
e.Result = DefaultBLL.GetEmployeeTrainingLists(parameter.ToString());
}
}
Hope this help.