PGT's Q&A profile

• .NET Development How to get all SQL tables at once

  Hi all.. I have a database running on SQL Server. It has a lot of tables that I need to load into a dataset (all at once) so that I could work with the in memory data. How can I do it using a SqlDataAdapter or other object if this is possible I could load it one by one but it is a very tedious work (to load not only data, but also relationships). Thanks Jaime I wouldn't do that. A database is better suited for doing filtering/s ...Show All

• SQL Server Persistent BI Studio Crashes

  I am wondering if anyone has experienced the same persistent BI Studio crashes that I have. I can get the BI Studio to crash by simply opening a report and toggling back and forth on the Data/Layout/Preview tabs. Here are the steps: Launch BI Studio Open Solution Open Report in designer (layout tab defaulted) Click Preview tab, then View Report button Toggle tab to Layout, then Data, then back to Layout, then Preview Boom...Visual Studi ...Show All

• Visual Basic Shell32

  Hi. I Am Trying To Find A Way To Change Field Item Data Using Shell32. I Can Read It Ok. But Would Like To Be Able To Change The Data. The Only Way I Can Do It At The Mo, Is To Use The Windows Media Com, But Its Not 100% Reliable. Code For Reading With Shell32 Included *** Case "Info" ***: Public Function shellit( ByRef loca As String , ByRef Filename As String , ByRef verb As String ) Dim shel As Shell32.Shell Dim ...Show All

• SQL Server Cluster install fails on SQL Native client

  When I try to install SQL 2k5 Developer on a Windows 2003 SP1 cluster I keep getting an error popping up while trying to install. the error looks like this: An Installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi' Can someone please tell me what is wrong. I suffered with this problem ...Show All

• Visual C++ I am a learner,will someone recommend a good book of VC?

  My question is in the title........,Please tell me....thx... Take a look at the following link with nice MFC programming books in general. http://www.amazon.com/exec/obidos/tg/detail/-/0201633582/002-7229022-1197648 v=glance Also, msdn is a great place for MFC references and samples: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vcmfc98/html/mfchm.asp Hope this helps! Thanks,   Ayman Shoukry   VC++ Team. ...Show All

• .NET Development error with parameter with stored procedure

  I have a stored procedure for inserting or updating records that is identical to tens of other ones for other tables and they have no problems. However, with this one on the second call to this procedure I get the following error: Formal parameter '@@ModelLookupMatchID' was defined as OUTPUT but the actual parameter not declared OUTPUT. The call from a VB.Net app sets the direction for the parameter as ' ...Show All

• Visual Studio 2008 (Pre-release) Generating wsdl:documentation from WCF

  How do I generate wsdl:documentation in WCF In the .asmx world, I used [WebMethod(Description="Foo")] attribute. I would have expected something similar on the OperationContractAttribute. Interesting example. But for some reason it seams only to work in one direction on my machine. Adding comments to the wsdl works, but the extension seems to be ignored while generating a proxy from wsdl. Can you als ...Show All

• Windows Forms Delete multiple directory in file system

  Is there any way we can delete multiple directory at the same time without cleaning the children I have over 200 folders on the project and I don't really want go one by one to delete the content inside the folder before deleting the folder itself. When I'm trying to delete it is saying: Cannot delete folder, folder is not empty or it might contain excluded files, which are not shown. I can't beleive I will need to do one by one.... ple ...Show All

• Visual Studio Team System How to run ordered tests?

  Hi, This might be a very basic question, but I can't figure out how to run an ordered test. How do I run an ordered test without having to run everything else (like I can run individual web tests) Thank you. Hi Yulia You run an ordered test the same way you would run any other test, either from test view window, test manager window or through the commandline using mstest. An ordered test is used to ...Show All

• Visual Studio Express Editions Variables values

  How can i see the variable values while program is running Set a breakpoint in your code, or put them inside a setter method so when they change you can set their value on a control somewhere. ...Show All

• Visual Basic VB6 to .NET

  I am currently supporting and developing a VB6 client based application that needs to be migrated to a web based application.  I am know that we will be migrating to .NET but what will that mean that it will be converted to a web based application or what will it take at a high level to make it web based   Once I have migrated by VB6 application to VB.NET what steps will I then have to do to make ...Show All

• Visual Basic Cannot save my.settings if one of the setting fields is a sortedList

  The following gives me a null reference error. Setting: name = Recipe, type = SortedList, scope = User Code: my.settings.Recipe = new SortedList my.settings.Recipe.Add("aKey", "aString") my.settings.Save() < Null reference error occurrs here. I have tried (and failed) with many different approaches to use a sorted list in my.settings. I would love to know the correct way to do this. Steve, ...Show All

• Software Development for Windows Vista IfElse Activity in a While Activity

  Is there any reason that I shouldn't be able to drag an IfElse activity into a While activity I'm unable to do so. I'm running Workflow Foundation beta 2. Thank you in advance... While activity can have only one child activity. You can add Ifelse directly to while or add a sequence and then add other activities to that sequence ...Show All

• Windows Forms Change the back color of read only columns in a data grid?

  How do I change the back color of read only columns in a data grid ...Show All

• Visual Studio Express Editions password

  hi i am using vbexpress as front end on a msaccess database. I have created a user name and password screen in vb which will authanticate users to my msacess data base via vbexpress. Can anyone please help me in what will be the easily way to achieve this and where should I keep my user name and password to compare. Some codes are also appreciated. Write a query which takes password and user name and verifies it in the database and r ...Show All