SAD1's Q&A profile

• SQL Server Using SQL2005 XML Column as a Report datasource

  Hello all. I am trying to create a report based on XML stored in a table. The data is stored on a SQL 2005 server so I am using the XML data type for the column. Basically the xml looks like: <Changes version = "2.1"> <Change name = "ChangeType1"> <Change name="PaymentID" id = "someuniqueidentifer" displayid = "PaymentID" type = "Edit"> <Change name = "PaymentStatus" oldValue = "Release" newValue="Hold"/> </Change> </Change> <Person Name = "John Doe" Dob = '1/1/1975' /> <Account Type="Other" Accountid="38317830948734902-01" StartDate = &q ...Show All

• Windows Live Developer Forums PushPins above PolyLine

  Hi I'm wondered if someone could give me a quick pointer on how to solve this problem… I have a VEMap upon which I add a few PushPins and draw a PolyLine. Unfortunately the PushPins appear under the PolyLine which both looks a bit crappy and the PushPins are hard to select. Eg. http://www.businessgeek.com/ve/ (Click Draw GPS Trace) Do you know how I can get the PushPins to appear above the PolyLine As you will see I’ve even tried a GeoRss layer but that suffers the same problem. I’d really appreciate help with this. Many thanks Jonathan What order are you actually adding them to the map map.AddPushpin(.... map.AddPolyline(... Are the ...Show All

• Visual Studio Tools for Office Can I not develop Outlook 2003 add-ins after having installed Office 2007 ?

  I have an old outlook 2003 addin project, which I now want to maintain. However, since the last time I opened the project in Visual Studio I have installed Office 2007, which required Outlook 2003 to be uninstalled. When I now try to open my project I get this message: "Microsoft Office Outlook 2003 SP1 or newer is not installed on this computer. You must install a version of Microsoft Office Outlook 2003 that supports Microsoft Visual Studio 2005 Tools for the Microsoft Office System projects." And when I continue to try to open it, the addin project in the solution explorer will be "unavailable" saying that "the project file cannot be loaded". As far as I understand, it is impossible to have a side-by-s ...Show All

• SQL Server How to get thru security of Sql server http endpoint?

  I have write the coding to create http endpoint in the sql server 2005, but if i type my pc ownself ip address (ex, 192.168.0.110) to connect to the sql server http endpoint, it prompt me for Username and Password. I didn't set any username and password before, what should i type Or what should i do to pass thru this authentication Thanks in advance. Cheers, Winson Hi Winson, For security reasons, the SQL Server 2005 http endpoints for Native XML Web Services require the client application to send user credentials. By default, the user account who created the HTTP endpoint will have access to connect to the endpoint. Users of the sysadmin role will also have access to the endpoint. All ot ...Show All

• Visual Basic Can SOMEBODY HELP?

  Dear all, i develop my VB AP,but now i have a trouble.... i want put a new control object in my form (my form already put many control object) when i want add new ....it say its up limits so i can't ad any control object.. how can i slove thos problem thanks a lot . dear sir , i am not means after complie to exe then run it happen. it when i in VB develop stage can u help me how to do u mean setting in VB Software i don't know understand how to do that. thanks you ! ...Show All

• Visual C# debugging tooltip

  Hi all, don't know if you can help me,when i am debugging an application in VS2005, the hover and show variable value is not showing! if the variable is a class or something that results in the IDE showing the datatip that works fine, yet simply hovering over a bool variable should show true or false in a tooltip like display doesn't the cursor is the "I" bar i see the cursor flash momentarily as if it's trying to show the value and then resets to normal view as if the time-out for the display = 1 ms! is this something in the IDE or please forbid do i need to re-install everything any ideas Please. You don't realise how much you use a feature untill it's no longer available! foun ...Show All

• Visual C# How do I limit ticks is a checkListBox to one at a time?

  Hi, I am trying to use a checkListBox to select one of three options. I only want any one option at a time. I have found the following 2 instructions, which, I would have thought, would have done what I want, but I can still check all three boxes. this .checkedListBox1.CheckOnClick = true ; this .checkedListBox1.SelectionMode = System.Windows.Forms. SelectionMode .One; Incidentally, I tried this .checkedListBox1.CheckOnClick = true ; this .checkedListBox1.SelectionMode = System.Windows.Forms. SelectionMode .None; and this did whatI expected, I could not check any of the boxes. So, any one know what I am doing wrong Many thanks for being there John. You can iterate ...Show All

• Windows Forms Help! "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records"

  Help! I have a Access 2003 Database that holds info like "customer name" "phone number" etc. When I enter that info and then click new record then go back to the previously created record and add some more information in the other text boxes ("address", "age", etc) I get the following error: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records and when I click on details then row, I get this: '((Help_Desk_Center.HDC_DataDataSet.Table1Row)(((System.Data.DBConcurrencyException)($exception)).Row)).Customer_called_on' threw an exception of type 'System.Data.StrongTypingException' What is all that and how do I fix it, get around it, ignore it, or what ever I need to do Thanks for ...Show All

• SQL Server Select *

  I know Select * has a performance impact and its better to use Select Column1, column2... But is this also true for Select * from #TempTables. I had a answer in one of the other forums that #temptable dont have indexes therefor there wont be any performance impact. Is this true ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XACT won't set LoopEvent property

  Hi, I have a problem getting sounds to loop from within XACT. I open my project, open the Sound Bank window, select the sound name and highlight Play Wave - this causes the Event Properties panel to reveal LoopEvent, amongst others. Now, when I try to open the combo box to set "No" to something else, I get a dialog saying: "Object reference not set to an instance of an object." So, two questions: 1. Is there a way around this bug in XACT 2. Preferably I'd like to set the sound to loop from within my code. Is there a way to do this in Beta2 Many thanks =) Mark Aha! Our testers have indicated a potential source of this issue. Apparently the XACT authoring tool ...Show All

• Windows Forms Pagination feature for Windows forms grid.

  Hi, Can any one let me know how can we implement the pagination feature for windows forms grid. I have got some information from the below links. 1. http://support.microsoft.com/kb/307710/EN-US/ 2. http://aspadvice.com/blogs/jlovell/archive/2004/08/28/1986.aspx The first one loads entire data at once and then shows the data in the form of smaller chunks, which i dont want to do. and the second one requires logic to be written in dbobjects. Iam just wondering is there any better way of acheiving the same . Thanks in advance M.S.Basha Hi, how about using DataGridView's Virtual Mode http://msdn2.microsoft.com/en-us/library/2b177d6d.aspx Then again... yo ...Show All

• Visual Studio Express Editions listbox oadate format

  VBEXPRESS: I've got a list of calendar dates in a listbox. When I sort it, it sorts illogically, due to the 1/2/2006 vs 11/12/2006 for instance (no leading 0's on "single date" numbers). I'll need OADate anyway, so I'm trying to do a: Dim n As Integer = 0 Dim dateShown As DateTime = CDate (ListBox5.SelectedItem) For n = 0 To (ListBox5.SelectedItems.Count - 1) ListBox5.SelectedItem = dateShown.ToOADate() '.ToString Next I can't seem to understand how to utilize the code to take each dated item in the listbox5 and change it to a OAdate item. Can someone point the way Umm, prolly not. OADate is an ancient Date format, going back to bad ole' days of COM. Back then, it used to be a floating ...Show All

• Software Development for Windows Vista WASAPI IsFormatSupported and exclusive

  Hello Im getting tired of googling about WASAPI and only finding hits on my OWN code :) What are we supposed to do if we want to do exclusive mode and IsFormatSupported just returns AUDCLNT_E_UNSUPPORTED_FORMAT, and doesnt even provide a "closet match". Are we supposed to try all millions of permutations of members in WAVEFORMATEX(TENSIBLE), and at the end, after failing all of them, realise that this device doesnt do Exclusive at all I dont know about you but i would kind of like to get the equivalent of GetMixFormat from an exclusive mode device, at least its "prefered" internal format. Cheers Hello. And thanks for the added info. Sorry about the shared vs excl ...Show All

• SQL Server Roles & Responsiblity of DBA

  Dear All, Can any one tell me whats a roles and responsiblity of DBA in SQL Server in Details The general definition would be "maintain the SQL Server" but as Andrea points out there is much discussion about this in the world. I would recomend doing a search on something like "what does a dba do" and see what it brings back. I'm sure you'll find hours of reading enjoyment. If you give some context to your question (i.e. why do you ask ) we can probaly give you a better answer. Mike ...Show All

• Smart Device Development Pocket PC Phone WM 5.0 Device emulator Internet Setting "Automatically detects setting"

  I am working on a Pocket PC WM 5.0 application.Application is working fine in the Pocket PC Phone WM 5.0 Device emulator. No In My application I have to connect to internet. My system is on LAN.On my Internet connection setting Automatically detects setting check box is check. In the device emulator I don't know how to configure setting so I can able to browse in the deve emulator. Please Could Any body help Has anyone gotten this to work yet PSS used the emulator with WM5 recently with me while troubleshooting an ISA problem, so I know it has to work. No matter what I try (including the cradle option from Device Manager) gives me the same... "Your internet connection is not configured properly. Please ve ...Show All