1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| <%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Grid view for test.aspx.cs" Inherits="IMM.GridViews.Grid_view_for_test" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<asp:TextBox ID="testm" runat="server" Width="85px"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Set" />
</p>
<p>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="Part_No" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="Part_No" HeaderText="Part_No" ReadOnly="True"
SortExpression="Part_No" />
<asp:BoundField DataField="Description" HeaderText="Description"
SortExpression="Description" />
<asp:BoundField DataField="SL_No" HeaderText="SL_No" SortExpression="SL_No" />
<asp:BoundField DataField="Eq_Description" HeaderText="Eq_Description"
SortExpression="Eq_Description" />
<asp:BoundField DataField="Stock_OnHand" HeaderText="Stock_OnHand"
SortExpression="Stock_OnHand" />
<asp:BoundField DataField="Standard_Qty" HeaderText="Standard_Qty"
SortExpression="Standard_Qty" />
<asp:BoundField DataField="Serv_OnHand" HeaderText="Serv_OnHand"
ReadOnly="True" SortExpression="Serv_OnHand" />
<asp:BoundField DataField="Serv_Lev 1" HeaderText="Serv_Lev 1"
SortExpression="Serv_Lev 1" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MIConnectionString %>"
SelectCommand="SELECT Part_No, Description, SL_No, Eq_Description, Stock_OnHand, Standard_Qty, Stock_OnHand / Standard_Qty AS Serv_OnHand FROM Kits">
</asp:SqlDataSource>
</p>
</asp:Content> |
Partager