Advertisement
| Hall of Fame |
|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
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: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: |
<%@ Page Language="VB" Debug="True" %>
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI" TagPrefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Protected Sub DetailsView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewPageEventArgs)
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
End Sub
Protected Sub SqlDataSource2_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs)
End Sub
Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged
Me.HyperLink1.NavigateUrl = "~/products_EMail.aspx?RecordID2=" & GridView1.DataKeys(GridView1.SelectedIndex).Value.ToString
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Product Inquiry</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Panel ID="Panel1" runat="server" Height="1px" Width="850px" style="left: 4px; position: absolute; top: 10px;">
<asp:Label ID="Label3" runat="server" Font-Bold="True" Font-Size="Small" Style="font-weight: bold;font-size: 12pt; color: darkblue; font-style: normal; font-family: verdana;" Text="Search for:" Width="104px"></asp:Label>
<asp:TextBox ID="TextBox2" runat="server" Width="316px"></asp:TextBox>
<asp:Button ID="Button2" runat="server"
Text="Go..." Width="84px" style="position: absolute; top: 1px" /><br />
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox2"
ErrorMessage="(Search Box cannot be Blank...)" SetFocusOnError="True"></asp:RequiredFieldValidator>
<br />
<asp:UpdatePanel ID="UpdatePanel1" runat="server"><ContentTemplate>
<asp:Label ID="Label4" runat="server" Font-Bold="True" Font-Size="Small" Style="font-weight: bold;font-size: 10pt; color: darkblue; font-style: normal; font-family: verdana;" Text="Total Records found:" Width="176px"></asp:Label><br />
<br />
<asp:Image ID="Image2" runat="server" ImageUrl="~/images/summary-banner.jpg" /><br />
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CellPadding="2" DataSourceID="SqlDataSource2" ForeColor="#333333"GridLines="None" DataKeyNames="RecordID"OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
<PagerSettings FirstPageImageUrl="~/images/first-record.bmp" FirstPageText="First Page..." LastPageImageUrl="~/images/last-record.bmp" LastPageText="Last Page..." Mode="NextPreviousFirstLast"
NextPageImageUrl="~/images/next-record.bmp" NextPageText="Next Page..." Position="Top" PreviousPageImageUrl="~/images/previous-record.bmp" PreviousPageText="Previous Page..." />
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" /
<Columns><asp:CommandField SelectText="Details" ShowSelectButton="True">
<HeaderStyle BackColor="#C00000" Font-Bold="True" Font-Size="X-Small" HorizontalAlign="Left"Width="30px" Wrap="False" />
<ItemStyle Font-Bold="True" Font-Size="X-Small" HorizontalAlign="Left" Width="30px"Wrap="False" />
</asp:CommandField>
<asp:BoundField DataField="CTCATALOG" HeaderText="Catalog" SortExpression="CTCATALOG">
<HeaderStyle BackColor="#C00000" Font-Bold="True" Font-Size="X-Small" HorizontalAlign="Left"
Width="200px" Wrap="False" />
<ItemStyle Font-Bold="True" Font-Size="X-Small" HorizontalAlign="Left" Width="200px"
Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="CTMFGNAME" HeaderText="Vendor" SortExpression="CTMFGNAME">
<HeaderStyle BackColor="#C00000" Font-Size="X-Small" HorizontalAlign="Left" Width="150px" />
<ItemStyle Font-Bold="True" Font-Size="X-Small" HorizontalAlign="Left" Width="150px"
Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="CTDESCRIPTION" HeaderText="Description" SortExpression="CTDESCRIPTION">
<HeaderStyle Font-Size="X-Small" HorizontalAlign="Left" Width="200px" Wrap="False" BackColor="#C00000" />
<ItemStyle Font-Bold="True" Font-Size="X-Small" HorizontalAlign="Left" Width="200px"
Wrap="False" />
</asp:BoundField><asp:BoundField DataField="RecordID" HeaderText="Rec#" InsertVisible="False" SortExpression="RecordID">
<HeaderStyle BackColor="#C00000" Font-Bold="True" Font-Size="X-Small" HorizontalAlign="Right"
Width="32px" Wrap="False" />
<ItemStyle Font-Bold="True" Font-Size="X-Small" HorizontalAlign="Right" Width="32px"
Wrap="False" />
</asp:BoundField>
</Columns>
<PagerStyle BackColor="#C00000" ForeColor="#333333" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="Navy" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#C00000" Font-Bold="True" ForeColor="White" Width="636px" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:Image ID="Image1" runat="server" ImageUrl="~/images/details-banner.jpg" Width="632px" /><br />
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" CellPadding="2"
DataSourceID="SqlDataSource3" ForeColor="#333333" GridLines="None" Height="50px"
OnPageIndexChanging="DetailsView1_PageIndexChanging" Width="632px">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<CommandRowStyle BackColor="#FFFFC0" Font-Bold="True" />
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<FieldHeaderStyle BackColor="#FFFF99" Font-Bold="True" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<Fields>
<asp:BoundField DataField="CTMFGNAME" HeaderText="Vendor:" SortExpression="CTMFGNAME">
<HeaderStyle BackColor="Navy" Font-Bold="True" Font-Size="Small" ForeColor="White"
HorizontalAlign="Right" Width="100px" Wrap="False" />
<ItemStyle Font-Bold="True" Font-Size="Small" />
</asp:BoundField>
<asp:BoundField DataField="CTCATALOG" HeaderText="Catalog:" SortExpression="CTCATALOG">
<HeaderStyle BackColor="Navy" Font-Bold="True" Font-Size="Small" ForeColor="White"
HorizontalAlign="Right" Width="100px" Wrap="False" />
<ItemStyle Font-Bold="True" Font-Size="Small" />
</asp:BoundField>
<asp:BoundField DataField="CTDESCRIPTION" HeaderText="Description:" SortExpression="CTDESCRIPTION">
<HeaderStyle BackColor="Navy" Font-Bold="True" Font-Size="Small" ForeColor="White"
HorizontalAlign="Right" Width="100px" />
<ItemStyle Font-Bold="True" Font-Size="Small" />
</asp:BoundField>
<asp:BoundField DataField="DISTSKU" HeaderText="NAED V/I:" SortExpression="DISTSKU">
<HeaderStyle BackColor="Navy" Font-Bold="True" Font-Size="Small" ForeColor="White"
HorizontalAlign="Right" Width="100px" Wrap="False" /
<ItemStyle Font-Bold="True" Font-Size="Small" />
</asp:BoundField>
<asp:BoundField DataField="CTUM" HeaderText="Sold by:" SortExpression="CTUM">
<HeaderStyle BackColor="Navy" Font-Bold="True" Font-Size="Small" ForeColor="White"
HorizontalAlign="Right" Width="100px" Wrap="False" />
<ItemStyle Font-Bold="True" Font-Size="Small" />
</asp:BoundField>
<asp:BoundField DataField="ShippedQtyPAM" HeaderText="In Stock:" SortExpression="ShippedQtyPAM">
<HeaderStyle BackColor="Navy" Font-Bold="True" Font-Size="Small" ForeColor="White"
HorizontalAlign="Right" Width="100px" Wrap="False" />
<ItemStyle Font-Bold="True" Font-Size="Small" />
</asp:BoundField>
<asp:BoundField DataField="CurrSellPricePAM" DataFormatString="{0:c} (Negotiated pricing, SPA and qty/breakpoint pricing available!)" HeaderText="List Price:"
HtmlEncode="False" SortExpression="CurrSellPricePAM">
<HeaderStyle BackColor="Navy" Font-Bold="True" Font-Size="Small" ForeColor="White"HorizontalAlign="Right" Width="100px" Wrap="False" />
<ItemStyle Font-Bold="True" Font-Size="Small" BackColor="Navy" ForeColor="Yellow" />
</asp:BoundField>
</Fields>
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:DetailsView>
<br />
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/products_EMail.aspx?RecordID2=RecordID" Target="_self" Font-Bold="True" ForeColor="Navy" Enabled="False">Request a Quote for this Item...</asp:HyperLink></a>
</ContentTemplate>
</asp:UpdatePanel>
<br />
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Font-Bold="True" Font-Names="Verdana" Font-Size="Small" ForeColor="Maroon" GridLines="None"
PageSize="1" ShowHeader="False" Style="position: absolute; left: 184px; top: 44px;"Width="88px">
<Columns>
<asp:BoundField DataField="norecs" NullDisplayText="Sorry...No records found matching the search string...)"
ReadOnly="True" ShowHeader="False" SortExpression="norecs">
<ItemStyle Font-Bold="True" Font-Size="Small" ForeColor="Maroon" />
</asp:BoundField>
</Columns>
</asp:GridView>
<br />
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:IDC_Receiving %>"
SelectCommand="SELECT CTMFGNAME, CTSTOCK, CTCATALOG, CTDESCRIPTION, DISTSKU, CTUM, COMMODITYNAME, RecordID FROM [Cooper-Master-Items-Table] WHERE (CTMFGNAME LIKE '%' + @CTCATALOG + '%') AND (IDCPROVIDERCODE = 'IDC001') OR (CTCATALOG LIKE '%' + @CTCATALOG + '%') AND (IDCPROVIDERCODE = 'IDC001') OR (CTDESCRIPTION LIKE '%' + @CTCATALOG + '%') AND (IDCPROVIDERCODE = 'IDC001') OR (DISTSKU LIKE '%' + @CTCATALOG + '%') AND (IDCPROVIDERCODE = 'IDC001') OR (COMMODITYNAME LIKE '%' + @CTCATALOG + '%') AND (IDCPROVIDERCODE = 'IDC001') ORDER BY RecordID" OnSelecting="SqlDataSource2_Selecting">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox2" Name="CTCATALOG" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:IDC_Receiving %>"
SelectCommand="SELECT COUNT('DISTINCT @CTCATALOG') AS norecs FROM [Cooper-Master-Items-Table] WHERE ((CTMFGNAME LIKE '%' + @CTCATALOG + '%') OR (CTCATALOG LIKE '%' + @CTCATALOG + '%') OR (CTDESCRIPTION LIKE '%' + @CTCATALOG + '%') OR (DISTSKU LIKE '%' + @CTCATALOG + '%') OR (COMMODITYNAME LIKE '%' + @CTCATALOG + '%')) AND (IDCPROVIDERCODE = 'IDC001')">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox2" Name="CTCATALOG" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:IDC_Receiving %>"
SelectCommand="SELECT [CTMFGNAME], [CTCATALOG], [CTDESCRIPTION], [DISTSKU], [CTUM], [ShippedQtyPAM], [CurrSellPricePAM] FROM [Cooper-Master-Items-Table] WHERE ([RecordID] = @RecordID)">
<SelectParameters>
<asp:ControlParameter ControlID="GridView1" Name="RecordID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</asp:Panel>
</div>
</form>
</body>
</html>
|