markovuksanovic's Q&A profile

• SQL Server SQL's america date format conflict with australian date format

  Hi I am trying get my VB6 application to insert a record into a table (SQL Express) which has a datetime column but it would not process if the data format is differ to *American Date format*. The date() function in VB returns 15/11/2006 which is in Australian Date format (DD/MM/YYYY) according to my setting in "Reginal and Lanuage Option-> Locale 0> English (Australia)" setting. I get the following error: Msg 242, Level 16, State 3, Server KIT\SQLEXPRESS, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. My computer's locale is set to English (Australia) and I expect the datetime format would follow what is set ...Show All

• SQL Server If WCF can communicate with ServiceBroker?

  hi, I want tomake wcf and service broker communicate with each other,Are there some resources about that thanks in advance Hi, I'm very interested in this solution too. I have the same concerns over MSMQ and Service Broker seems ideal. Would you be willing to share your solution I can host any code for download if you'd like to email it. Best regards, Andy. ( areed@imeta.co.uk ) ...Show All

• Windows Forms Input validation on Windows Forms

  There are similar questions to this but answers so far have been spotty. So far this is my understanding of the built-in "validation routine" (yes, the quotes are there) for Windows Forms , at the 2.0 level of the Framework: Validation us set at the control level, ex. textbox.validating event There are no other validation controls (like the ones in ASP.NET) built into Windows Forms If your application has a single form, say only separted by a tab control for other functionality, you'll have to do some magic, or obtain 3rd party stuff, to get real validation going. Here's what I've experienced and why I don't think Windows Forms actually has a validation system at all - hence the quotes in "validation routine" ...Show All

• Visual Studio Team System Problem with filter Changed by on closed work items

  I have filter that shows all bug and tasks that I did during last week. However if someone close work item I do not see it in my queue. I use fileter "changed by"=@me. Probably it is another way to get all tasks I worked on By the way, does any command line tool that can show work items Here is something to think about: Supposing we have a table called workitem with this data, how would a sql query would look like to achieve what you need you can read about WIQL syntax from samples/documents in VSSDK. Download VS SDK from http://msdn.microsoft.com/vstudio/extend and check out the documents & samples under "VisualStudioTeamSystemIntegration\Work Item Tracking" Here is lin ...Show All

• Software Development for Windows Vista UAC elevation dialog minimized

  Our application launches a separate executable that requires elevation. Everything works fine except that the UAC elevation dialog always comes up minimized, blinking in the taskbar (users tend to miss the blinking taskbar and think the operation failed). I believe this is a problem with Vista, as I have seen the same behavior in the Windows Explorer (Computer) when right-clicking on a hard drive and selecting "Format...". Is there a way to force this UAC dialog to gain focus immediately Or is this a bug that will be fixed in future Vista builds Running Vista build 5472 There are several issues here. 1. GetForegroundWindow is indeed an interesting approach. I have not tried it, ...Show All

• Visual Studio 2008 (Pre-release) exposing a data contract through endpoint

  I want the data contract in the service to be exposed through an endpoint similary as the service contract is exposed through an endpoint. Is it possible. How can i do that. Hello What do you mean by "expose" the data contract on an endpoint Is this what you want [DataContract] class MyData{...} [ServiceContract] interface IGetData{ [OperationContract] MyData GetData(); } If so, you can implement the IGetData service contract on your service implementation and add an endpoint for it. Hope it helps Pedro Felix ...Show All

• Visual C++ Recommended solution with precompiled headers (e.g. StdAfx.obj) and link warning LNK4221

  I'm creating a static library using VC8, which uses a precompiled header through StdAfx.h, which is created through StdAfx.cpp (the one that Visual Studio automagically always creates for you). That is, standard VC stuff. When Debug building the library all is fine but with for Release VC8 outputs: 1>StdAfx.obj : warning LNK4221: no public symbols found; archive member will be inaccessible What is the recommended solution for this The solutions that I've found so far is to either create the procompiled header through some other header/source file or place a dummy public symbol in StdAfx.cpp, which seems entirely silly. What is the "standard way to solve this" This happens when you turn off "precompil ...Show All

• .NET Development How do you make network drives trusted?

  How do you make network drives trusted for a .NET application I have a .NET application in C that runs fine locally, but dies on a network. It seems like I should be able to identify an application as trusted though the .NET Framework wizard, but the utility cannot open my application. Also, what IS unsafe code and how do I identify it I have tried increasing the security with the .NET Framework Config tool in control panels, but when I select the application on the network drive, it tells me that it is unable to "Unable to load assembly:" Caspol gives me a "Success," with the line you gave me, but I still cannot run the application. ...Show All

• Visual C# Tab Controls

  Can someone let me know how i can add a TAB CONTROL to an existing windows form application So, you want to add an existing TabControl to a form You should create a UserControl (and design the TabControl here) and then add the UserControl to any form you want to host the control. Or copy and paste it ;-) ...Show All

• Architecture what's the best way to capture relating one table to many other tables

  Say I have four tables: 1. people 2. products 3. images each of which can be joined in a 1 to many relationship with a fourth table 4. notes I can add n notes to each row in any of the above tables. The options of which I am aware: a) have a separate notes table for each of the 3 tables (peoplenotes, productsnotes... etc.). b) create a join table for each relationship: peopletonotes (with a compound key of peopleid and noteid), etc. c) in the notes table create a generic foreignkey which along with a tabletype can tell you which is the right parent table notes table has: noteid, foreignkeyid, tabletype (which can be either: 'people', 'products' or 'images'), so you might have two rows in notes: noteid ...Show All

• Visual Studio 2008 (Pre-release) How can I change a style setter using code?

  I have several Labels using the same Style: < Canvas.Resources > < Style TargetType = " {x:Type Label} " x:Key = " TitleStyle " > < Setter Property = " FontSize " Value = " 24 " /> < Setter Property = " FontWeight " Value = " Bold " /> </ Style > </ Canvas.Resources > I'd like to change the Setter "FontSize" using some code. Any idea You cannot change a setter (or anything else in a style) once the style is in use. You can create a new style, remove the current style from the resources, and add the new style as the value for key "TitleStyle". ...Show All

• SQL Server DtsBackup 2000 for SSIS??

  Hi everyone, Day in day out I use this application in order to generate dts-backups but I wonder how do the same with our dear SSIS packages Jamie, any idea TIA The silence meant I was doing some work! I had no plans to produce a 2005 version. The way we work with SSIS, developing with local storage not on the server means we should always have copies. The easy integration with source control systems as well as the inability to edit packages in server storage just means that I cannot see the need for such tools anymore. ...Show All

• Visual Studio Tools for Office VSTO word customization

  Hi all: I'm working on a project for a client. The process starts by the user openning a windows forms, entering some data and submitting it to a web service. The web service receives the data as a dataset, opens a ServerDocument object to the document application on the server and fills a cached dataset. The user gets a link to the produced document to download. The user opens the document, the code runs, and the user can see the document filled with the data. So the process works very fine till now. Now I want to be able to actually run the customization on the web server, remove the customization from the document using the ServerDocument object, and send an already finished document to the client, as most of my clients employe ...Show All

• Windows Forms How to make verical scrollbar in gridview wider

  Hi, I need to make vertical scrollbar in gridview and combobox wider because I am building a touch screen application. Any help or links will be appreciated. Control Panel + Display, Appearance tab, Advanced button. Select "Scrollbar" in the Item combobox and increase the size. This will increase the width of the vertical scrollbar for *all* applications, rarely a problem for a PC equipped with a touch screen. ...Show All

• Internet Explorer Development cookie problem

  I have a cookie problem too, i use a real estate script that worked good with IE6 but when i installed IE7 it is not working properly. ie when i access the admin section, depending on the user it let me access to a certain pages, with IE7 it is not blocking pages for agent login. Please advice. Thanks ...Show All