Martin Hansen's Q&A profile
Visual Basic Best way to determine if a time is within a given range?
Let's say I have a process that is suppose to start at a given time and end at a given time, what would be the best way to do that A simple way is to use a timer control on the form and in the tick event determine if the time is turn on or turn off time which will trigger you action. This will Check every minute. So its not acurate down to the second which you could reduce the tick interval time. At the moment its set to 60000 for 1 minute ticks. The following code will set a label at 19:50 and reset it at 19:71. Instead of setting a label you simply start whatever process your want to start and ...Show All
SQL Server HOW TO UPGRADE SBS WITH SQL SERVER 2005.
DEAR ALL, JUST A WEEK AGO I BOUGHT SMALL BUSINESS SERVER 2003 PREMIUM EDITION. I FOUND SQL SERVER 2000. I EXPECT IT SHOULD BE SQL SERVER 2005. MY VENDOR SAY "YOU CAN UPGRADE IT" . BUT I DON'T SEE SO FAR HOW TO UPGRADE ANY IDEA PLEASE MAIL ME. THANK YOU IN ANTICIAPATION REGARDS MUBARAK SHA Mubarak, SBS2K3 does not yet have SQL Server 2005 so it is correct that you have SQL Server 2000. Upgrading from SQL Server 2000 to SQL Server 2005 is supported but you'll need to work with your vendor to acquire the SQL Server 2005 media and understand any licensing implications for the ...Show All
Visual C# DataGridView new row
Why when I add a new row to a DataGridView do all the textboxes show (null) How do I make it so that these are just empty textboxes Thanks dave I upgraded from Beta1 to Beta2 and it went away. Thanks for the reply. dave ...Show All
Windows Forms Directory Browsing in c#
Hi, I am new C# user. My question is is there a a class in C# which allows me to browse directories. All I can see is a file save as and file open dialoag box. Thanks FolderBrowserDialog is a generic Folder Browsing Dialog that is available in 2.0 and 1.1 It's not very intuitive and extremely difficult to Navigate. I wish they would have provided an OpenFolderDialog that lets you choose folders, like many of their applications do. Code samples on how to use it can be found here ...Show All
Smart Device Development VPN support in Windows Mobile 5.0 Pocket PC emulator?
I installed Visual Studio 2005 beta 2 and used the included Device Emulator. With the Pocket PC 2003 SE image I can connect to a VPN server. With the Windows Mobile 5.0 Pocket PC image I don't have such luck. I configure a VPN connection the exact same way is with Pocket PC 2003 and the new VPN connection actually shows up in the Connection Manager. However, when I tap the two opposing arrows at the top of the screen the Connectivity window appears but the new VPN connection does not show up there. Are VPN connections not supported in the Device Emulator Thanks, Jacco Vladimir Fedorov wrote: ...Show All
Windows Forms How to get all the attributes of an HtmlElement?
System.Windows.Forms.HtmlElement.GetAttribute can be used to get value of an atribute by its name, How can I get the name of all attributes for an HTMLElement Thanks i guess that would be one way to look at it---of course, if your html is well formed, then you just load it in an xmlreader, there you have it...no shortcoming ...Show All
Visual Studio Express Editions 'Exclude From Project' in Solution Explorer
Hi All, Visual Studio .NET 2003 and Visual Web Developer both have a 'Exclude From Project' menu command when right-clicking a file in the Solution Explorer. I can't find this command in Visual Basic Express. How can I remove a file from my project, while in the IDE, without deleting it Thanks, Gordon Bell So, there is no way to remove a file from a solution, without Deleting it ...Show All
Visual Studio Crystal Reports XI Rlease 2 with Visual Studio 2005 Merge Module(CR XI 2 - VS 2005 2k5)
Hi, You need to have your server/website configured to use the 2.0 framework ...Show All
SQL Server Execute Mutiple Tasks In Debug Mode
Maybe I'm missing something, but I can't find how to run multiple tasks in sequence while in Visual Studio debug mode. In DTS design mode I grew accustomed to right-clicking tasks one-at-a time, but in SSIS I find the additional step of having to exit Debugging mode after every task gets old after a while. There must be a way to start execution at a certain task and have the package continue all the way to some other specified task. It would also be nice to have every task in a Group execute in sequence and stop (even if connections continue beyond the group). I could even settle for repeatedly clicking the Continue button in Debug mo ...Show All
Visual Basic What's wrong with this code?
I had this code that i am supposed to use for my current project...Using Crystal Report, I want to sort the record by entering the two dates (dtpFrom, dtpTo), the name of the company(FINAL2.COMPANY), the description(FINAL2.Description) Private Sub ConfigureCrystalReports() Dim mySelectFormula As String = "{FINAL2.Order_Date} >= #"" & dtpFrom & "#" & " and {FINAL2.Order_Date} <= #"" & dtpTo & "#"" & " {FINAL2.COMPANY} > Maxicare " _ & "AND Mid({FINAL2.Description}, 1, 1) = ""C"" " myCry ...Show All
Visual Studio Express Editions REgistration problem...
Can someone give me the link to the VB Express Beta 2 registration I installed it on a pc of mine, that now is currently off the internet in an isolated network, But i'd like to retrieve the key on another PC. Link, please Hi Steven, Registration does not work with this build because they are not supposed to be publicly available yet. We are checking to see why the have become publicly available. Thanks for your help. ...Show All
SQL Server Unable to retrieve TransSubscription.DistributionJobID using DMO on SQL2005
Using DMO to look up the distribution publisher, the publishing db and the publication name appear to be working. This is accomplished with the TransPublication dmo object. We receive some information from the TransSubscription object, but not the DistributionJobID. We get the correct subscriber count, article count, publiser name, subscriber server and subscriber databasename. The DistributionJobID is all zeros, (00000000000000000000000000000000). SQL2005 9.00.2047 with or without the backward compatible objects installed. The objects and code has been working with SQL2000 for two years. It is failing dur ...Show All
Visual C# saving datagrid data as an Excel file
How can i Save data in a DataGrid control as Excel sheet file (ie .xls file) i think its possible to convert the datagrid data to xml. if so is it easy to convert xml file to excel file using xslTransform can any body explain how to solve this problem Hi I think these articles will help:- http://www.codersource.net/published/view/283/exporting_data_grid_to_excel.aspx http://www.codeproject.com/aspnet/DAtaGridExportToExcel.asp ...Show All
Windows Forms Form Designer; w/ Custom Properties
I have scoured the net looking for an answer to this and I have not found one tailored to my problem. I'm working with a form designer, and I want to slim the number and add a few of my own properties. I know how to add properties, and to remove them; Except for 2 that won't go away. They are: "Localizable" "Language" I ...Show All
.NET Development What Happened to the 'Running Documents' window in VS2005?
In Visual Studio 2003, when debugging a web application I had access to the 'Running Documents' window that listed all of the pages and client scripts files currently loaded in the attached browser process. This was very handy for setting client-side breakpoints in script, as well as confirming various details in the html source. In VStudio 2005, I cannot find any reference to the Running Documents window. Where did it go It used to be under Debug > Windows > Running Documents. I cannot even find any reference to it in the MSDN docs. One Small Tip : This works only after installing the Service Pack 1 of Visual Studio 2005. Ser ...Show All