我正在与Oracle 10.2.0.4集成的ASP.net 4.0
这是我的GridView及其SqlDatasource代码
<asp:GridView ID="gvRegNumber" runat="server" AutoGenerateColumns="False" DataSourceID="DsRegNumberGrid"
Width="100%" AllowPaging="True" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid"
BorderWidth="3px" CellSpacing="2" ForeColor="Black" PageSize="3"
CssClass="mGrid" onrowcommand="gvRegNumber_RowCommand" >
<Columns>
<asp:BoundField DataField="Registration No." HeaderText="Registration No." SortExpression="Registration No." />
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Make" HeaderText="Make" SortExpression="Make" />
<asp:BoundField DataField="Model" HeaderText="Model" SortExpression="Model" />
<asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" />
<asp:BoundField DataField="From Date" HeaderText="From Date" SortExpression="From Date" />
<asp:BoundField DataField="To Date" HeaderText="To Date" SortExpression="To Date" />
<asp:TemplateField>
<EditItemTemplate>
<asp:ImageButton ID="imgbtnUpdate" CommandName="Update" runat="server" ImageUrl="~/Themes/Icons/edit_icon.png"
ToolTip="Update" Height="20px" Width="20px" />
</EditItemTemplate>
<HeaderTemplate>
<asp:Label ID="Edit" Text="Edit" runat="server"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:ImageButton ID="EditRow" CssClass="mGrid-edit" ImageUrl="~/Themes/Icons/edit_icon.png"
runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>
<asp:Label ID="Delete" Text="Edit" runat="server"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:ImageButton ID="DeleteRow" CssClass="mGrid-delete" ImageUrl="~/Themes/Icons/delete_icon.png"
runat="server" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="DsRegNumberGrid" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT "fkEnumerationId" AS "Registration No.", "Text" AS "Name", "AdditionalValueText" AS "Make", "AdditionalValue" AS "Model", "IsActive" AS "Status", "CreatedOn" AS "From Date", "LastUpdatedOn" AS "
;To Date" FROM "EnumerationValue"">
</asp:SqlDataSource>
我只想为网格中的单独列提供单独的数据源。那可能吗?如果是这样,怎么办?
提前致谢。
你可以在你的SP中做到这一点
select en1.text as 'Country', en2.text as 'City',en3.text as 'Region' from
EnumValue en1, EnumValue en2, EnumValue en3
where en1.id = en2.[fkEnumeration] and en3.[fkEnumeration] = en2.id and
en1.id='yourid' ;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句