Fuzzy6280's Q&A profile

• SQL Server Pass XML Data to a Stored Procedure

  Does anyone know how to pass a XML File to a MS SQL 2005 Stored Procedure (INSERT/UPDATE), and how to create the stored procedure so it will accept the XML values using VB 2005. Here is an example of the XML File. Code: <MYROOT> <TableName> <Field1>String</Field1> <Field2>String</Field2> <Field3>String</Field3> </TableName> </MYROOT> Thank you. bty The following link provided by Microsoft does not work in VB 2005, I have tried that http://support.microsoft.com/default.aspx scid=kb;en-us;555266 You can do this using XQuer ...Show All

• Microsoft ISV Community Center Forums How to check the TCP/IP checkbox in network connection property window?

  hi, guys In windows, network connection window, in the property of a connection, It has Client for Microsoft networks, File and Printer sharing, Internet Protocol (TCP/IP) three checkboxes, is there any way to check/uncheck these in script Thanks, Here's some additional input from the engineer: Writing a network driver is a lot of work, this may cost ISV a lot. If our ISV is interesting in doing this, he can reference the Windows Driver Develop Kit. (DDK). This link might be of some help: http://www.microsoft.com/whdc/driver/wdk/betawdk.mspx . -brenda (ISV Buddy Team) ...Show All

• Windows Forms Thread question

  Hi, I have a winform application that fire a thread that verifies a database, if the database has some new entry, the thread needs to communicate the main thread.. How can I do this via message via event via fire balls =P Thanx! To see an example of the BackgroundWorker in action check out the Application at the bottom of the page - http://www.windowsforms.net/Default.aspx tabindex=9&tabid=3 App Summary - This application uses the BackgroundWorker component and the DataGridView control (both new to Visual Studio 2005) to asynchronous load data into the DataGridView. The sample performs a “find in files ...Show All

• SQL Server how to add a where clause by parameter in a stored procedure

  What i want is to add by parameter a Where clause and i can not find how to do it! CREATE PROCEDURE [ProcNavigate] (  @id as int,  @whereClause as char(100) ) AS Select field1, field2 Where fieldId = @id    /*and @WhereClause */ GO thx Personally, I dislike the above mentioned method. Besides the fact that it opens you to all sorts of bad stuff. What you can do is make the parameters nullable, and do a case statement on the where part of the clause: create procedure pSomethingOrAnother (    @p_lID integer,    @p_lWhereItem1 integer,    @p ...Show All

• .NET Development How to block managed code being decompiled?

  After a lot of efforts, around 6 months of my development work on windows forms and components to bring a better application, I learnt that managed codes can be decompiled (Including Visual c++ 2003 in which I am developing - supposed to be stronger than C# and VB!). This looks like a setback, at least for initial start of my application in the market. I have made a trial run on my own code (95 % managed code with forms and windows components), simply it can be decompiled. Only 1 out 12 classes, which is unmanaged code, was not decompiled. Is there any way, using option like /CLR or otherways I can make managed code obfuscated from out ...Show All

• .NET Development How to get Dictionary<Tkey, TValue> entry information through reflection?

  I have been working on some code that probe through the entries of a generic dictionary Dictionary < TKey , TValue > , using reflection. Unlike working with Hashtable, it's not easy to find out the entries' key and value information. Here is the code depict the problem. Suppose I have a class hold two fields: public class MyClass { Dictionary < string , DateTime > m_dateTimeDictionary; Hashtable m_dateTimeHashTable; } I have an instance of the class and its type info: … MyClass myClass = new MyClass (); Type myType = myClass.GetType(); … I have ...Show All

• Visual Studio 2008 (Pre-release) Looking for a working Attached Events sample

  Hi, has anybody either succesfully implemented a custom  Attached Event or seen an example somewhere I can't find any documentation available aside from the fact that implementation is similar to the Attached Properties approach. Thanks I'm posting a sample that defines two things: first a custom control that exposes a RoutedEvent using bubbling strategy: public partial class CustomControl : Control { public static readonly RoutedEvent CustomNotificationEvent; public event RoutedEventHandler CustomNotification { add { base .AddHandler(CustomNotificationEvent, value ...Show All

• Windows Forms Implementing security in the webbrowser control.....

  In http://msdn.microsoft.com/library/default.asp url=/workshop/browser/overview/overview.asp#Download_Control , it is stated that Hosts can control certain aspects of downloading—frames, images, Java, and so on—by implementing both IOleClientSite and an ambient property defined as DISPID_AMBIENT_DLCONTROL. When the host's IDispatch::Invoke method is called with dispidMember set to DISPID_AMBIENT_DLCONTROL, it should place zero or a combination of the following values in pvarResult. How would this be done in VB.Net 2.0 with the webbrowser control Still wondering about security in the webbrowser control ...Show All

• SQL Server Unistalling SQL SERVER 2005 Beta version

  Hi friends , I am trying to uninstall the SQL SERVER 2005 Beta version but I am getting following error. SQL Server 2005 has detected incompatible componanets from Beta version of Visual Studio. NET framework or sql server 2005 I have SQL Server 2005 is already in my system but it is B version so I am trying to uninstall it but it is not getting Uninstalled. and my system is having visual studio 2003 .net so how to uninstall SQL Server 2005 Beta version any help will help me a lot sandeep http://blogs.msdn.com/astebner/archive/2005/04/19/409555.aspx has downloads for uninstalling beta/ctp versions of ...Show All

• Windows Forms how to get url from the control ??

  My control is deployed in <object>mydll/object>, in an aspx page. like http://localhost/myproject/default.aspx How can I get the above url (where this object is installed) from inside the mydll object  Thanks, varadhg I have two ways to get this url from the Smart Client here: -----------------------------------------------------------------------------------------------------------   One way is&n ...Show All

• Visual Studio How to tell the version of MSDN Library?

  The "What's New" section of the pre-VS2005 of MSDN Library identified which version of MSDN Library was installed on the system. Ex: MSDN Library October 2005. In MSDN Library for VS2005, how can I tell which version is installed on a system Thanks for the information location. Should we hope that one day, whoever manage the MSDN Library will place this version information in a natural location like on the MSDN Library title page on in a "What's New" topic I might be wrong but it seems like an easy improvement to perform. Afterall, the MSDN Libraries before VS2005 had th ...Show All

• Visual Studio Report References and Trusted Assemblies

  Hi, I'm referencing a third party assembly to generate images (barcodes) in a 'Local' report.  I'm getting the following error: "The report references the code module '<the 3rd party DLL>' , which is not a trusted assembly." In the previous version of Reporting Services when I could deploy a similar report on the report server but I need to add the follow to the rssrvpolicy.config file <CodeGroup class="<the class>" version="1" PermissionSetName="FullTrust" Name="<the name>"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\.....dll"/> </CodeGroup> Is there a proces ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Hey Everyone

  Hello every1, i remember playing my snes :P it was a damn fun game console for sure though. i remember a game called earthbound best. it was a great game and it looks simple enough to make with todays game dev tools. i thought maybe it would b possible to make a online version of this game... would this be possible also wat about legal issues Deprecated means not supported any more - so there will be no bug fixes if you find any. Can you live with that Deprecated often (depends on the product) means 'won't be there in a future version. I have no official story on if DirectDraw will be in the next version of DirectX (major version - n ...Show All

• Windows Forms Newbie click once deployment prerequisites question.

  Hi Which of the following (all ) do I need to successfully deploy an application using click-once ASP.NET 2.0 on the server IIS 6 on the server Permissions to run executables on the server I am using Visual C# .net Express edition. Thanks for the help. ClickOnce can be deployed to HTTP or UNC. For HTTP it only requires the Front Page Server Extentions are Installed ASP is not required The Web Server Shouldn't matter as long as it can process the MIME handlers correctly. (e.g., serve up the .manifest files to the client) The executable does not need to run on the server. ...Show All

• Visual Studio Express Editions Testing a vc++

  Hello; what does it mean by testing a vc++ program,i have written my code and compiled it and its working.but my lecture wants me to write a testing program for it. can anyone explain Testing is where you run it with various sets of data to make sure it succeeds when it should and also fail when it should. But this question is surprising because program testing is one of the very first things you should learn about. ...Show All