smgtreker's Q&A profile

• SQL Server https & setting ServicePointManager.ServerCertificateValidationCallback

  Hi, In my CLR stored procedure, I made a https request. To by pass the security check, I change the property of ServicePointManager: ServerCertificateValidationCallback . But SQL server 2005 does not allow me to do this and gives me exception related to security. It seems the CLR assembly does not have permission to set the property of ServicePointManager: ServerCertificateValidationCallback . What kind of user should I use ...Show All

• SQL Server Instert found records into DB

  here, this query produces 21 days for @TotalPostingDays  ...the days left after pulling out weekend days (sat and sun) and holidays. What I want to do is instead of pulling the total amount for @TotalPostingDays I want to insert the actual dates that are contained within the @TotalPostingDays into a table DECLARE @TotalDaysInMonth int ,             @today datetime , ...Show All

• .NET Development "Stored Procedure" or "Query"?

  Hello, me again! I found myself a bit confused about "query"  and "stored procedure" in access. Are they the same thing However, I do suspect this is ture as after some googling I found that varies articals mentioned "stored procedures" are actually created in MS Access for Sql server. So what you are doing when calling a "stored procedure in Access" is actually invoking the stored procedure stored in the ...Show All

• Software Development for Windows Vista How to Obtain Fault from child activity in FaultHandler?

  How does a child activity obtain access to the Fault captured by a FaultHandler I have a code activity as a child of the FaultHandler. I simply want to spit out the message from the exception that was caught. I tried using the Parent property, expecting that to give me back a reference to the containing FaultHandler, but it was null. The only way I can figure is to add a property to the workflow to store the Fault in through a binding so t ...Show All

• SQL Server One dropdownlist depend from other.

  Hello, I need to know how can I pass two parameters, One select depends from what I selected on the first one. I did it once but I just dont remember You are looking for a dynamic parameter ( or dynamic dropdown) walk through or " how to". Ill use the example of store locations and employees located in each store. Fist what you would do is create your data sources for your drop downs ============================== ...Show All

• Visual Basic Creating Events Dynamically

  I have a function that creates a form, creates controls for that form, adds the controls to the form, then displays the form. Now, all this works perfectly. I just cannot figure out how to create events for the newly created form. This is what I have: Friend Form2 = New System.Windows.Forms.Form() Friend Amount = New System.Windows.Forms.Label() Friend TBar = New System.Windows.Forms.TrackBar() Friend Bevel = New System.Windows.For ...Show All

• Visual Studio Hi, Where can I find Microsoft SCC API documentation?

  Hello. I’m working on a project about integration a SCM tool with Visual Studio. I need the documentation of the SCC API (Common Source Code Controls). Where can i find it Anybody can help me Thanks. It's included in the Visual Studio SDK, which you can register for and download at http://msdn.microsoft.com/vstudio/partners/ . ...Show All

• Visual Studio Team System Method fails in unit testing with System.Resources.MissingManifestResourceException

  I have a method I am testing that provides localized strings and wanted to provide a unit test to take it through its paces. I already have the method working and wired to a UI, but also wanted to write a unit test for the method so that others would know that it works and to provide a code example. What is strange is that the method works as expected when I run it in the UI, but the unit test throws a System.Resources.MissingManifestResourceExc ...Show All

• Windows Forms Eliminating flicker in transparent controls

  Hello all, I am working on an application that requires transparent controls.  I have used Bob Powells method (http://www.bobpowell.net/transcontrols.htm) and it works just fine. However, it is not possible to use double-buffering.  This is mostly not a problem, but fo ...Show All

• Windows Forms Start and stop looping

  Dear all, This is my problem.. public void btnStart_Click( object sender, System.EventArgs e) {...       while (running != 0){do something} } public void btnStop_Click( object sender, System.EventArgs e) {running = 0;} I want to use the btnStop or btnStart (anyone will do) to set variable running = 0 so that the loop in btnStart will end. How do I do this Thanks. Regards, sieweng ...Show All

• Windows Forms ListView in dotnet: Getting currently displayed items at scrollbarposition

  Hi, how can I get only the items that the user actually sees To be more exact: The items that are shown in the client area at the specific scrollbar position the user currently has set. Greetz, Sven. If you are using the ListView in details mode: Use the ListView.TopItem to get the first item currently visible in the list. Then call ListView.GetItemAt using x=1, y=ListView.ClientRectangle. ...Show All

• Smart Device Development Xml Reading

  Hmm... storing data with XML files. Which lead me straight to a problem. XmlTextReader reader = new XmlTextReader(Server.MapPath("Arsenal.xml")); Now on the device its in \Program%20Files\SmartDeviceApplication4\Arsenal.xml with the .exe so i thought i could get away with just having "Arsenal.xml" as the path... unfortuantly it throws a: An unhandled exception of type 'System.IO.FileNotFoundException' occurred in System.Xml.dll ...Show All

• .NET Development Receiving error: The root element is missing.

  I have inherited a C# application (code below) and it's having issues (famous first words, eh).  The apps purpose is to retrieve a result set from SQL server 1 (in dataset format), convert that to XML using a MemoryStream and XmlTextWriter then submit the XML data to a web service for processing by SQL server 2.   I am receiving the error "System.Exception: Server was unable to process request. --> The root ele ...Show All

• Visual C# Attemped to read or write proteced memory..??? WINforms, CLickonce..???

  Hi groups, I created setup for my Windows Application using ClickOnce in VS 2005 beta2 . Its works well and fine in my local machine. But when i tested in other machines, after installation it is throwing error as given below. ERROR AS SOON AS IT LOADS THE WINFORMS. "Attempted to read or write proctected memory. This is often an indication that other memory corrupt." What should i do for my windows application developed using C# to run smoo ...Show All

• Visual Studio Help still broken

  Just installed the release version of VS2005 standard. Alas, F1 help is still broken. If I position the cursor over a word (for example HANDLE) and hit F1, the following happens: 1. If MSDN is set to use local help only, it always displays the topic-not-found page, even though on the left hand side, the topic is not only present, but selected. A single click on the highlighted item displays the correct information. 2. If MSDN is set to use onlin ...Show All