magicalclick's Q&A profile

• SQL Server How to check the dependencies of a SQL Table in SQL Server 2000

  Hi all, I m using SQL Server 2000. I want to know the Dependencies of a particular table in my database. I want to know the details inorder to delete the records which are not referenced from other related tables. (e.g) Customer, CustomerTax, Invoice tables are there. CustomerID is primary key in Customer table. CustomerID is Foreign keys in CustomerTax and Invoice tables. When i create new customer i enter customer tax also. So both Customer and Customertax details are stored in the tables. Once i created the customer details it not yet reference in invoice table i can deactivate(later i can again activate the customer) the customer, because it is not refered in Invoice table(eventhough it is refered in CustomerTax table). In ...Show All

• Windows Forms How to save the modified (run-time) content from webbrowser control.

  Hi, I want to modify the content, i mean add some new content, modify the content of existing element in the webbrowser control, then want to save the same to the local machine. The msdn documents says as Any additions made to a document at run-time using AppendChild will not be persisted when you call the ShowSaveAsDialog method on the WebBrowser control. Is there any other way to save the modified content from the Webbrowser control. Thanks in advance, Murugan G Hi, Thanks for your reply. I want to do exactly this. Request various archived post individually and merge it and save as a single html document. like below. 1. Request archived content by issuing separate request, a ...Show All

• .NET Development connect WinForm via internet to database

  Hey, i have created a winform, and connected it to my database. The next step is to connect my winform to the database over the internet, so clients can download my winform and access the database from their computer. I have no idea what i have to do to the database to make it available over the net, and i have no idea how to connect to it. I imagine its using SOAP, however, i can't find anything on the internet where sumone has done sumthing similar. This is for my final year project, if you need me to explain a little more then i can as i am in desparate need of help! Cheers, Simon. Also break your problem down...don't ask for the world in one post. MSDN is a great resource but there are those who try to get people to write their co ...Show All

• Visual Studio Team System share a shelveset

  Hi guys, Could someone please tell me how to share a shelveset with others thank you Hi: To be a bit more specific the way to share a shelveset is to let the people know the name of the shelveset and your username. When a person is trying to locate a shelveset by using unshelve they will need to know both of these to be able to locate it. The second requirement is the need to have read and pendchange permissions on these files since unshelving them actually executes a checkout on those files. Thanks, mario ...Show All

• Windows Search Technologies Problems enabling WDS in the Enterprise

  Our network consists of Win2003 Servers and WinXP clients. We installed WDS on some clients, and faced the following serious problems: 1. When WDS was configured in some clients to also index the network drives, for some other clients, some remote files became "Read Only" during their work on these files. It seems that the indexing process gained some exclusive access to these files. 2. When we tried to disable the indexing of the network drives - WDS neglected this configuration and continued to index all drives. It seems to us that WDS is somewhat not matured enough for the enterprise. Can anyone help Thanks, Gadi The problem you have described sounds similar to the issue ...Show All

• Visual C++ Decorations on C++ DLL function declarations really needed?

  I used the _stdcall decorators on the Visual C++ function definitions and declarations, but I couldn't get communication between the DLL and the Visual Basic application that was trying to call the functions of the DLL.. When I removed the declarations from the VC code almost completely (all but for the DLL_Main function definition), it worked fine.  Is there any disadvantage to using this approach   Everyone I communicated with about it , including my boss and people that answered the MIcrosoft help posting that I put up, stated that you have to use those decorations.  Why is that   It works fine without it so far.  My boss will be back from travel tommorrow.  I was hoping to find out today so I can make ...Show All

• Visual Studio 2008 (Pre-release) Using same object instance in different channels

  Hi If I instanciate an object via channel A and use a session the instance is available as long as the channel is open. On another service I use another channel B. Is it possible to use a special instance of the object in channel A in channel B communication Best Regards Bastian Take a look at this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=796857&SiteID=1 This is my real problem. Yes there is a shared state between all the contracts, but it is not WCF state. It something about an custom user session management - a session id must be known by all contracts (it is not a WCF session - it is a session that I have developed by my own). Regards Bastian ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Intel Extreme Graphics 2 Screen Rotation

  I am using the 82852/82855 GME Graphics Controller. Using the provided control panel applet "Intel Extreme Graphics 2 for Mobile", I am able to rotate the screen 90/180/270. Is there an API that I can call to do this from within my own application I am running Windows 2000 with Service Pack 4. I have tried using the ChangeDisplaySettingsEx call, and it returns successfully, but the screen does not rotate. I have put in some email requests with Intel to get support on this, but haven't received much info from them. Any help would be greatly appreciated. This is proprietary feature of Intel drivers, so I'm afraid there is no API for it. You may still try to emulate keyboard presses... ...Show All

• SQL Server connectivity issue

  hey there I hope I have posted in correct forum - please let me know I have 1 XP box - SQL Server Standard 2005 - running IIS (Server 1) I have 1 XP box - SQL Server Express - running IIS (Server 2) script called (test) Server 1 can host web pages eg aspx and collect data from Server 2 (noted in web.config) http:\localhost\test or http:\Server 1\test - either collect data and display Server 1 cannot go to http:\Server 2\test - error default settings do not allow remote connections. Server 2 cannot host web pages and collect data from Server 1 - error default settings do not allow remote connections. Is this because Server 2 has Express Edition thanks Dianne Hi ...Show All

• Visual Studio Problem populating a Crystal report

  I have created a database(.mdf) in Visual Studio. I created the project using the instructions given in the crystal reports walk through. Below is the code I have used to try to create and populate a crystal report from the database through the ADO.NET dataset. When I preview the report at runtime, it contains no data. Can anyone see any problems with this code. I suspect the DataSetConfiguration might have some problems. The version of SQL Server and Crystal Reports I have is the one that ships with Visual Studio 2005. I am new at this. Please help DATASETCONFIGURATION Imports System.Data Imports System.Data.SqlClient Imports System.Data.Sql Imports Teacher.TeachersDataSet Imports Teacher.TeachersDataSetTab ...Show All

• Visual Studio Express Editions I need Help Getting Started lol i Need it Badly

  Yea i need help getting started with coding like for game developement on visual c# 2005 express editon Well i already tried this site http://msdn.microsoft.com/coding4fun/gamedevelopment/beginning/default.aspx Yea and i cant understand some of it like the direct x installing part i no its suppose to be easy or somewat but iam really confused here so anyone that has any free time plz help me out thank you yea this is good ill go check it out but i need help with somehings on visual express like how to do things that the site coding for fun wants me to do like how to creat battletank 2005 i installed the wrong sdk i installed sdk june and i was suppose to install febuary lol so will this be a proble ...Show All

• Visual Studio Team System Counting lines of code in a class using FxCop.

  Hi, I have to count the lines of code for each class in a project and throw a warning if it exceeds the given limit. i am using " SourceContext " property to do this. When I run the code analysis for this rule, "SourceContext" property is not getting populated with the data and is having default values like null and "0". I am using the following peice of code to count the no of lines. Please let me know where I am going wrong. Also please suggest if i can access source context for a class and if I am doing it in right way. public override ProblemCollection Check( TypeNode type) { if (type.NodeType == NodeType .Class) { SourceContext sc = type.SourceContext; int noOfLines = 0; ...Show All

• Smart Device Development Is it possible to suppressing events temporarily?

  Hi, How can i suppress events for a short time on a form. My prob is that i've a listivew on a form, say A. The item_Activate event on the listview creates a new form, say B and shows it. But as on PPC it takes few seconds to display a new form. The mean while if i tap on another listview item on A, it creates another child form. Now what i need is, i should disable any events( or the same item_Activate event) on A from firing, until the item_Activate event handler is executed. This is just one case in the app. There are many such cases where i need this kind of a check. How do i do this Plz help! Thanks, ...Show All

• .NET Development Messenger Like Functionality

  I am attempting to write a solution that consists of a web service (or remoting) running on the internet and a client application running on ramdom users pc's that functions similarly to Microsoft Messenger. Both pieces will be Microsoft technology based. Here is the scenario, the client application will login to the server/web service/remoting app on startup (similar to MSN Messenger) when there are updates on the server I want it to notify the client that there was a change (like when someone sends you a message on messenger, the message pops up showing the message). When the client app logs off the server would not attempt to send messages to that client anymore but would continue to work correctly with the other clients th ...Show All

• SQL Server How to check whether an SSIS package is executing

  I have scheduled an SQL Job to run every 15 mins. This runs an SSIS package. But sometimes my package might execute for more than 15 mins. In this case, a second instance of the package would start. I don't want this to happen. So is there any way I can check whether the package is already running before I continue the execution of the same. Right now I am using a mutex to handle this problem. Are there any problems using the mutex and is there a better way to handle this Thanks in advance. Sumesh Ashish Sinha wrote: Hi Markus, I am not able to use JobExecutionStatus in SSIS script.Could you please tell me how can I go about it Cheers, Ashish ...Show All