Expand|Select|Wrap|Line Numbers
- <%@ Page Language="C#" AutoEventWireup="true" CodeFile="supp.aspx.cs" Inherits="temp" %>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml" >
- <head runat="server">
- <title>Untitled Page</title>
- <link href="style.css" rel="stylesheet" type="text/css" />
- <script language="javascript" type="text/javascript">
- // <!CDATA[
- function A1_onclick() {
- }
- // ]]>
- </script>
- </head>
- <body>
- <form id="form1" runat="server">
- <div id="wrapper">
- <div id="top">
- <asp:Image ID="Image1" runat="server" ImageUrl="~/image/bgtop.png" /></div>
- <div id="content" style="height: 103%">
- <div id="header">
- </div>
- <div id="bodyparts"></div>
- <div id="menu" style="width: 259px; height: 97%">
- <ul>
- <li><a href="#" style="width: 144px">Home</a></li>
- <li><a href="#" style="width: 144px">Ship</a></li>
- <li><a href="#" style="width: 144px">Global</a></li>
- <li><a href="#" style="width: 144px" id="A1" onclick="return A1_onclick()">Employee</a></li>
- <li><a href="#" style="width: 144px">Job</a></li>
- <li><a href="#" style="width: 144px">Component</a></li>
- <li><a href="#" style="width: 144px" id="A2">Repair</a></li>
- </ul>
- </div>
- <a href="http://validator.w3.org/check?uri=referer"></a>
- <br />
- <br />
- <br />
- <br />
- <br />
- <br />
height: 276px; background-color: #99ccff; border-left-color: #ffffff; border-bottom-color: #ffffff; border-top-style: none; border-top-color: #ffffff; border-right-style: none; border-left-style: none; border-right-color: #ffffff; border-bottom-style: none;">
<div style="z-index: 101; left: 2px; width: 303px; position: absolute; top: 52px;
height: 217px">
<br />
<asp:Label ID="already" runat="server" ForeColor="Blue" Text="Label" Visible="False"
Width="133px"></asp:Label><br />
<asp:Label ID="Label6" runat="server" Font-Bold="True" Font-Size="Small" ForeColor="#C04000"
Text="Supplier Code" Font-Names="Palatino Linotype"></asp:Label>
<asp:TextBox ID="scode" runat="server" Width="144px"></asp:TextBox>
<br />
<br />
<asp:Label ID="Label7" runat="server" Font-Bold="True" Font-Size="Small" ForeColor="#C04000"
Text="Supplier Name" Font-Names="Palatino Linotype"></asp:Label>
<asp:TextBox ID="sname" runat="server" Width="144px"></asp:TextBox><br />
<br />
<asp:TextBox ID="addr" runat="server" Height="27px" TextMode="MultiLine" Width="148px"></asp:TextBox><br />
<div style="z-index: 101; left: 9px; width: 88px; position: absolute; top: 124px;
height: 23px">
<asp:Label ID="label" runat="server" Font-Bold="True" Font-Size="Small" ForeColor="#C04000"
Text="Address" Width="48px" Font-Names="Palatino Linotype"></asp:Label></div>
<br />
<asp:Label ID="Label14" runat="server" Font-Bold="True" Font-Size="Small" ForeColor="#C04000"
Text="State" Font-Names="Palatino Linotype"></asp:Label>
<asp:TextBox ID="state" runat="server" Width="144px"></asp:TextBox>
</div>
<div style="z-index: 102; left: 213px; width: 234px; position: absolute; top: 14px; height: 30px">
<asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Italic="False" Font-Size="16pt"
ForeColor="Navy" Text="Supplier Details" Font-Names="Palatino Linotype"></asp:Label></div>
<div style="font-size: 12pt; z-index: 105; left: 302px; width: 272px; color: #000000;
position: absolute; top: 45px; height: 103px">
<br />
<br />
<asp:Label ID="Label15" runat="server" Font-Bold="True" Font-Size="Small" ForeColor="#C04000"
Text="Country" Font-Names="Palatino Linotype"></asp:Label>
<asp:DropDownList ID="DropDownList1" runat="server" Width="146px">
</asp:DropDownList><br />
<br />
<asp:Label ID="Label16" runat="server" Font-Bold="True" Font-Size="Small" ForeColor="#C04000"
Text="Zip Code" Font-Names="Palatino Linotype"></asp:Label>
<asp:TextBox ID="zip" runat="server" Width="144px"></asp:TextBox><br />
<br />
<asp:Label ID="Label17" runat="server" Font-Bold="True" Font-Size="Small" ForeColor="#C04000"
Text="Phone No." Font-Names="Palatino Linotype"></asp:Label>
<asp:TextBox ID="phone" runat="server" Width="144px"></asp:TextBox><br />
<br />
<asp:Label ID="Label18" runat="server" Font-Bold="True" Font-Size="Small" ForeColor="#C04000"
Text="Email" Font-Names="Palatino Linotype"></asp:Label>
<asp:TextBox ID="email" runat="server" Width="144px"></asp:TextBox><br />
<br />
<asp:Label ID="Label19" runat="server" Font-Bold="True" Font-Size="Small" ForeColor="#C04000"
Text="WebSite" Font-Names="Palatino Linotype"></asp:Label>
<asp:TextBox ID="web" runat="server" Width="144px"></asp:TextBox>
</div>
<div id="DIV1" onclick="return DIV1_onclick()" style="font-size: 12pt; z-index: 104;
left: 141px; width: 284px; position: absolute; top: 280px; height: 46px">
<br />
<asp:Button ID="addbtn" runat="server" BackColor="SteelBlue" Font-Bold="True"
Font-Size="Medium" ForeColor="White" Height="29px" OnClick="addbtn_Click1" Text="Add"
Width="70px" Font-Names="Times New Roman" />
<asp:Button ID="editbtn" runat="server" BackColor="SteelBlue" Font-Bold="True"
Font-Size="Medium" ForeColor="White" Height="29px" OnClick="editbtn_Click1" Text="Edit"
Width="70px" Font-Names="Times New Roman" /> <asp:Button ID="deletebtn" runat="server" BackColor="SteelBlue"
Font-Bold="True" Font-Size="Medium" ForeColor="White" Height="29px" OnClick="deletebtn_Click1"
Text="Delete" Width="70px" Font-Names="Times New Roman" /></div>
</div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div style="z-index: 103; left: 311px; width: 433px; position: absolute; top: 688px;
height: 148px">
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="scode"
DataSourceID="SqlDataSource1" Font-Names="Times New Roman" Visible="False">
<Columns>
<asp:BoundField DataField="scode" HeaderText="scode" ReadOnly="True" SortExpression="scode" />
<asp:BoundField DataField="sname" HeaderText="sname" SortExpression="sname" />
<asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
<asp:BoundField DataField="state" HeaderText="state" SortExpression="state" />
<asp:BoundField DataField="country" HeaderText="country" SortExpression="country" />
<asp:BoundField DataField="zipcode" HeaderText="zipcode" SortExpression="zipcode" />
<asp:BoundField DataField="phone" HeaderText="phone" SortExpression="phone" />
<asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
<asp:BoundField DataField="website" HeaderText="website" SortExpression="website" />
<asp:CommandField ShowDeleteButton="True" />
</Columns>
</asp:GridView>
</div>
<br />
<br />
<br />
<br />
<br />
<br />
<div style="z-index: 102; left: 312px; width: 100px; position: absolute; top: 668px;
height: 100px">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="scode"
DataSourceID="SqlDataSource1" Font-Names="Times New Roman" Visible="False">
<Columns>
<asp:BoundField DataField="scode" HeaderText="scode" ReadOnly="True" SortExpression="scode" />
<asp:BoundField DataField="sname" HeaderText="sname" SortExpression="sname" />
<asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
<asp:BoundField DataField="state" HeaderText="state" SortExpression="state" />
<asp:BoundField DataField="country" HeaderText="country" SortExpression="country" />
<asp:BoundField DataField="zipcode" HeaderText="zipcode" SortExpression="zipcode" />
<asp:BoundField DataField="phone" HeaderText="phone" SortExpression="phone" />
<asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
<asp:BoundField DataField="website" HeaderText="website" SortExpression="website" />
<asp:CommandField ShowEditButton="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:pmsConnectionString6 %>"
DeleteCommand="DELETE FROM supplier WHERE (scode = @scode)" InsertCommand="INSERT INTO supplier(scode, sname, address, state, country, zipcode, phone, email, website) VALUES (@scode, @sname, @address, @state, @country, @zipcode, @phone, @email, @website)"
SelectCommand="select * from supplier" UpdateCommand="UPDATE supplier SET sname = @sname, address = @address, state = @state, country = @country, zipcode = @zipcode, phone = @phone, email = @email, website = @website WHERE (scode = @scode)">
<DeleteParameters>
<asp:Parameter Name="scode" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="sname" />
<asp:Parameter Name="address" />
<asp:Parameter Name="state" />
<asp:Parameter Name="country" />
<asp:Parameter Name="zipcode" />
<asp:Parameter Name="phone" />
<asp:Parameter Name="email" />
<asp:Parameter Name="website" />
<asp:Parameter Name="scode" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="scode" />
<asp:Parameter Name="sname" />
<asp:Parameter Name="address" />
<asp:Parameter Name="state" />
<asp:Parameter Name="country" />
<asp:Parameter Name="zipcode" />
<asp:Parameter Name="phone" />
<asp:Parameter Name="email" />
<asp:Parameter Name="website" />
</InsertParameters>
</asp:SqlDataSource>
</div>
<br />
<br />
<br />
<br />
<br />
</div>
<div id="content"></div>
<asp:Image ID="Image2" runat="server" ImageUrl="~/image1/bgbottom.png" /></div>
</form>
</body>
</html>
[/code]