aoky's Q&A profile

• SQL Server the order of insertion of rows into destination is not same as the order of incoming rows

  Hi , i am dealing with around 14000 rows which need to be put into the sql destination.,But what i see is that the order of the rows in the desination is not the same as in the source, However it is same for smaller number of rows. Please help ...i want the order to be same. Wath do you mean with ... the order of the rows in the desination is not the same as in the source The phisical order is determined by the cluster index on the destination table. So if you want to retrieve rows in a different order simply use 'order by' statement. Cosimo ...Show All

• Software Development for Windows Vista problem with execution context and accessing activity data at runtime of a workflow

  Hi, I have a problem on execution of a state workflow, maybe someone can help me: My state workflow contains 2 custom state activities which initializes some data objects when a state is executed. If I run the workflow, state 1 correctly executes and sets it's data object, which is exposed by a dependency property. The data object only is available at runtime not at design time. After state 1 has completed the workflow is persisted and unloaded. Now I send a continue event to the workflow, which causes the runtime to reload the workflow and executing state 2. In the Execute method of state 2 I try to access the data object of state 1, which was set on it's Execute method, but this object is null. To access this object I use ...Show All

• Visual FoxPro Ideas for Desktop Wallpaper using JPEG, TIF, HTML, Etc., vs BMP?

  Hi all; much thanks in advance for any specific or general thoughts on Desktop Wallpaper automation of VFP-9 reports. Now that report listeners (VFP-9) create TIF files from reports I wonder if peradventure it might be easier to automate Desktop Wallpaper from such reports. Currently I use bitmaps as allowed by the dll: PCT_DLL.dll (see below). This works but requires akward 'Print Screen' automation do wallpaper with 'reports\visit\schedmo' && below FUNCTION wallpaper LPARAMETERS a,a1,a2,a3,a4 _SCREEN.AlwaysOnTop = .T. lstate=(_screen.WindowState) IF EMPTY(a1) or EMPTY(a2) &&etc lcBuffer=Space(22)+Chr(0) If GetPrivStr("Screen","WallPaperDimensions","", @lcBuffer, Len(lcBuffer), Cur ...Show All

• Visual Studio Team System Complexity attribute to test case

  We have created a custom test case using VS SDK extensibility toolkit and now we need add a new attribute called "Complexity" to the custom test case type. Any idea on how this can be implemented Thanks Hi, Try the instructions on this MSDN page . Cheers, David Williamson ...Show All

• SQL Server String Format

  Hai I have a table call TimeMgt, and i have got a field name call TimeDifference like this: TimeDifference (varchar(255)) ------------------ 10.230 10.856222 25.355542 85.2455 12.98888882542533 Now need to get this out put TimeDifference ------------------ 10.23 10.85 25.35 85.24 12.98 In this case i cant use cast(TimeDifference as decimal(16,2)) becasse eg : 12.98888882542533 values after writing this sql cast(TimeDifference as decimal(16,2)) gives me this result ===== 12.99====wrong! i want to display like this 12.98 Ho do I do this task what is the best way to format like this Is there any straight methods to do this task sujithf ...Show All

• Smart Device Development PlatformNotSupportedException and the ResourceManager

  Hi all, I hope this is the right forum for this kind of problem... My device is ETEN M600 with Mobile 5.0 and CF 2.0 SP1 (the following error was produced by the previous version of CF 2.0 as well) I'm trying to use the ResourceManager on the most common way - add an image to the resource tab of the project properties and assign it by code to a picturebox. this is the code: Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Me .PictureBox1.Image = My .Resources. Calculator End Sub when the auto-generated code comes to the Dim obj As Object = ResourceManager.GetObject( "Calculator" , resourceCulture) I get a PlatformNo ...Show All

• Windows Forms Rowvalidating event e.Cancel Hangs

  I am using Rowvalidating event to validate and prevent user from moving out of the row unless the validation succeeds. The code looks like below if (dgdTelephones.Rows.Count > 0 && e.RowIndex < dgdTelephones.Rows.Count - 1) { if (dgdTelephones.IsCellNullOrEmpty( "TelephoneType" ) || dgdTelephones.IsCellValueExists( "TelephoneType" ) || dgdTelephones.IsCellNullOrEmpty( "TelephoneNumber" )) { e.Cancel = true ; } } I have 2 gridviews on the screen. This is one of them and has this event. When I move from this grid to any other control no issues, but when i move to the other grid, the system hangs. The processor is 100% used. Any idea whats happening. If I use the cell validating event it ...Show All

• Visual Studio Tools for Office Creating a .msg file

  i have a requirement to extract e-mails from an e-mail archive system and then add them to a document management system (yup - ugly !!!). The document management system likes emails in the outlook .Msg file format. is there any way of creating a .msg file and writitng it to disk (rather than sending it) so that i can get the document management system to read it in environment is vs2003 / .net 1.1 - but .net2 is close....(have it but not in production - and also have VSTools for Office 2005) thx m Outlook.OlItemType.olMailItem is not the right value for the SaveAs method's second parameter. Look at the Outlook.OlSaveAsType enumeration. Outlook stamps the sendername and sent date/time on a ...Show All

• Visual Basic New page windows generated from WebBrowser are sent to back....

  I trying to write a simple Kiosk program using the WebBrowser control. All control widgets are hidden so the user can't close or alter window settings. The problem I have it that if a user clicks on a link that opens a new webpage in a new window, the new form is sent to the rear of the parent form. The only way to get to it is to alt-tab to it. This is a problem because in the final version, alt-tab will be disabled. How can I force the new window to come forward, I have tried using the new_window event to use Me.sendtoback, but no change. Help Jeff your problem is most likely that you are using the 2.0 webbrowser control, which doesn't give you any params in the NewWindow event. What i ...Show All

• SQL Server Programmaticaly associating a schedule with a deployed report?

  I have a report deployment system (in C#) set up such that it takes all the RDL files in a folder and deploys them to the target server. Since many of these reports are computationally fairly expensive, I wanted them to display from a report snapshot, on a daily schedule. Although I know how to do this manually via Report Manager, I wasn't sure which SOAP methods to call on the ReportingServices webservice to make this happen. Anyone have any experience with this or tips Thanks, Arjun It can be set using SetExecutionOptions method ( http://msdn2.microsoft.com/en-gb/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.setexecutionoptions.aspx ) ...Show All

• Visual Studio Express Editions LINK1104 pissing me off

  Express Edition is really starting to piss me off. I have spend all day from 9am trying to get this <cencered words> working just so i can get the openGL thing to work. It does NOTHING but give me compile errors. It wont even work normally before I add openGL files. when I compile it gives me this: 1>------ Build started: Project: test, Configuration: Debug Win32 ------ 1>Linking... 1>LINK : fatal error LNK1104: cannot open file 'user32.lib' First it was all about the stupid windows.h file which was fixed and now it tells me it can't use this stupid user32.lib no doubt getting it to work with openGL will give me as much time consuming trouble as well. I've already tried to copy the glut.h, glut32.dll, and gl ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 2d resets with nuclex fonts?

  I've done the resets from Shawn Hargreaves blog and it's worked in the past, but since i moved over to the nucles font engine these dont work(even in a minimalistic demo setup). The model(s) are still skewed.... anyone have a workaround heres my draw method... i think thats all thats relevant protected override void Draw(GameTime gameTime) { graphics.GraphicsDevice.RenderState.StencilEnable = true; graphics.GraphicsDevice.Clear(Color.CornflowerBlue); mLoader.DrawModel(tank, tankposition, camera.projectionMatrix, camera.viewMatrix); framerate.Draw(); #region 2D Resets graphics.GraphicsDevice.RenderState.DepthBufferEnable = true; graphics.GraphicsDevice.RenderState.AlphaBlendEnable = false ...Show All

• SQL Server Copying tables from access to sql server express

  I am trying to export a databse from access into sql server express. The access database is on a network and the sql server express is on my local machine. Could someone give me setp by step instructions please as to how to export the data from the tables into my sql server express. Thank you very much for your time Access includes a wizard called the Upsize Wizard that can help you do this. Depending on which version of Access you have, it may be on different menus, but last time I saw it it was under Tools | Database Utilities. You may have to install the Upsize Wizard if you don't already have the Advanced Wizards installed. Search the Access help file for information about using this tool. Mike ...Show All

• Visual Studio 2008 (Pre-release) UDP multicast two way binding

  Somewhere in all the searching I have done, I thought I found on this newsgroup a message that describes how to use WCF to do a multicast transmit and expect a unicast response. I thought I bookmarked it. But I can't find it. Can anyone point me to it, or help me with a code sample that will accomplish this Thanks in advance for your help. Kevin ...Show All

• Visual Studio Tools for Office Excel 2007 VSTO Addin UDF

  How do we expose a UDF out of an VSTO v3 addin so that it can be used in a cell Cool! Looks like a C# wrapper could be written to do the VBA code generation behind the scenes as well. Thanks, Andrew ...Show All