moondaddy's Q&A profile

• .NET Development to speed up database access from SQL SERVER 2005 using C#

  we have an application where while opening the application in the form load event i am creating the tabs and all the controls dynamically based on the values stored in the sql database , can anybody help me out on to speed up the data access from sql server, right now my application takes time to start up atleast 15 secs ... Thanks :-) Sorry, ive just always been told here (by a couple of SQL experts at MS UK) that SPROCS are faster and securer than standard injected queries but I know it also depends on the efficiency of the query. Thanks for that, its always appreciated ...Show All

• Windows Forms Get Response From Web Browser

  hi everybody, i have a web browser in my form, and im hitting a url with some data after which i will be getting a response from the URL, im using document complete event to trap the response, well everything goes fine till the event fires, but im not able to receive the response and store it in a variable, i tried it in 2005 with this wBrowser.DocumentText.ToString()...., works fine but i need the equivalent for this in 2003 Helps Please By default, there's no a WebBrowser control on the toolbox in VS 2003, but you can import a COM component called "Microsoft Web Browser",it does have a DocumentComplete event for you to handle, private void axWebBrowser1_DocumentComplet ...Show All

• SQL Server Encryption of Column

  Hi, Is there any possible way, that while I transferring a table from another table, I can specifically encrypt a column Is there any step on how can I do this Need Help Badly Thanks There is no stock encrypt task or transform in this release. However, that needn't stop you. Kirk Haselden's SSIS book has a CryptoTask which can be adapted from a custom task to a custom transform, or more easily, a script transform. The options for column encryption right now, are to write code for in-pipeline transforms, or to have an auto-encrypting destination. In-pipeline encryption would require writing a custom/script tranform to modify the data in the pipeline, or a custom/script destination which call's SQL ...Show All

• SQL Server How to pick up the last value within a time dimension member

  Hello, When creating a measure it is possible to select the Max or Min value of the input table column for a particular time dimension member. In a similar way, I need to be able to pick up the FIRST or LAST value for the particular time dimension member eg. Last value of the day, week, month etc. Does anyone know a way to do this I have experimented with Last NonEmpty but this seems to have some sum aggregate functionality which I do not want. Many thanks Adrian West What version of Analysis Services are you using. In AS2005 you have new aggregation functions like LastNonEmpty. Check this under the aggregation methods on the first tab in the cube editor(where you can ...Show All

• SQL Server Question on Microsoft Association Rules

  I build a data mining model to predict what are the best studying methods for the student to pass the examinaton. Create Mining Model StudentAssociation ( Student_No long key, Gender text discrete predict, PassOrFail text discrete predict, StudyMethod table predict ( MethodName text key ) ) Using Microsoft_Association_Rules ( Minimum_Support=0.02, Minimum_Probability=0.03 ) The mining table will contain all the methods that the students use, no matter their examination is passed or failed. The value of PassOrFail will have either 'Pass' or 'Fail'. According to the above model, can I query the best studying methods Or I should only train the model with the student who pass the examination, and ignore all the failed. Tha ...Show All

• Visual C# Public partial classes

  Hello Everyone, How to access these public partial classes: I have something like this public partial class test : System.Web.UI.Page { // What ever I need here } I have a second class public partial class test1 : System.Web.UI.Page { //Code here How can I access test from here } Those are two different classess. Partial have nothing to do with having access between two different classes. Either you should have one class, or to access the first one trough an instance of it for nonstatic members. Or you can inherit test1 from test if that will work for you. ...Show All

• Visual Studio Tools for Office VSTO 2005 Second Edition Released to Web - available for downloading

  I am very pleased to announce that Visual Studio 2005 Tools for the 2007 Office System (VSTO 2005 SE) is released to web and is available for immediate downloading. The vision of VSTO is and has always been to make it a part of every developer’s toolkit. Toward that end, I’m excited to also announce that starting in Visual Studio Orcas, VSTO will be integrated into Visual Studio Professional and will support a substantially increased number of Office SKUs. This expands on the existing choices that developers currently have to get at the Office platform with VSTO including VS Team System and MSDN subscriptions. The release of 2007 Office system introduces new levels of ease of use and user productivity. Soma’s blog discuss ...Show All

• Visual Studio Team System Proxy Server for Single Remote User?

  I can see the obvious benefit of caching files on a local proxy that will be requested by multiple remote users. I'm unclear if this buys anything for a single remote user. Was the intent to simply serve files locally whenever possible or does the cache proxy streamline things in other ways that make it worth setting up for a single remote person If the answer is no, should we in fact avoid setting it up for a single user Will it strictly add overhead Hi Nick: As Martin pointed out the Proxy is really helpful for offices (even if that includes one person) that have a slow WAN connection to the TFS Server. It decreases download time significantly and hence it allows for greater productivity. Wha ...Show All

• Visual C# missing app.config in vs2005

  Hi, I'm wondering how can i open (or create) an appconfig in VS2005. As I remember, in VS2003 it was created with the project, but in VS 2005 it is not (or somehow it is hidden). How can I create/access it (Or there is a new way in VS2005 to manage some settings ) Thanks Oscarfh wrote: Ahh ok, and this settings file is a XMl document Yes, the file which is created, is app.config, Visual Studio will just let you edit your settings through a data grid. Any settings you add/change in this grid will be stored in app.config, and Visual Studio will create a special Settings class, which will let you access those settings through its properties (you get intellisense and all). Of course, yo ...Show All

• Software Development for Windows Vista It there any document tell us why ?

  I am following the hands-on lab, but the document tell me how to do and doesn't explain why. so i am always puzzled. Can u give me any document about why bow ! Hiya If you are a fan of books rather than online documentation there are some coming out next month. - Due on 13/10/2006 - http://www.amazon.co.uk/Essential-Windows-Workflow-Foundation-Shukla/dp/0321399838/ref=sr_11_1/202-4309871-8687067 ie=UTF8 Due on 23/10/06 - http://www.amazon.co.uk/Foundations-WF-Introduction-Workflow-Foundation/dp/1590597184/sr=1-3/qid=1158235191/ref=sr_1_3/202-4309871-8687067 ie=UTF8&s=books Due on 11/10/2006 - http://www.amazon.co.uk/Microsoft-Windows-Workflow-Foundation-step/dp/073562335X/sr=1-4/qid=1158235 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What's the competition like?

  Hello everyone, I was just wondering if there is a list anywhere of the people and/or teams that are competing in the Dream-Build-Play contest   Does anyone else wonder what the competition is like and what games are being worked on for this Thanks, jay e  I'm flattered. Don't worry, I'm sure there will be lots of interesting projects, and I can't wait to see what you have up your sleeve. I just want to see more details on the dreambuildplay.com page. I also check it every few ( where few = 1 ) hours.       ...Show All

• Windows Forms Add Multiple controls to a datagridview

  Hi Is it possible to add multiple controls to a cell of a DataGridView Or a single control that spans across multiple cells I'm trying to develop a scheduler application and when the user clicks the cell content it creates an appointment. They can have 1-4 appointments within a cell and I want to display those four appointments as four separate labels within one cell. It is something similar to OutLook Calendar. Can this be done using a DataGridView. Or do I have to use some other control I will appreciate your help. Thanks Hi Wang Chi, Thanks for the reply. But rather than drawing I wan't the user to place it as a control because when the user clicks this control it opens another new form that ...Show All

• Visual Studio 2008 (Pre-release) Creating a brush from the text?

  WHat's the easiest way to create a Brush from some text at runtime I wish I could say "yeah! that's what I was looking for" but hey, that link doesn't have a single example and all the classes it's referring to don't have very thorough description, neither there's a single page returned by Live.com or google on GlyphRun and GlyphRunDrawing other than almost placeholder MSDN description. Not a single sample on either one in SDK too. I'm stuck. Small sample, anybody ...Show All

• Software Development for Windows Vista Can't install Visual Studio 2005 in Vista(5808)

  When I install Visual Studio 2005 Professional Edition in Vista(5808), it said that there is a compatibility issues. Please help, thanks. You should be able to continue your installation even after that message. there are a few places where you might run into issues, but for most cases you should be fine. Also look at this blog for more information http://blogs.msdn.com/somasegar/archive/2006/09/26/772250.aspx -Vineet Application Compatibility Team http://blogs.msdn.com/VistaCompatTeam/ ...Show All

• Windows Forms Text Box - Garbled - Paint Issue

  Hello All, I'm currently building an app that has a single Main form. The app loads up an assembly into a secondary app domain using the CreateDomain feature. The loaded assembly (into the second domain) contains form/UI elements that need to be conditionally loaded from the form on the primary domain. Initially I had structured these as user controls that may be loaded into a panel on the primary domain. While trying to do this, I ran into some serialization issues and froma bunch of posts figured out that this is not possible. I've now moved to displaying the GUI as a modal dialog from the second app domain. How it works is -> A message, in the form of a hard wired string is passed into the second domain via a Marshall By ...Show All