Debabrata.debroy's Q&A profile
SQL Server Handling Dataset in Stored Proc.
Hi, I want to create and populate a dataset from store procedure with following to querires & return the dataset as a result. Select * from billmain where billno = 12 Select * from billdetails where billno = 12 I am currently performing this task aa a resultset. Now I want to use Dataset. Anybody can send me sample sp which returns dataset as a execution of the sp. Nilkanth Desai You can return more than one SQL Server resultsets from a single stored procedure, see the example below. Chris CREATE PROCEDURE SelectTable @billNo int AS SELECT columnName FROM BillMain WHERE billno=@billNo SELECT columnName FROM BillDetails ...Show All
Visual C# IE7 and Visual Studio
Installed Internet Explorer 7 and after that we get the message Visual Studio Busy ..... message when doing a build. We are using XP Professional. You must be kill the process with task manager after that. We tried various things, but after going back to a restore point that was the one before we installed IE7 the message has not shown up again. Any ideas on what is happening with this message Hi, I am having the same problem as stated in the original thread. I need to "end task" from the task manager and then restart the machine to allow VS2003 to do a full build and run. Should I open IE7 at some point the same problem occurs again. Its a real pain when ...Show All
Visual Basic Inheritance run amuck!!!
I use CodeDom classes and VBCodeProvider to generate code and create assemblies. After the upgrade to Visual Studio 2005 Beta 2, I started getting the following error. Class '[ class name ]' must either be declared 'MustInherit' or override the following inherited 'MustOverride' member(s): Note that there is no member name following the error message. If I create a project and add the generated files to the project, it compiles fine. Is this a possible bug Please help. Thanks... I'm now having the same problem as well. I've started with a class derived from UserControl and marked as MustInherit, called BaseUserControl. I then have another derived from BaseUserControl that is also marked as MustInher ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Rendering To Textures in Beta2
I used Texture2D's heavily with the usage RenderTarget, however in Beta 2 its like a whole new API. I understand that Surface no longer exists and RenderTarget/2D should be used. The problem is, the whole mentality is backwards compared to what im used to. From what I see I should create a RenderTarget2D and set that as a render target, then do rendertarget.GetTexture() if I want to set it. Thats fine. However, how do I copy between render targets There is no StretchRect or equivelent function I can see, which I used alot before. Surely I dont have to go about getting a texture, setting it, creating a 'copy' effect, setting a new render target, resolving the new render target just to copy from one to another Is there no alte ...Show All
SQL Server Multiple services on same Queue or not ?
Hi There I am guessing defining multiple services on the same queue is basically for providing different services to outside sources while using 1 queue, obviously as long as the contracts and activated sp logic applies to all services defined on that queue. I am defining a queue per service, is this right or wrong or irrelevant It just works better for me in terms of manageability. I just want to make sure there is no "best practice" reason for doing either or Is it just a matter of preference Any comments Thanx For almost all cases we recommend using one queue per service. Having multiple services backed by a queue is specifically for the scenario you described, i.e. having mult ...Show All
Architecture Web folders and the Shell API
Hi there, I would like to extend the Shell for Web folder items by providing a property handler as well as a context handler. I can do this for filesystem items by adding the adequate entries to the Registry under HKEY_CLASSES_ROOT\*. However, the added handlers are not invoked when I right-click or inspect the properties of a file in a web folder. I haven't found any hint in the API documentation but base this on the experimentation. Is there anyway I can provide a context and property handler for web folders More generally speaking, is there a 'Web folder API' Thx in advance, Marc ...Show All
Audio and Video Development How do I protect Embedding media player link?
How do i protect Embedding media player link does anyone know how can i use an extention link with Embedding media player. or any javasprict to protect my link This question belongs on the Windows Media Player newsgroup: http://www.microsoft.com/windows/windowsmedia/community/newsgroups/WindowsMedia/default.mspx dg=microsoft.public.windowsmedia.player&lang=en&cr=US ...Show All
Windows Forms Send keystroke to another application
I am writing a little tool for a friend who works behind the scenes for TV shows like Criminal Minds and CSI. He needs an application that simply sends a keystroke to the foreground window. Do you know of an API that can accomplish this task that can be used in c# of vb.net Thank you in advance, Steve Bostedor Bozteck Software http://www.bozteck.com Maybe I'm having a brain dumb evening but can you please point me to an example of how that can be used to send a keystroke to another application Thank you! ...Show All
Architecture Developing for ASP (Application Service Provider)...what would be important?
We are starting a project to be a web app (in C#) that runs hosted in a service provider, outside our company. Then our customers will access this ASP and use it, paying for a monthly license. Well, this seems to be very common nowadays, but I cant find much documentation about how to create, tips, and workaround for eventual problems that might occur. One thing that comes up in my mind is that we should use, for each single table, an ID that can identify uniquely each of our customers accessing that table. Maybe some concurreny treatment should be built as well....what else Anyone could help me on this Thanks a lot ! Hi, >One thing that comes up in my mind is that we should use, for each single table, an ID that can ...Show All
Visual C++ Newbie struggling to use dlls
Hi there Recently, I baught a usb interface card ( Velleman K8055 ) to try learn how to write programs for basic IO projects. The card came with a dll containing all the functions the card can perform. I have only had a year of experience programming in c and have no idea how to use dlls. How does one link a program to a dll and call its functions in VC Regards Jarryd You can also do it with a #pragma directive: #ifdef _DEBUG #pragma comment(lib, "debug_build.lib") #else #pragma comment(lib, "release_build.lib") #endif That allows you to link with different configuration (release and debug) of the static library. Obviously, you have to use the c ...Show All
Visual C++ .lib file is a static library file or DLL implicit linking file?
Hello everyone, If I am given a .lib file, how can I check whether the .lib file is a static library file (archive of obj files) or DLL implicit linking file I have such confusion since they both use the same extension name .lib. regards, George Cool nobugz ! You have answered my question. regards, George ...Show All
Visual Studio Express Editions ZIP Archive
Hi All, I've been playing with the .Net Framework again and I was wondering if there is anyway that I could crate an Archive type file. What I was thinking of what using a DateControl object for the Start and End Date and then trying to archive all the test text files I have created (I have created these files on different dates to test this out), I was original aiming for a ZIP file but I cant seem to find any thing in the framework for this! I'm I just blind or do I have to create something myself. Or is there actualy an Archive or backup function that will do what I'm looking to do As always, referances would be best, but I'll take what ever comes. Thanks in advance. Scott There is the open source Sharp Z ...Show All
Visual Studio Express Editions How to locate source causing 'exception'
Hi, While debugging a directshow application (involving some filters including one I am developing) I get a number of these following messages :- "First-chance exception at 0x017a2187 in tux.exe: 0xC0000005: Access violation reading location 0x07466f70." Could someone please advise if it is possible to locate (i.e. see in the vs window) where in the source code this error is initiated Regards, pcd. Hello Re: How to locate source causing 'exception' This forum is for “Questions about Visual C++ Express Edition and getting started with C++.” For questions such as yours please use the newsgroups at http://msdn.microsoft.com/newsgroups . ...Show All
Visual Studio Team System Number of tests executed in build report does not match the number of tests executed in build log
We are using TFSBuild and have 33 tests run automated during the build process. When we look at the report for Builds, it states that only 1/1 tests run. However, looking at the actual build log shows that all 33 tests were executed and passed. The tests are broken up until 2 solutions. 1 Solution has only 1 test running, while the other has 32 tests. Looking at the build log, both solutions say that their test results were published. Any idea why the build report would say that only 1 test ran and passed Thanks Hi Aaron, They are both testing the same website, and therefore the same assemblies. The interesting thing is that the 32 tests are executed after the 1 test. If the publishing was overwriting ea ...Show All
Visual Studio Team System Template Editor (v1.2) Multi Line Default 'bug'
I needed to add a multi line default to the Bug – Symptom field (CMMI). I almost gave up thinking the editor didn’t support multi-line defaults, then I tried \n which didn’t work and then <br/> which did. Makes sense I suppose as it’s an HTML field. The interesting thing is that when I tried using \n , so the xml looks like this <DefaultRule from="value" value="Testing \n multi-line" /> I got the following errors: Information Dialog: Cannot save'c:\.........\...wit':TF26204: The account you entered is not recognized. Contact your TFS admin..... Error Dialog: TF26204: The account you entered is not recognized. Contact your TFS admin..... There’s nothing wrong w ...Show All
