espirit's Q&A profile

• Microsoft ISV Community Center Forums Bloomberg + Execel = True?

  Ok my situation is like this: I have a computer that runs Windows XP Professional. On the computer I have a Bloomberg subscription i.e. I have an ordinary monitor, but a Bloomberg keyboard and it is "true" Bloomberg subscription (it is not the Bloomberg website I am referring to). I have an Excel spreadsheet that is connected to Bloomberg and updated once every day using a DDE connection. Now will this work even if the Bloomberg program is closed If not so is there any other way of creating a link that works even if the Bloomberg program is closed The connection works through a macro that runs on a prespecified time every day. The code for opening the Bloomberg link is: channelNumber = Application.DDEInitiate(app:="BLP&qu ...Show All

• Windows Forms Getting the xp styles to work on windows 2000

  Hi Is it posibble to somehow getting the windows xp control styles (buttons tabcontrol etc.) implemented in windows 2000 I dont know if you can do something in the compilation so that the controls are compiled also. My program is made in vb2005 with a ot of the xp styles, and it looks really crappy in windows 2000. It's not easy to sell if every buyer has to upgrade to windows xp when they still have to pay full price even if they have a full windows 2000 license.. I myself is not a fan of windows 2000, but some of my potential buyers only have windows 2000, because it is expencive to change OS. no its not possible since Windows 2000 was developed before Windows XP, the features etc... are XP ...Show All

• Visual Studio Express Editions reading data

  i need to know this quickly (job interview) 1. how do i read from a text file to a table (say.... access) 2. how do i read (using recursive methodes) from a table to vb.net 3. how do i read from xml to vb.net i meant the second part was a link to C# anyway.... 1. i dont suppose you could show me both to a dataTable and ms access 2. ok.... can you show me how to do it in code ...Show All

• SQL Server Report Builder and NULL values

  Hi, I am trying to create a report with Report Builder, using a simple data model residing on SQL2005 reporting server. The problem that literally drives me crazy is that I can't find any way to handle NULL values in my report. Say, a table has 3 numeric columns, and I need to create a formula to make a sum of those 3 columns. This would be an ordinary sum for the same entity, not an aggregate. So I create a new formula with following body: Field1 + Field2 + Field3 The problem is, each one of the 3 columns can have NULL values, and if any column actually is NULL, I end up with empty sum value, instead of having sum of those columns that do have values. What I need is one of the following: - a way to check for NULL values ...Show All

• SQL Server DSV Refresh

  Hi, I have an odd problem with the creation of objects in the data source view using AMO. I added some tables and relations with AMO and everything seems to work well. Then, using Analysis Services I selected the data source view and refreshed it. The form that notifies the changes in the data source view showed a lot of changes that I didn’t understand, costraints created and removed, fields changed and other operations that I didn’t made... I try to do the refresh with AMO using all the update and refresh options I found but with no results. Every insight on the question will be of great help. Thanks This is an extract of the data source view refre ...Show All

• Visual Basic First & Last Char

  Hi Need help. I have a RichTextBox, and I wont to get the First and Last Character from this RichTextBox. For Example: If my RichTextBox have "Hello World" MessagBox must Display "Hd". Thank you Hi, try the following code: Dim text As String = RichTextBox1.Text Dim firstLast As String If (text.Length > 1) Then firstLast = text(0) & text(text.Length - 1) End If Andrej ...Show All

• SQL Server Problem connecting to external SQL Server

  Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem... I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server to connect to this external SQL DB... How easy! Well not for me .. This is the error Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied I know its my VPS causing the problem, as I asked a friend to see if he could connect to it via his server and the forum worked straight o ...Show All

• Windows Forms Need help on RowFilter in windows forms datagrid

  Hi, I need help for 2 problems. Problem1: I need to filter a table with rowfilter. See the code below. string cellValue = gridView1.GetRowCellValue(selectedRow[0],DEPT_NUM).ToString(); int Value = Convert.ToInt16(cellValue); DataView myView = myDataSet.Tables[2].DefaultView; myView.RowFilter = ("DEPT_NUM = Value"); In the above code the DEPT_NUM column is of type int. I need to filter the table based on Value. But it shows that there is no column named Value. But if i change the last line as myView.RowFilter = ("DEPT_NUM = 2"); it works fine. I need to know how to filter the DEPT_NUM based on Value. Problem2: How to assign a value to a column in the datagrid. For example consider a ...Show All

• SQL Server table items custom sort

  hello i am currently trying to port a "Business Objects" report to SQL Server Reporting Services. in B.O., there is a possibility to define the order of the table values by previewing the table values and moving them up or down. Example : the dataset contains data for 3 items, so in the Custom Sort window, I will see these 3 items and I can order them by moving them up or down in a listbox. is this possible to do in Reporting Services i want to order the detail lines based on the values contained in a column. for example column A has soda brands (coke,pepsi, dr pepper), as i work for company dr pepper, i want the dr pepper detail line to be in first position, then i want peps ...Show All

• Windows Live Developer Forums Convert Local Live Polygon coordinate to Lat/Long

  First off, MS release of Local.Live is great in the sense that users can now zoom in, highlight an area, and then share that highlighted area via the polygon feature of scratch pad. My question: Is there a way to go from local.live's coded polygon coordinates to lat/long We'd really like to collect polygons drawn on local.live and re-use them in a VE implementation. However, the polygon points are encoded and VE wants lat/long points. Ultimately we could try to re-build WLL, but trying to build the scratch pad looks tricky. For example, given this URL: http://local.live.com/ v=2&sp=Polygon.pfy1bp5c6008_pfy19f5c63q3_pfxt1f5c63t0_pfxsrx5c5zst_pfxty85c5z46_pfy0j75c5z2t_pfy19f5c5zkz_pfy1bp5c6035_pfy1bp5c6008_Test%20field____%2 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. D3D10: off-screen surface

  Hello. How to create off-screen surface in Direct3D 10 and then copy its contents to the back buffer The way it was done in DX 9: CreateOffscreenPlainSurface to create surface and UpdateSurface to copy image. Could not find it in the documentation. Please hlp me with the rendering. I'm trying to create texture from .BMP file and then use GetBuffer method to get pointer to back buffer as a TextureResource, then copy the picture from the texture to the backbuffer using CopySubresourceRegion method. Just code errors or my conception is wrong from the very beginning // global variables D3DX10_IMAGE_INFO g_ImageFileInfo; ID3D10Resource* g_pTexture2d=NULL; ID3D10Resource* g_pBuf2Cop ...Show All

• Visual C# How to Change the Security settings of IE programatically

  Hi All, I want to change the security level of the Internet Explorer for Internet Zone to medium.By default its value is high for Windows Server 2003. I want to do it through my C#.net application. How this can be done Thanks, Nupur Hi, Yes it is solved. I was able to modified the CurrentLevel value in the HKEY_CURRENT_USER\software\microsoft\windows\internet settings\zones\3 using the RegistryKey class. Thanks, Nupur ...Show All

• Visual Basic BackgroundWorker - Best way to wait during CancelAsync()?

  Hello, What is the best way to wait for the BackgroundWorker during CancelAsync() I have tried a simple loop like this: While BackgroundWorker.CancellationPending Application.DoEvents() End While This works most of the time, but sometimes I get this error: An exception of type 'System.InvalidOperationException' occurred in System.Windows.Forms.dll but was not handled in user code Additional information: Operation is not valid because it results in a reentrant call to the SetCurrentCellAddressCore function. Thanks for any ideas, Tom Why do you need to wait for the background worker's cancel to be completed The BackgroundWorker.RunWorkerCompleted event will be raised whe ...Show All

• SQL Server Can I Use Non-empty Behavior for These Calculated Members?

  I still find myself extremely confused about using the non-empty behavior for calculated members. We have a series of calculated members that we refer to as "Velocity", such as "Velocity Sales". The basic definition for these velocity measures is to get the total from the previous 63 business days and then annualize that total (i.e. multiply by 4), with the 63rd business day belonging to the previous month. For example, Velocity Sales for any day in September 2006 would be totaling the sales $ for the business days in the range of 06/05/2006 through 08/31/2006, and then multiplying it by 4. Perhaps not surprisingly, these measures result in extremely poor performance. Since I'm confused on the non-empty behavior, this p ...Show All

• SQL Server schedule a trace

  Can someone share an example of how to schedule a trace I have seen some stuff online that used xp_trace extended procedures however examples are not detailed enough for me to create a script of my own. So if someone can help me with their knowledge that will be great. thanks See SQL Server 2005 Books Online topics: Scheduling Traces http://msdn2.microsoft.com/en-us/library/ms187656.aspx Using SQL Trace http://msdn2.microsoft.com/en-us/library/ms191443.aspx ...Show All