Beuhla's Q&A profile

• SQL Server Multiple Notification instances with a single database

  I am attempting to create multiple Notifications instances, however, without the additional databases. I want to be able to have multiple instances use the same single NSMain and Application database. I've been successful at creating a single NSMain database for multiple instances by adding the following line in the InstanceConfig.xml: <NotificationServicesInstance xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.microsoft.com/MicrosoftNotificationServices/ConfigurationFileSchema"> <Database> <DatabaseName>HRMS_NotificationsNSMain</DatabaseName> <SchemaName>%NSMAINSchemaName%</SchemaName> </Database ...Show All

• Visual Basic Using Typed Datasets Efficiently

  I have a strongly typed dataset, residing in my main form. This means that I can access the tables and columns contained within it by name instead of index. Very handy indeed. What I would like, is to access my dataset from my class declarations in the same way as this. The new method of my class overrides the default and passes the dataset as a parameter: Public Sub New ( ByVal ds As DataSet) Thus allowing the access to use a foreign dataset from my class. However, I cannot seem to get VB to allow me to access the tables and columns by name, only by index. I know that to allow named access I need to apply the .xml schema to the dataset in the same way as VB’s auto-generated code has done, but try as I might I cannot seem to ...Show All

• SQL Server Assign XML to variable

  How do I assign XmlDocument results to a variable (so that I can pass it to a sp) I know that the following code works.... select * from tblUsers where userId = 1225 for XML raw It returns "<row UserId="1225" LastName="Evans" FirstName="Stephanie" MiddleInitial=...."), which is what I want. But when I try to assign it, I get an error "Incorrect syntax near 'XML'." declare @strXml nvarchar(1000) set @strXml = (select * from tblUsers where userId = 1225 for XML raw) Ideas It is not possible to do this in SQL Server 2000 using TSQL. You cannot consume the XML output on the server-side in any form. This is possible in SQL Server 2005 since ...Show All

• Visual C# Viewing runtime errors

  I'm currently using NotePad to write a simple C# application. I simply use cs.exe to compile my windows application. How can I view the runtime errors when using this approach The compiler does not catch the runtime errors obviously. My .exe simply stops executing without any error messages. I do notice one thing, in my task manager I notice that a process called DW20.exe runs for a brief second and terminates. Is the runtime error being logged somewhere in Windows Thanks in advance. Ray Ray C wrote: Unfortunately, I'm new to C# so I don't know how to do a Try-Catch I tried... try{ .....my code } catch (Exception ex){ MessageBox.Show ("Error is: {0}",ex.De ...Show All

• Visual Studio 2008 (Pre-release) WCF Client can not process secured response sent by BEA Aqualogic service. [** An Interop issue **]

  Hi Community, I have done some earlier post on the interoperate with Aqualogic BEA Secured service.I have created two x509 certificates using makecert.exe tool. The WCF client is configured corectly to send the secured request. The BEA side logging is turned on. The BEA service can see the secured message and decrypt it successfully. The response sent from BEA side is also logged successfully. But at the WCF client side to read the response it throws the following exception. +[System.ServiceModel.ProtocolException]   {" The content type text/xml; charset=us-ascii of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported ...Show All

• Visual Studio Team System CA1305: How to correctly set string.format(..) lines.

  Heya folks, I'm getting a lot of CA1305 warnings when i use the string.format(..) without an IFormatProvider. Of course i can suppress this but i try very hard to never supress any warnings. So lets look at some code to see what is the best practice with string.format(..), please. 1) addressData.Id = Convert .ToInt32(dataReader[ AddressData ._databaseTblAddressIDAddress]); 2) addressData.PostalCode = Convert .ToString(dataReader[ AddressData ._databaseTblAddressPostalCode]); 3) throw new InvalidOperationException ( string .Format( "The addressData instance has in invalid ID [{0}]." , address.Id)); Ok - three examples all throwing warnings. What is the best practice to remove these warnings What options are there t ...Show All

• SQL Server Why can you not create a Query Notification subscription in TSQL?

  The title says it all. You can do it from a ADO.Net client so why not from TSQL. It all uses the service broker stuff so why not You can not do it from an internal CLR assembly. This is explcitly block. Secondly the comments in the article don't answer the question how you get the Engine to start monitoring for changes to a query via TSQL ...Show All

• Windows Forms Cannot add table adapter to datatable

  If I have a dataset in my project, and I've added a datatable to it, when I right click on it the option to add a tableadapter is greyed out. It seems as though I have to add a tableadapter to get a datatable with tableadapter connected to it. What if you already have a datatable in your project and want to add a tableadapter to it I had a recommendation to install SP1, and I did, but it did not fix the problem. No response since then. Even though we have this new TableAdapter class, doesn't mean we have to use it. I haven't and I don't intend to. In fact, I'm a bit irritated that it automatically gets included in Typed DataSet generation ... unless there's some way to turn that off. I haven't had the ch ...Show All

• Visual C++ string, objects and arrays

  Hello. I need help solveing this problem... -----------------------Player.h------------------------------- 1 - #include <string> // Class Shot, struct Keys, Position and Enum Direction are all here... 35 - class Player 36 - { 38 - private: 39 - Position _p; 40 - Direction _d; 41 - Keys _k; 42 - Shot _s[]; 43 - string _m[]; 44 - 45 - public: 46 - Player(int); 47 - void SetMap(string m[]); 48 - } ----------------------------Player.cpp-------------------------- 12 - Player::Player(int s) 13 - { 14 - _p.X = 10; 15 - _p.Y = 10; 16 - _d = LEFT; 17 - _s = Shot[ s ]; 18 - } 19 - void Player::SetMap(string m[]) { _m(m); } ------------------------------------------------------------- I am getting lots of errors ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. can i use visual studio .net professional?

  Can i use visual studio .net 2005 professional with xna or do i have to use xna game studio express. and if its possible to use vs professional would it still be better to use the game studio sorry if this question has been asked, i did a search and nothing came up. thanks for any help Just to clarify, in order to build anything for the 360, we'll need to either: 1. downgrade to C# Express or 2. try and get Express and Visual Studio Professional to install side by side Is that what it boils down to ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Software renderer for Managed DX9?

  Is there a fast software renderer that is DX9 compatible I'm looking into Pixomatic and SwiftShader, and while they are D3D9.dll replacements, I am using Managed DirectX from C#. Is is even possible to make Manged DirectX use an external D3D9.dll If so, how would I make it work with either Pixomatic or SwiftShader If it is not, can anyone suggest a good sw renderer we can use We are trying to make a sw version to run on laptops that don't have fast video chips. There is a real pluggable software device available from Microsoft RGBRast: http://www.microsoft.com/downloads/details.aspx FamilyID=57d03491-6c49-4429-bff7-130408b5f410&DisplayLang=en But as ZMan already said the m ...Show All

• Visual C++ Problems with VS2005

  Following a mini-rant regarding the quality of VS2005 on the DirectX Dev list, it was suggested that discussion was continued on these forums, so I'll try and quantify my earlier rants/complaints with real problems I've encountered over the last six months. It should be noted that all these problems I've encountered are with the Professional version of Visual Studio 2005, building native C++ projects targeting x86, x64 and Xbox 360. My PC is a dual core 2Ghz AMD with 2GB of RAM and an X800 ATI video card. IDE Aside from the performance issues, which I'll get to in a minute, these are the main problems I have with the IDE in VS2005: Configuration Manager is broken. Really broken. Changing platform or solution configuration l ...Show All

• Visual Studio Authentication for Report Server

  Hi All I am working on a project where I am using Report server control 2.0 to display Reporting services reports. I am having a authentication issues. In this application User will authenticate and then browse the application. If I use the following code my report viewer controls works fine. ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerCredentials ( "Administrator" ," pass@word1 ","Contoso" ); But I dont want to pass UserName/Password. Is there any way using which I can just say something similar to System.Net.CredentialCache.DefaultCredentials I am using ASP.net 2.0. Any help would be appreciated. CredentialCache ...Show All

• Visual FoxPro testbox

  How to u change textbox property to date any ideas Thanx for the help ...Show All

• SQL Server How to create CHECK CONSTRAINT with SMO

  I am using C# and SMO to create tables. Have figured out how to create the tables and foreign keys. but not how to add a Check Constraint in code as in: ALTER TABLE [dbo] . [BackgroundChecks] CHECK CONSTRAINT [FK_BackgroundChecks_BackgroundCheckTypes1] Any help is appreciated. OK, got it. Much simpler than it should have been given the amount of time spent. string sqlCmd = "ALTER TABLE [" + myTable.Name + "] CHECK CONSTRAINT [" + myForeignKey.Name + "]" ; myDB.ExecuteNonQuery(sqlCmd); ...Show All