Easy DateTime question
-
Here's a link that might help you with this. ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.NETDEVFX.v20.en/cpref2/html/M_System_DateTime_Subtract_1_4910510e.htm Ben
i cant access the link..no page display..and another question how can i validate time input hh:mm:ss using range validator, and how can i set the datetime.now in textbox gridview in edit mode. Thanks Bernie
-
i cant access the link..no page display..and another question how can i validate time input hh:mm:ss using range validator, and how can i set the datetime.now in textbox gridview in edit mode. Thanks Bernie
Here is the content of the link: Subtracts the specified date and time from this instance. Namespace: System Assembly: mscorlib (in mscorlib.dll) Syntax Visual Basic (Declaration) Public Function Subtract ( _ value As DateTime _ ) As TimeSpan Visual Basic (Usage) Dim instance As DateTime Dim value As DateTime Dim returnValue As TimeSpan returnValue = instance.Subtract(value) C# public TimeSpan Subtract ( DateTime value ) C++ public: TimeSpan Subtract ( DateTime value ) J# public TimeSpan Subtract ( DateTime value ) JScript public function Subtract ( value : DateTime ) : TimeSpan Parameters value An instance of DateTime. Return Value A TimeSpan interval equal to the date and time represented by this instance minus the date and time represented by value. Exceptions Exception type Condition ArgumentOutOfRangeException The result is less than MinValue or greater than MaxValue. Remarks This method does not change the value of this DateTime object. Instead, a new TimeSpan is returned whose value is the result of this operation. Before subtracting DateTime objects, insure that the objects represent times in the same time zone. Otherwise, the result will include the difference between time zones. Example The following code example demonstrates the Subtract method and operator. Visual Basic Copy Code Dim date1 As New System.DateTime(1996, 6, 3, 22, 15, 0) Dim date2 As New System.DateTime(1996, 12, 6, 13, 2, 0) Dim date3 As New System.DateTime(1996, 10, 12, 8, 42, 0) Dim diff1 As System.TimeSpan ' diff1 gets 185 days, 14 hours, and 47 minutes. diff1 = date2.Subtract(date1) Dim date4 As System.DateTime ' date4 gets 4/9/1996 5:55:00 PM. date4 = date3.Subtract(diff1) Dim diff2 As System.TimeSpan ' diff2 gets 55 days 4 hours and 20 minutes. diff2 = System.DateTime.op_Subtraction(date2, date3) Dim date5 As System.DateTime ' date5 gets 4/9/1996 5:55:00 PM. date5 = System.DateTime.op_Subtraction(date1, diff2) Ben
-
i cant access the link..no page display..and another question how can i validate time input hh:mm:ss using range validator, and how can i set the datetime.now in textbox gridview in edit mode. Thanks Bernie
-
Here is the content of the link: Subtracts the specified date and time from this instance. Namespace: System Assembly: mscorlib (in mscorlib.dll) Syntax Visual Basic (Declaration) Public Function Subtract ( _ value As DateTime _ ) As TimeSpan Visual Basic (Usage) Dim instance As DateTime Dim value As DateTime Dim returnValue As TimeSpan returnValue = instance.Subtract(value) C# public TimeSpan Subtract ( DateTime value ) C++ public: TimeSpan Subtract ( DateTime value ) J# public TimeSpan Subtract ( DateTime value ) JScript public function Subtract ( value : DateTime ) : TimeSpan Parameters value An instance of DateTime. Return Value A TimeSpan interval equal to the date and time represented by this instance minus the date and time represented by value. Exceptions Exception type Condition ArgumentOutOfRangeException The result is less than MinValue or greater than MaxValue. Remarks This method does not change the value of this DateTime object. Instead, a new TimeSpan is returned whose value is the result of this operation. Before subtracting DateTime objects, insure that the objects represent times in the same time zone. Otherwise, the result will include the difference between time zones. Example The following code example demonstrates the Subtract method and operator. Visual Basic Copy Code Dim date1 As New System.DateTime(1996, 6, 3, 22, 15, 0) Dim date2 As New System.DateTime(1996, 12, 6, 13, 2, 0) Dim date3 As New System.DateTime(1996, 10, 12, 8, 42, 0) Dim diff1 As System.TimeSpan ' diff1 gets 185 days, 14 hours, and 47 minutes. diff1 = date2.Subtract(date1) Dim date4 As System.DateTime ' date4 gets 4/9/1996 5:55:00 PM. date4 = date3.Subtract(diff1) Dim diff2 As System.TimeSpan ' diff2 gets 55 days 4 hours and 20 minutes. diff2 = System.DateTime.op_Subtraction(date2, date3) Dim date5 As System.DateTime ' date5 gets 4/9/1996 5:55:00 PM. date5 = System.DateTime.op_Subtraction(date1, diff2) Ben
thanks for that friend, I got it now. I have new question, how can i add gridview header above header?.. Thanks Bernie
-
thanks for that friend, I got it now. I have new question, how can i add gridview header above header?.. Thanks Bernie
-
What are the settings to be change for me to show the header on load?. I found out that it depends on the number of rows. Thanks bernie
-
What are the settings to be change for me to show the header on load?. I found out that it depends on the number of rows. Thanks bernie
-
In the gridview prerender event you need this kind of code: if (!GridView1.TopPagerRow.Visible) { GridView1.TopPagerRow.Visible = true; } Ben
this is a C# code right?how about in VB?. i tried to write as if GridView1.TopPagerRow.Visible = false then GridView1.TopPagerRow.Visible = true but i got some error "Object reference not set to an instance of an object." is that because my gridview was controlled by dropdown?.How can i do that? Bernie
-
this is a C# code right?how about in VB?. i tried to write as if GridView1.TopPagerRow.Visible = false then GridView1.TopPagerRow.Visible = true but i got some error "Object reference not set to an instance of an object." is that because my gridview was controlled by dropdown?.How can i do that? Bernie
-
You need to turn paging on. Set the page size to be really big so you only have one page. Ben
is that the only setting that i need? it will not display the next or previous? Bernie
-
You need to turn paging on. Set the page size to be really big so you only have one page. Ben
I set the page size to 10000 but it doesnt show the pager, I got some error in pre render event. null reference. My gridview is controlled by dropdown Bernie
-
You need to turn paging on. Set the page size to be really big so you only have one page. Ben
-
You need to turn paging on. Set the page size to be really big so you only have one page. Ben
-
You need to turn paging on. Set the page size to be really big so you only have one page. Ben
Hi, I have a report viewer, I have tables on my report. I set the hideDuplicates to my dataSet, It hides the data but still adding row on below, any idea about that?. I dont want to display row without data below in my table Thanks Bernie
-
You need to turn paging on. Set the page size to be really big so you only have one page. Ben
-
You need to turn paging on. Set the page size to be really big so you only have one page. Ben
i have deployed my program in IIS, my report viewer works on my project but when i deployed it on IIS error was display, An error occurred during local report processing. The definition of the report 'Main Report' is invalid. The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1. Any idea about this? thank you very much.. Bernie
-
You need to turn paging on. Set the page size to be really big so you only have one page. Ben
i found the solution friend. I put the data item in header or footer not in "details" and it works. my problem now is when i deploy it on IIS, the reportViewer does not work. Bernie
-
You need to turn paging on. Set the page size to be really big so you only have one page. Ben
My first guess would be that the crystel report view dlls were not distributed with your site. If they were distributed then it must be the format of the dataset itself. Perhaps the report is expecting a root level name of the dataset and isn't getting that. Perhaps the dataset it self is null. Hard to say for sure. Ben
-
You need to turn paging on. Set the page size to be really big so you only have one page. Ben
my report viewer is working project preview, but when i deploy it in IIS it does not work. but by the way lets forget about that. I am downloading SSRE, it has reporting options. ' I have questions about dateTime, my date Format is 2007-MARCH-23 yyyy-MONTH-dd, I have 3 dates 2007-MARCH-23,2007-MARCH-24 and 2007-APRIL-01, i have query using BETWEEN, SELECT * FROM table1 WHERE date BETWEEN '2007-MARCH-23' AND '2007-APRIL-01' but it returns no rows, but if my query is SELECT * FROM table1 WHERE date BETWEEN '2007-APRIL-01' AND '2007-MARCH-24' it returns the rows. Base on my query SELECT MAX(date),MIN(date) FROM table1, '2007-APRIL-01' is the minimum. any idea about that?. How can i have between queries? Bernie
-
You need to turn paging on. Set the page size to be really big so you only have one page. Ben