Spider-link's Q&A profile

• SQL Server Design Question - Is Integration Services the way to go ??

  we need to transfer data from a OLTP SQL 2005 database to the backend OLAP Datamart and Datawarehouse databases. This data is a long string of XML (from Infopath), out of which we need to extract the data values and populate the Datamart and datawarehouse. Ideally this will be an automated process - and will also have the flexibility to cater for changes in the xml structur. we would also like the Analysis services cubes to be "updated" in real-time as the transfer occurs. is Integration Services the way to go Buck thx for this the destination datamart stores the latest version of the case (i.e. the latest record), the destination datawarehouse stores all of the versions ...Show All

• SQL Server Create Time dimension Year, Week, day problem

  Hi, I have a problem when creation a Time dimension Year, Week, day , The week does not start on the correct date eg. Week 42-2006 should start on 16 th. october and end on 22 th october, but in this case it starts on the 15th october and ends on the 21 october. So what happens is that it starts 1 day before it actually should. This is my Time Dimension: DatePart(year,"dbo"."fCapacityLedgerEntry"."Posting Date") DatePart(week,"dbo"."fCapacityLedgerEntry"."Posting Date") 'Week ' + convert(CHAR, DateName(week, "dbo"."fCapacityLedgerEntry"."Posting Date")) convert(CHAR,"dbo"."fCapacityLedgerEntry"."Posting Date&quo ...Show All

• Visual Studio How to get the filename of a SolutionItem?

  This may sound weird, but how do I get the filename of a SolutionItem using the DTE What I have is a SolutionFolder containing a text file for example. When I get the ProjectItem of the text file, the Properties are null and there seems to be no way to get the filename. However when selecting this ProjectItem in the SolutionExplorer, I can see the filename in the properties ToolWindow. So there has to be a way to do this, but how Regards, Jens How are you getting the ProjectItem of the text file Which project system are you using SolutionFolder are a bit different as the files could be outside of the current projects scopes. You can use the FileNames property on the solution items to figure out ...Show All

• Software Development for Windows Vista Wuaueng.dll -- Help!

  I have Windows XP and recently downloaded a bunch of updates from Microsoft (including SP2) and upgraded to IE7. Now, several strange things are happening. First, whenever I try to restart or shut down, the computer refuses to do so and instead tells me that Windows Explorer has encountered a problem and needs to close. When I click for more details, the ModName at issue is wuaueng.dll. Second, if I try to go to "properties" after right-clicking on My Computer, the same kind of window pops up, except this time it says "Run a DLL as an App has encountered a problem . . . ." Again, in details, the ModName is wuaueng.dll. Third, I cannot access the Windows Update webpages. Fourth, IE no longer connects to the I ...Show All

• Visual C# Converting from Javascript to C#

  Hi everyone, not sure if this should be in the General Visual C# forum. I have been trying to find code to convert from British National Grid map coordinates on Latitude/Longitude coordinates, and have found some in JavaScript. However, when converting it to C#, I came accross one line that I couldn't figure out, as I know hardly any JavaScript. The line of code is: var geo = { latitude:phip, longitude:lambdap }; I know that "geo" is a double, and so "var" is to be replaced with "double", but I am unsure of exactly what the rest of the line is doing. What are the colons for And how do I represent this in C# Any help is much appreciated as this has been driving me nuts for a few days! Thanks, ...Show All

• Software Development for Windows Vista IE compatibility test tool

  hi, can anybody tell me that how to fix the "CSS fixes" issue that come in the IE compatibility test tool in ACT when we open various sites. thanx in advance divya Hi, Are you referring to the CSS bugs that IE 6 has I mean the ones posted at http://www.positioniseverything.net/explorer.html If those are the bugs you are referring to, they have been fixed and the fixes are available via the December 2006 Windows update. Also IE 7 is recommended since all those CSS related issues are taken care of in IE's latest edition i.e. IE 7.0. Regards, Amol. ...Show All

• Visual Studio Express Editions DataGridView Modifications

  I want to be able to input a numeric value into the .Text = "Value" field. On the Datagridview table. I need to be able to input a value in each field individually Here is my current code: ------------------------------------------------------- Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ' Initialize the button column. Dim buttonColumn As New DataGridViewButtonColumn With buttonColumn .HeaderText = AssignmentNameTextBox.Text .Name = "Assignment" .Text = "Value" ' Use the Text property for the button text for all cells rather ' than using each cell's value as the text for its own but ...Show All

• Visual Studio how to run SQL Server 2005 , when i have Complete Visual Studio.NET 2005

  Hi, Can someone please help me how i can run SQL server 2005 , when i have VS 2005.NET installed. I have SQL Server 2005 also but i get a menu for SQL Server 2005-> Configuration Tools->Configuration Manager -> Error and usage Reporting -> Surface area Configuration Also in ControlPanel i get add/remove programs MicroSoft SQL Server 2005 294 Mb Microsoft SQL server 2005 Mobile [ENU] developer tools 66.95 MB Microsoft SQL server native Client 4.16 MB " " "setup support files 20 Mb " " "VSS writer 0.66MB Also i have Microsoft Visual Studio Pr ...Show All

• Software Development for Windows Vista Comments, Suggestions, Features and WHAT THE HECK WAS THAT!?

  Hopefully, that got your attention. We're starting to sketch out designs for the next version of CardSpace. I'm starting this thread and makin' it sticky so we can continue a dialog around new features. Now, I realize that CardSpace ain't even out the door yet, but the planning is beginning. I can't promise anything, but I can tell you that I'll listen, and I'll bring everything to the team. So, What do you want to see in the Next Version of CardSpace g Garrett Serack | Program Manager |Federated Identity Team | Microsoft Corporation blog: http://blogs.msdn.com/garretts I was considering doing some research on what it would take to create a system for the easy transfer and safe public u ...Show All

• .NET Development This Error Appears: Format of the initialization string does not conform to specification starting at index 0.

  I have saved the database connection string to a key named 'ConnectionString' allowing to access it by calling 'configurationSettings.AppSettings("ConnectionString") But a red line comes under the configuration in the part of the : 'configurationSettings.AppSettings("ConnectionString")'. When i run it this error appears: Format of the initialization string does not conform to specification starting at index 0. and says: Line 4: Public Shared Function GetCategory() As SqlDataReader Line 5: Dim connection As New SqlConnection(connectionString) Line 6: Dim command As New SqlCommand("GetCategory", connection) Line 7: command.CommandType = CommandType.StoredProcedure Line 8: connection.O ...Show All

• Visual Studio Tools for Office MailItem.Open event handler..which Item??

  My VSTO Outlook add-in registers a handler for the "Open" event of certain email messages. This handler has no parameters, so when executed, how do I recover a handle to the MailItem object that was opened Many Outlook events send no arguments to their handlers...am I missing an obvious way of obtaining the object that is the source of the event being handled -Allen, new to VSTO Someone in support pointed me to a 3rd pary product Add-in Express. My add-in is now pretty far along based on that technology, and it wraps the events and passes the relevant objects to the handlers. BTW I just posted a question to this VSTO thread about accessing a MailItem's "Internet header" which MailItem doesn't ...Show All

• Visual Studio Tools for Office How to create XMLNodes on runtime -word?

  Hi I'm using VSTO 2005, Word Document, C#. I want to create some XMLNodes on runtime, how do i do that To be more specific, i have the an Schema attached to the document, with an element that can be repeated (minOccurs = 0 and maxOccurs = unbounded) that is recognized as XMLNode s and it's about a list, something like: Item 1 subitem1 subitem2 subitem3 So i need that when i click on a button at the end of the list, i can create an "Item 2" and all its subnodes how do i do that with code in C# Thanks for your time Odd, I'm getting them like this <bookstore><book></book><book></book></bookstore> with the code below. ...Show All

• Visual Studio Express Editions A Puzzle?

  Below is the code, and you can press Button1 as fast and as often as you like to get a list of 6 random number from 1 -7 but if you change this intNumber = Int((7 * Rnd()) + 1) to this intNumber = Int((6 * Rnd()) + 1) it still works by giving a list of 6 random number from 1 -6 but it only does it once Public Class Form1 Dim intNumber As Integer Dim arrNumber(0 To 5) As Integer Dim i, x, y As Integer Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ListBox1.Items.Clear() For x = 0 To 5 Start: Randomize() intNumber = Int((7 * Rnd()) + 1) For y = 0 To 5 If intNumber = arrNumber(y) Then G ...Show All

• Internet Explorer Development Looking for custom button in C#

  Hi All ! I have something like this in script, but I am very disappointed about the limits. Is there a C# sample implementation for a custom button I have to copy something into the clipboards, which does not work in script;Additionally, having more then one action on the button with a menu or have a hierarchical context menu would be the best. Thanks a lot, mabra You can use a COM or EXE implementation as a button for IE. Doesn't make a difference what language you use. User security settings may be blocking your clipboard access from script. Try windows scripting i/o javascript.. there are also utilities that will compile your windows scripts to executables. Regards. ...Show All

• Windows Forms How to make fix digit in textbox

  Hi All, Anyone can help me to create a code to make fix digit in the textbox. For example, when i input 1 in the textbox, automatically when i press enter key in the text box will generate : PWD0001, so when i input 133 it will generate PWD0133. Thank a lot. ahmad bhai he wanna make this sort of string PWD0001 by ur method if he enter 1 and then press enter key then he will get PWD1 not PWD0001 sooooooooooooooo ahooooooo think before to criticize brother ...Show All