USJOHN's Q&A profile

• SQL Server Absolute Beginner in SQL 2005 EE, needs help.

  Hi everyone. Using C# 2005 EE with SQL 2005 EE I am really new to SQL, got qns here. Can my program with SQL database run correctly on another com using win xp home edition, with only C# 2005 EE installed Is it compulsory for every table in a database to have a primary key Can I extract a data from a specific cell in a database table(click button get data) How do I go about doing it (the simplest n straight forward method) Many Thanks in advance. Regards, dragoncells.   No and no as the answer :-) "That means Xcopy deployment is obsolete nowadays." Seems that my description was too fuzzy. It is absolutely nice that you can do Xcopy deployment. Assuming that you want to upda ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I need e-book for directx programming

  hi.... i need e-book for directx programming on C#... please help me! If you need eBooks then you can find both of Tom Miller's book on O'Reilly's Safari website http://safari.oreilly.com - you get a month free then its reasonably proced per month after that. ...Show All

• SQL Server SQL Everywhere - Utter Dissapointment!

  On the surface, SQL Everywhere seems like a great way to reuse code from an enterprise app using SQL Server in a SMB or home office app needing a more But in experimenting, I have been utterly dissapointed in SQL Everywhere. Key reasons for my dissapointment are the inability to write Database Independent codeusing System.Data.Common . There are instructions for doing this in the MSDN. But do they only apply to non Microsoft Databases I have the following grievances. Are these things that Microsoft plans to fix, or do they plan to leave SQL Everywhere as an inferior product 1. Limitations of query language are not well documented nor understood. SQL Everywhere uses a "subset of Transact-SQL syntax". I have not seen it do ...Show All

• SQL Server Error when attempting to use Windows Authentication

  When attempting to use windows Authentication for the data source. I get the error below. I can run the report from the report server, but when running from another machine over the intranet the error occurs. An error has occurred during report processing. Cannot create a connection to data source 'MyDataSource'. For more information about this error navigate to the report server on the local server machine, or enable remote errors Hello John, Can you please give us the following information: Connection type: Connection string: Connect using: Credentials supplied by the user running the report Credentials stored securely in the report server Windows integrated security Credentials are not requ ...Show All

• Visual Basic Put common routines in a Class (as Shared) or in a module?

  I've read that you should put common routines in a class (as Shared sub/fnctns) because this is more object-oriented. However, it makes the codes slightly messier because I can refer to a Sub in a module as just MySub ( you canoptionally prefix the module name: MyModule.MySub ) but I have to use the Class name for referring to a shared sub (MyClass.MySharedSub). So, any downsides to putting common routines in code Modules vs. a class If any of this is unclear, see this example: I've got a project with a module and a class: MyProject -MyModule -MyClass -MainModule If I put commonly used subroutines into MyClass as Shared, Public Shared MySharedSub ...blah blah... end ...Show All

• Software Development for Windows Vista DirectShow Memory Leaks?

  I am trying to complete a media player by DirectShow.To have more functions, I add filter to graph one by one And Release the objects when the it opens next file.But the memory is increases when opens next file,especially when it opens WMV/WMA file,which it opens by DMO.I have release all the objects and interfaces but the problem remains.I am very frustrated!Is there any ways to solve the problem My guess would be there is still something you are failing to release. Are you using smart pointers You do release the graph object itself ...Show All

• Visual C# Why? WSE910: An error happened during the processing of a response message.

  Hi, I am using Saml token for web service authentication. I have a problem it runs fine when server and client is my own machine but it i get error when server and client are seprate machines. --------------------------- --------------------------- Microsoft.Web.Services3.ResponseProcessingException: WSE910: An error happened during the processing of a response message, and you can find the error in the inner exception. You can also find the response message in the Response property. ---> System.InvalidOperationException: Security requirements are not satisfied because the security header is not present in the incoming message. at Microsoft.Web.Services3.Security.SecureConversationClientReceiveSecurityFilter.ValidateMessageSec ...Show All

• Visual Studio Express Editions Organizing ID Column

  Hi. I have a SQL 2005 Database with: Id (Int, Primary key) Doc_Number (Int) ID = 1 / Docnumber = 1 ID = 2 / Docnumber = 1 ID = 3 / Docnumber = 2 ID = 4 / Docnumber = 2 ID = 5 / Docnumber = 3 ID = 6 / Docnumber = 0 ID = 7 / Docnumber = 0 ID = 8 / Docnumber = 4 ID = 9 / Docnumber = 5 ID = 10 / Docnumber = 5 I want to delete all the records where Docnumber = 0 (I know how to do this) ID = 1 / Docnumber = 1 ID = 2 / Docnumber = 1 ID = 3 / Docnumber = 2 ID = 4 / Docnumber = 2 ID = 5 / Docnumber = 3 ID = 8 / Docnumber = 4 ID = 9 / Docnumber = 5 ID = 10 / Docnumber = 5 And now i want to change id to be sequencial like this (This is the parte that i don't know how to do it) ID = 1 / Docnumber = 1 ID = 2 / Docnumber = 1 ID = 3 ...Show All

• .NET Development How to create a class model for using XmlSerializer.Deserialize() on a preset schema?

  I am attempting to create a class model which will consume the following XML: (note: there are different types repeated under the root node) <TypeA> <TypeB id=”1” /> <TypeB id=”2” /> <TypeC name=”1” /> <TypeC name=”2” /> </TypeA> Unfortunately the XML is rigid (it's a pre-defined standard). Is it possible to create a class structure that will model this using XmlSerializer.Deserialize() Thanks, Jacob Pitts Morgan is correct: XmlSerialzier is schema-driven serializer, if you can create a schema that describes all your xml instances, then you can use xsd.exe to generate classes (from ...Show All

• Visual C# decompress entire directory

  Is there a way, using DeflateStream or GZipStream, to decompress an entire folder (hopefully all at once) Do I need to use a different zipping class that doesn't come with .Net 2.0 Hi, Alex Decompress Zip files: http://www.codeproject.com/csharp/decompresswinshellapics.asp Zip files within a folder: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1136953&SiteID=1 File decompress: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1069499&SiteID=1 Hope you can find the answer. Thank you ...Show All

• Visual Basic textbox visible priority set to "false" will not keep value (how-to use Form Field)

  Hi, This should be simple to do but I just can't figure how to fix the problem. I have a form with one master table and 20 other tables showing related data. The data is linked by the key value in the master form. For example, I have a "Long_Desc" variable in the master table which holds the ky value for the descriptions I keep in the "descriptions" table. Maybe I am doing this wrong but I in my test, I was displaying the content of the key "Long_Desc" in a read-only TextBox just to make sure I was getting the right record from the "descriptions" table. I could also display the content of the "Long_Desc" TextBox using a messagebox. Now, I would like to hide the the "Long_Desc" field on the form. I set the "ReadOnly" priority to True and "T ...Show All

• Windows Forms Setup and deployment

  I have a Compact framework project and I build an installation program using .msi file and InstallDll.dll which call CEAPPMGR.EXE everything works OK. Now I have a utility program that run on the Desktop computer and I want to add it to the installation program. In yje msi project I added a folder under "Program Files" directory and put there the output from my win32 application. I also added a shortcut in the "Programs" menu that points to the application in the "Program Files" folder. The Installation works OK it installs the Files on the compact device and the win32 application in my desktop computer "Program Files" folder and create a shortcut on the "Programs" menue. The ...Show All

• Visual Studio 2008 (Pre-release) WPF for Windows XP!!!!

  Dear Friends, Can anybody please inform me, where can I get the SDK for building WPF applications in Windows XP. Thanks & Regards, Lalit .NET 3.0 download using link below: http://www.microsoft.com/downloads/details.aspx FamilyId=10CC340B-F857-4A14-83F5-25634C3BF043&displaylang=en VS.NET 2005 extensions download for .NET 3.0 http://www.microsoft.com/downloads/details.aspx FamilyId=F54F5537-CC86-4BF5-AE44-F5A1E805680D&displaylang=en Windows SDK download using link below: http://www.microsoft.com/downloads/details.aspx FamilyId=C2B1E300-F358-4523-B479-F53D234CDCCF&displaylang=en WPF Resource: http://wpf.netfx3.com/ ...Show All

• SQL Server Adding multiple textboxes to PageHeader

  I am creating matrix reports programmatically and have come up against a problem where I can only add a single textbox into the pageheader. Writing the report using the report designer software I can add multiple textboxes to the pageheader, however trying to add many of them using the ReportItem object I keep getting a syste.object[] cannot be used in this context. error. for (int i = 0; i < Items.Count; i++) { reportItems.Items = new object[] { CreateTextBox(Items .ItemName, Items .ItemMessage, Items .ItemStyle) }; } This is the line of code that I am hitting the problem. This works fine, however only inserts the last textbox in the Items Array. If I change the code to for (int i = 0; i < Items.Count; i++) ...Show All

• Visual Basic Menustrip missing!

  i have put a menu strip in a table in a tab control. can/should that be done. anyway when i just make it, its there, after a while of working it it isn't. even when i make a new one. i tried bringing it to the front but it didn't work. IceAngel89 wrote: i mean the table layout control. i am using VB 2005 express edition and .Net Framework 2.0. ya its set to visible, enabled and whatever i find correct. the thing is when i click the control name from the bottom bor(not sure what is it called, houses the timers etc) in design mode, it appears then when i click away it dissappears. Any Help ...Show All