Parameters Describe An Un-representable DateTime How To Ignore?
May 20, 2011
I am using ODBC to read data from a pervasive PSQL database and in some scenarios, the date column can contain 00/00/0000 date. I don't really care about invalid dates so is there some way I can convert all of these un-representable dates into Null or some specific date instead of the query failing.
EDIT: The following shows the code I am using and where it is failing:
Private _connODBC As OdbcConnection
Dim dt As New DataTable
_connODBC = New OdbcConnection(txtConnectionString.Text)
_connODBC.Open()
[Code]...
View 4 Replies
ADVERTISEMENT
Sep 30, 2009
I need to count the sick leaves in a month, for that i have to ignor Sat-sun on a datetime picker. how to i set the DateTime picker to ignor Sat and Sun? Assume there are two date time pickers dt1 and dt2 thus there difference will return teh number of days without counting sat-sun.
View 3 Replies
Apr 20, 2010
How do I get Linq to ignore any parameters that are empty? So Lastname, Firstname, etc? If I have data in all parameters it works fine...
refinedresult = From x In theresult _
Where x.<thelastname>.Value.TestPhoneElement(LastName) And _
x.<thefirstname>.Value.TestPhoneElement(FirstName) And _
x.<id>.Value.TestPhoneElement(Id) And _
[code]....
View 1 Replies
May 4, 2011
I am trouble shooting poor performance for the query I have posted below. Here is my problem: If I run the exact query below in sql server management studio or using .NET sqlclient the query takes an average of 14 seconds to run.
However, if in .NET I take out this part of the query:
DECLARE @time_diff INT
DECLARE @start_date DATETIME
DECLARE @end_date DATETIME
SET @time_diff = 2
SET @start_date = '05/04/11 00:00:00 AM'
SET @end_date = '5/4/2011 11:59:59 PM'
And use parameters in code like this:
sqlParameter = sqlCmd.Parameters.Add(New SqlParameter("@start_date", System.Data.SqlDbType.DateTime))
sqlParameter.Value = parameters.StartDate
sqlParameter = sqlCmd.Parameters.Add(New SqlParameter("@end_date", System.Data.SqlDbType.DateTime))
sqlParameter.Value = parameters.EndDate
Then the query takes about 2 - 3 minutes to run. Also, I have noticed that it takes about 2 - 3 minutes to run, if i replace the parameter values with string date constants and run in .NET or SSMS
--AND v.call_start_time BETWEEN @start_date AND @end_date
AND v.call_start_time BETWEEN '05/04/11' AND '5/4/2011 11:59:59 PM'
I found this article [URL] on cardinality and the query optimizer and I think it has to do with my issue but it doesn't seem to make sense in my case. According to the article, casts should be executed when determining cardinality. In my case this doesn't appear to be happening. The article also says to use parameters in place of local variables - which isn't working well with .NET parameters either. Regarding using a stored procedure instead: I have a variable number of parameters, I don't know how well it would work out. Even if this is the only option, then i would still like to know exactly what the problem is.
The query:
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
SET STATISTICS IO ON
DECLARE @time_diff INT
DECLARE @start_date DATETIME
DECLARE @end_date DATETIME
SET @time_diff = 2
[Code] .....
View 1 Replies
Apr 20, 2012
If I run the following code in C# then it runs fine
UInt32 a a = 0x9E3779B9
But when I run the same code in VB.Net then it gives me error "Constant expression not representable in type 'UInteger'"Dim a As UInt32 a = &H9E3779B9
View 2 Replies
Oct 13, 2010
I am trying to assign a constant with this value:
Public Const FIRST As UInteger = (0UI - 860UI)
View 1 Replies
Sep 1, 2010
UInteger data type hold any value between 0 and 4,294,967,295. MSDN.
If I try this code in VB.NET I get a compiler error:
Dim Test As UInteger = &HFFFFFFFF
Error: "Constant expression not representable in type 'UInteger'.
Why I can't set 0xFFFFFFFF (4,294,967,295) to a UInteger if this type can hold this value?
View 4 Replies
Jan 31, 2010
how can i inflate an array of points which describe a polygon?
View 1 Replies
May 4, 2009
i have a program(i already coded etc).Now i'm asked to make flowcharts to describe the algorithms used + test plans.Regarding flowcharts,how do i implement functions + procedures in them and about test plans--anyone knows or has some good site or notes so i know what i can do??
View 1 Replies
Oct 25, 2010
Maybe my questin was too impossible to unerstand, so I figured out how to ask it in more simple way. I suppose it can be best done in Visual Basic simplified code.
[Code]...
So question is how to describe in Visual Basic [Escape_key_was_pressed] function? When user don't hit Escape key, then program must NOT STOP for asking user keypress[Escape_key_press], it must go on with clicking on desktop to the end of program. SteelAce
View 2 Replies
Dec 5, 2011
I have in my database a table (AccessControl) that describes a sort of users "access control list" for the informations contained in the table Customers and other tables.Example: the entity CUSTOMER is marked by the EntityId #1. If a user belongs to the department #6, he can access the records of customer #16 and #31, but he can't for #14, that can viewed by user in department #3:
[code]...
How can I describe this relationship into the DbContext definition using a fluent Code First approach?
View 1 Replies
Mar 23, 2011
how to convert string to datetime and calculate date
View 3 Replies
May 7, 2010
I'm trying to match a certain DateTime value with the current system DateTime. I have a timer and a label on a form. Timer interval is set to 1000. When the form loads, the timer starts ticking. As soon as the current DateTime matches the value of the variable, it shows a message in the label. When I'm writing the following code, the values don't match even if the current system DateTime is equal to the variable. Label1 isn't showing 'Times Matched':[code]The default format of 'Now' is the same as I have stored in dtmVar variable. So there's no question of format mismatch. Does that mean 'Now' is not actually a DateTime property? Provided, my O.S. is Windows Vista Ultimate and all date/time settings are set to default.
View 1 Replies
May 1, 2010
I'm trying to match a certain DateTime value with the current system DateTime. I have a timer and a label on a form. Timer interval is set to 1000. When the form loads, the timer starts ticking. As soon as the current DateTime matches the value of the variable, it shows a message in the label.
When I'm writing the following code, the values don't match even if the current system DateTime is equal to the variable. Label1 isn't showing 'Times Matched':
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
Dim dtmNow As DateTime
[Code]....
Why is it so? The default format of 'Now' is the same as I have stored in dtmVar variable. So there's no question of format mismatch. Does that mean 'Now' is not actually a DateTime property? Provided, my O.S. is Windows Vista Ultimate and all date/time settings are set to default.
View 1 Replies
Aug 8, 2011
datetime1 and datetime2now two fields are have data ( date )in table recordi want to update only datetime2 is an emptyi am using visual basic 2010 ( visual studio 2010
View 1 Replies
May 13, 2011
I'm writing a query to select all records that has any part of parameter. I have one table called Employees. Some people have name like this: John David Clark If the parameter is
[Code]....
I should be able to get result back as long as there's a match in the parameters. If I use Function Contains (q.FirstName & " " & q.LastName).Contains(employeeName), I will not get any result back if employeeName is "John Clark" Function Contains looks only for next words from left to right. It doesn't match a single word at a time. So that's why I used this in the Linq to SQL:
[Code]....
View 2 Replies
Aug 30, 2010
I am getting error [07002] the # binded parameters < the # of parameters makers, i checked both parameters were perfect even though i am getting this error here is my code
[Code]...
View 1 Replies
Dec 27, 2010
I try to compare Datetime.Now with a Datetime variable I set, using the Datetime.CompareTo() method. I use a timer to compare these every second and display the result, but as the current time approaches the time I set, the result changes from 1 to -1, but never 0, which means these two are never equal. I'm suspecting the Datetime structure contains milliseconds?
View 7 Replies
Mar 14, 2011
Assume the following program is started at 1:59:01 AM on 3/13/2011 in the United States. The first time Timer1 ticks what will be the value of the TimeSpan (ts)?
Public Class Form1
Private Sub Timer1_Tick(sender As System.Object, _
e As System.EventArgs) Handles Timer1.Tick
[code].....
View 7 Replies
Jan 29, 2011
I'm trying to add the date and time of Today into a Sql-database-field that has the datetype datetime.
[Code]...
the msgbox gives me the following result: 29/01/2011 18:49:21 my sqlException gives me the following error: 102 - Incorrect syntax near '18'. Is it better that i set the datatype to char in my sql database? It's maybe a bit easier? When I do that, can I calculate with these date?
View 4 Replies
Feb 6, 2012
Basically Commands has Parameters and parameters has functions like Add, AddWithValue, and etc. In all tutorials i've seen, i usually noticed that they are using Add instead of AddWithValue.
[Code]...
since it saves my coding time. So which is better to use? Which is safe to use? Does it improves performance?
View 2 Replies
Aug 6, 2011
is there a way to get the GET parameters and POST parameters in just one function or Collection in ASP.NET? Like using $_REQUEST in PHP? I'm using VB.NET.
View 3 Replies
Oct 27, 2009
How do I convert ISO datetime to locat EST with vb.net?
I have input time as e.g. "20091027T1639Z" which is ISO GMT.
View 3 Replies
Jun 28, 2010
I have an xml document. The description tag is enclosed in a cdata section. When I view the page in firefox I get the following error: XML Parsing Error: not well-formed It's erroring at this character (an empty white square and I don't know what the character really is). Is there a way I can get the parser to ignore these characters?
View 4 Replies
May 25, 2011
So I want to now if that possible for .NET languages to ignore error without using try catch construction ?
I can ignore warring with #nowarring 40 for example, can I ignore error ?
simply wanted to call system pause with this way
open System.Runtime.InteropServices
[<DllImport(@"msvcrt.dll")>]
extern void system(string str)
system "pause"
but got Error message
unbalanced stack. This is probably because the managed PInvoke signature does not match the unmanaged target signature. Make sure that the calling convention and parameters of the PInvoke signature match the target unmanaged signature.
So I don't care, it works. But can I just ignore this error ? without doing weird stuff like that :
try (system "pause") catch |_->()
Ok , I solved my problem by adding CallingConvention=CallingConvention.Cdecl, but what the question was about skipping exceptions, so and I still don't know if I can do it.
So maybe I need to tell some real reason to not be down-voted hard - sometimes it's matters for program to live even with hard errors occupations, but even sometimes you don't need to catch them. You need just ignore them...
View 6 Replies
Mar 23, 2011
I use TortoiseSVN for versioning of my large VB Project in Visual Studio 2008. Once in a while, when editing one of the many typed DataSets, VS feels like switching the position of the attributes
msprop:Generator_ColumnVarNameInTableand msprop:Generator_ColumnPropNameInRow
In like nine THOUSAND places of the .xsd file. Sometimes I use a custom sed-script to reverse it again but most of the time I just commit it without knowing if there was any real change.
Can I prevent Visual Studio from messing with those attributes?
Can I enforce a specific ordering?
Or do I need some workflow within TSVN to ignore or revert such changes?
I wrote a small VB.Net Console app that scans thru the lines, sorting the attributes. It works on text alone as one cannot use xml parsing abilities without a massive increase in execution time and code size.
View 1 Replies
Apr 20, 2011
Does anybody know how to ignore a line(s) of code after a line(s) has executed. Let say you have a button1, and two CheckBoxes. By clicking once button1, cheheckbox1 checked. By clicking agin button1, then CheckBox2 checked. You will probably say that I can do that in diferent way, but it isn't the solution of this problem that I want. This is only an example.
View 11 Replies
May 25, 2009
I have set up my form using with the languages and I have store the texts in the resource. I have debug the project and everything seen to be fine. I found that there is a folder in the project bin folder. The folder was called zh-chs. I have changed the name from roject1.resources.dll to testdll.dll and moved to the bin folder. I have added reference in my project and I have deleted the zh-chs folder. Suddenly, I have found a warning sage.
Code:Could not resolve this reference. Could not locate the assembly "TESTDLL, Version=1.0.0.0, Culture=zh-CHS, processorArchitecture=MSIL". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get
[code]......
View 9 Replies
Feb 15, 2012
When I run my program if finds fields fill's them in and submits, but sometimes the page does not have them fields and I just want it to skip them if not found so it continues otherwise it crashes.
My e.g field:
WebBrowser1.Document.GetElementById("subject").SetAttribute("value", TextBox3.Text)
View 6 Replies
Oct 4, 2009
Okay, let's say for example that I disagree with some of Microsoft's decisions to hide things from intellisense , and want to override this. Is it possible to have my intellisense ignore the EditorBrowsable(EditorBrowsableState.Never) attribute?
View 2 Replies
