Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~1K People Reached
Favorite Forums
Favorite Tags
Member Avatar for antman89

select a.EID, b.ShopName, a.TxnMonth,a.TxnYear,a.TxnDate, a.TxnAmount,a.TxnDay,a.DateCreated, a.SubmissionType from [UA-DCM]..DCM_FTPDailyData as a Inner Join [UA-DCM]..MMS_ECR as b on a.EID = b.EID where a.TxnDay between DateAdd(day,DateDiff(day,0,GETDATE() - 14),0) AND DateAdd(day,DateDiff(day,0,GETDATE()),0) and a.SubmissionType = 'ECR' or a.SubmissionType = 'FTP' and b.AssetID = '71' and a.TxnAmount not like '"%' and a.EID = '7100101001' Order by …

Member Avatar for antman89
0
403
Member Avatar for antman89
Member Avatar for antman89

<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="cart.aspx.vb" Inherits="cart" title="Untitled Page" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical" style="z-index: 1; left: 293px; top: 711px; position: absolute; height: 184px; width: 985px" AutoGenerateColumns="False" DataKeyNames="OrderID" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="OrderID" HeaderText="OrderID" InsertVisible="False" ReadOnly="True" …

Member Avatar for dnanetwork
0
185
Member Avatar for antman89

<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="cart.aspx.vb" Inherits="cart" title="Untitled Page" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> <script runat="server"> Dim TotalUnitPrice As Decimal = 0.0 Function GetUnitPrice(ByVal Price As Decimal) As Decimal TotalUnitPrice += Price Return Price End Function Function GetTotal() As Decimal Return TotalUnitPrice End Function Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, …

Member Avatar for antman89
0
235
Member Avatar for antman89

Protected Sub Button5_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button5.Click Dim connection As SqlConnection = New SqlConnection("server=(local); Database = Bookstore; integrated Security=True") Dim CSP As SqlCommand = New SqlCommand() 'Dim Cust As SqlCommand = New SqlCommand() CSP.Connection = connection CSP.CommandText = ("select CusID,CusPassword from CusromerDetail where CusUsername = …

Member Avatar for dnanetwork
0
105
Member Avatar for antman89