View Complete Post
I want to do a Count of months since first transaction date by
Subscriber | Month | Measure.TransactionValue |
1 | 201002 | 0 | 0
1 | 201003 | 100 | 1
1 | 201004 | 200 | 2
1 | 201005 | 300 | 3
1 | 201006 | 0 | 4
1 | 201007 | 50 5
Any help would be greatly appreciated.
Realy simple aspx page:
<asp:TextBox ID="txtExpireDate" runat="server" Width="78px" MaxLength="10" ></asp:TextBox>
Is there any function to calculate number of business days in a month for a particular date. my input would be just a single date
I've got 3 problems and I can't find the solution so that's why I'm here.1. I've got a calander for adding a product to my shop. How can I make sure that you can't select a date in the past?2. I have a gridview, and I have added a hyperlinkfield in access. When I'm filling up my gridview it doesn't show a link, it shows this:example= www.Groezrock.be#http://www.Groezrock.be#3. I've added a label and a textbox on my guestbook page. It says "Please fill in the number in the textbox -label that generates 4 random number- txtbox.For filling up the textbox I use this code:
Dim randObj As New Random lblVraag.Text = (randObj.Next(1001, 10000).ToString)
The problem is, when I fill in the number, it always gives me the validation error "Numbers don't match" which I added myself.
If txtnumbers.Text = lblnumbers.Text Then ... Else lblFout.Text = "Numbers don't match."
I am developing one desktop application using vb.net 2008 and Microsoft SQL Server 2005. I need a help for fetching the data from database between a given range.
the date field in my table is of type VARCHAR(25) and the date format stored is dd-mm-yyyy. when I using the between clause in the SQL query then it is not giving all the data every time i.e. the date criteria in where clause is not working fine.
while my clients requirement is to keep the date format as dd-mm-yyyy and fetch the data according to the given range.
I search on the forum and found many queries to fetch the data by converting or type casting the date field within sql query but nothing worked.
so please help me out with that what shoud I do in this case.
The table structure that I am using is as follows
/****** Object: Table [dbo].[tblTransaction] Script Date: 05/17/2011 21:49:11 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
CREATE TABLE [dbo].[tblTransaction](
[Tid] [int] IDENTITY(1,1) NOT NULL,
[Dataid] [int] NOT NULL,
[Vouch_type] [int] NULL,
[Dr_ac_name] [varchar](50) NULL,