For some reason vb keeps changing my dates format and removes the 0s at first this wasnt a problem but it really messes up my sorting in my gridview.
Dim aftersubtraction As Date
aftersubtraction = departuredate.AddDays(-dates1.Text)
dates.Add(aftersubtraction.AddDays(-gracep.Text))
I have a datetime datatype field in mssql2005 database ...
which retrieves the date in gridview as .. 4/7/2011 12:00:00 AM
but i want it retrieve date as 7-Apr-2011
I need to stop all running workflows associated to an incident (and those with a name that begins with "Auto_").
However, I can't seems to find any documentation on how to stop workflow programmatically and I can't find how they are stored in the DB.
i build my project and i made a copy of the windowsapplication1.exe and tried to open itwith txt editor.. i tried to search for "chris" (computer username) and i see that:[URL]
View 2 RepliesOur CRM 2011 database contains approx. 20000 contacts, and I need to loop through all of them using the SDK. Currently I'm finding the following linq query takes a very long time to execute:
[Code]...
I've tried applying several suggestions found on the web, but still experiencing cached results when querying CRM 2011 with linq. My web.config reads as follows, which is supposed to disable result caching:[code]I can live with that, but it would be nicer, instead of recreating the context, to have a way of ensuring no caching either in code or in web.config.
View 2 RepliesSo I have a Powerpoint presentation. It contains numerous images on it, referred to by image X. (So it's the same image but on multiple pages) These same images on different pages/slides have different width/height attributes associated to them. So even though they're the same image, they may not be the same size.
So there exists a scenario where an image exists on a lot of the slides. I want the ability to replace all of them at the same time (quickly) without having to go through each slide and separately replacing X, one at a time with the new image.
Is this possible? (yes/no)How would this be accomplished? (abstract - high level explanation is only required)
Anyone using Crystal reports 2011 with VB.Net 2008 Pro? my work is willing to buy this but I just want to make sure it will work, the dynamic as opposed to static query values is what interests me about it.
View 1 RepliesI have Customer search screen and Customer Detail Screen, On Search set up a ShowLink on Name ,so when ever a user click on Name the Detail Screen Opens with that Customer data.
Whenever i change something into Detail Screen and press save, it Updates the customer. Its Fine.
But i want provide a functionlity of AddNew Record for that customer, So i have put a Button "AddNew" on ScreenCommandBar that clears all the fields in the Detail Screen. But it still Updates the Customer..
How can i code for add new record in Detail Screen?
I have been struggling with this problem for several hours now and can't find the reason for the error message...I am reading a datetime string from a txt file, it returns this:"01/31/2011 6:13 AM" Now, I want to convert this string to datetime format. I don�t want to change the structure of the date... just want to convert in order to do some minutes and seconds calculations.I have tried all kind of options:
Timespan
Datediff
Parse
ParseExact with format.... culture... globalization
Nothing seems to work!
I've got a 2 part question: First question: I know that there is a query limit of 5,000 records when querying records, for performance reasons, but is there a limit when doing an aggregate query? If so, what is it? I need only to query the number of records and for one entity I can get a result of 39,000+ records, but for another entity I see an error message like:
[Code]...
I want to use crystal reports 2011 in visual studio 2010. How can i use it?
View 1 RepliesI am coding on Windows 8, with the Visual Studio 2011 developer version. I wanted to know how to change something when a "form" is loaded. Form is in quotes because the actual page isn't a form. It's in the shape of a tablet, which you've probably guessed by now that I'm coding a tablet app.I just wanted to know how to change something when the actual app loads. I tried the "Loaded" sub, but that was confusing. It DID change a text from a textbox (I just tested it out as "textbox1.text = "test") and it worked. But when I try to make buttons visible false, nothing happens.I'm not sure if this is the right code (and I doubt it is, because it doesn't hide it on buttons either), but I typed in, let's say...
btn0.Visibility = False
nd this is the sub it's in...
Private Sub pgeMathAssist_Loaded(sender As Object, e As RoutedEventArgs) Handles
[code].....
I'm converting my date 01/June/2011 to FileTimeUTC so I'm getting a value of
129514186100000000
How do I convert it back to the date?
Everything was working just fine...then one time running the debugger and I'm given a 401.2 error from IIS Express 7.5. I created a new project and tested - worked fine. I ensured the web.config and other project settings where identical - still getting the error in the original project!
[Code]...
I have one PC whereby the OS has been installed on E: and it has no C: drive. Onto this I have installed my .Net 4.0 WPF Application which runs fine.
However, when I try to access a crystal report it gives the exception below. This user is able to access the report from its network location in windows explorer so I assume the act of asking Crystal to copy it locally is causing a problem?
Therefore, can anyone advise where the local copy will be created and/or how I can control this.
[Code]....
I'm Stuck the following problem: How can I link a PDF Document to a Record in a Data Grid using Visual Studio LightSwitch 2011 and Visual Basic?
View 1 RepliesPublic Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Month_index, days, yearp As Integer
Month_index = DateTimePicker1.Value.Month
[code]....
i can get the Clc month and day perfectly for year 2011, but when i goes to year 2011 it just appears as 0.my dates in Months.txt is saved as so
2010|2|14|30|29|30|29|30|29|29|30|29|30|29|30
2011|2|3|30|29|30|30|29|30|29|29|30|29|30|29
2012|1|23|30|29|30|30|29|30|29|30|29|30|29
I have small lightswitch application having CreateNewUser Screen.Screen fields comes from Datatable added in DataSource, I have made all Validattion of fields at DataSource side.However i have added one Custom Control in the screen named : Re-TypePassword.Whenever user click on save button I want to match the Password and Re-TypePassword and want to prompt user a validation message if Password and Re-TypePassword are different.how can i display that validation massage ? ( I mean i want to add validation message to Summary of messages that appears at the top of screen)
View 1 RepliesI have result string date xml export from database like "2011-06-27T14:03:19.5300000+07:00". How to Convert to format datetime fully(date and time) in C# or VB.Net language datetime?
View 4 RepliesI am using dtpicker1 to select the date here is my code
[Code]...
Now the problem is this when i select the date from dtpicker1 it inserts the date in textbox in this format "07/12/11" but i need this format "07/12/2011"
How can I set week number of "1/2/2011(Sun)" as 52 of 2010?
When I write as follows, it says week number is "1".
Dim dtTest As Integer = DatePart(DateInterval.WeekOfYear, CDate("2012/01/02"), _
FirstDayOfWeek.Monday, FirstWeekOfYear.FirstFullWeek)
Why is it? I set FirstDayOfWeek as Monday, so week number of "1/2/2011(Sun)" Should be 52, right?
"1/2/2011(Sun)" is just an example.
I want general method to do:
1. First day of week is Monday.
2. First week of year is the first full week which stat with Monday.
3. The last week of year should contain dates before the first week of the next year(such as 1/1/2011(Sat), 1/2/2011(Sun))
My coworker's installation of visual studio 2008 breaks every time there's an exception, mine doesn't.
We've been looking for how to stop his from doing this but haven't had any luck. The only difference is that mine was initialized for C# while his was initialized for VB.
Other than reinstalling and choosing the option that says "Optimise for C#" when VS2008 sets up the environment for the first time
We are running .NET 2.0 ASMX web services on Windows 2003 server on IIS 6.0. We have migrated a legacy VB 6.0 application to .NET 2.0 application using VB.NET. CDATE function is used at many places and we did not replace that with .NET equivalent date functions. After migration, code was working fine for many years.Recently, we have started encountering issues on our production servers where the below code fails:
CDATE("11 Jul 2011 21:10:27")
Error: Conversion from string "11 Jul 2011 21:10:27" to type 'Date' is not valid."If we perform an iisreset, the same code starts working fine. Could this be due to some recent patch for Windows server/ .NET patch?
I have the table with datetime as data type. I have below statement. When the value is "23/05/2011 00:00:00.000", it show "23/05/2011 12:00"??I don't know why it cannot display "23/05/2011 00:00 AM"?
String.Format("{0:dd/MM/yyyy hh:mm tt}", dr("Start_DateTime"))
when i am trying this Date.Compare(Format(DateTimePicker1.Value.Date, "dd/MM/yyyy"), Convert.ToDateTime(dr(1))) < 0 it gives an error message as "Conversion from string "23/06/2011" to type 'Date' is not valid."where dr(1) is database field in text format as 29/3/2011 (dd/mm/yyyy) .
View 3 RepliesI try to read the value ""C:\Program Files\Edgecam\2011.10"" from the following registry entry:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINESOFTWAREPlanitEdgecam2011.10Installation]
@="C:\Program Files\Edgecam\2011.10"
"Folder"="Edgecam\2011.10"
[code]....
How do I change a date such as "2/9/2011" to "20110902" [ie] yyyymmdd ? At first I thought I could use the substring function but I don't know how to insert the leading zero for month or day when it is necessary.Joe MIller
View 8 RepliesHow do I change a date such as "2/9/2011" to "20110902" [ie] to yyyymmdd ? At first I thought I could simply use the substring function but I don't know how to add the zeros for the month and day when necessary.
View 7 Repliesconversion of date
if i used -- Date.parse("28/01/2011")
it gives me error as "String was not recognized as a valid DateTime."
so then i modify above code as -- CDate("28/01/2011").it gives me error as "Cast from string "28/01/2011" to type 'Date' is not valid." I used convert.todatetime also date.parseexact but nothing is working..