Barthi's Q&A profile

• SQL Server Usage-Based Optimization

  Hi all, Im working on AS 2005. The users will use Excel 2003 pivot table to query cubes. The performances look fine so far but I read that the Usage-Based Optimization is a powerful feature from AS 2005. Do you think it will be a good idea to implement this optimization Regards, JL Although I recently discovered that unlike AS2K, when you run the usage-based optimisation wizard it overwrites any aggregations you'd designed previously. I put this on Connect( http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=221844 ) but it got marked as 'by design'. I'm waiting for a fuller explanation on why this is, but at the moment I can't help but think that its usefulness is p ...Show All

• .NET Development WMI pass paramertes when starting a service

  How do I pass parameters to a service using WMI when starting ---------------------------------------------- string ServiceAction = "StartService" ; ManagementOperationObserver observer = new ManagementOperationObserver (); BlackBoxManager. ServiceHandler oServiceHandler = new ServiceHandler (); observer.ObjectReady += new ObjectReadyEventHandler (oServiceHandler.Done); ManagementObjectCollection queryCollection; queryCollection = getServiceCollection( "Select * from Win32_Service Where Name = '" + ServiceName + "'" ); foreach ( ManagementObject mo in queryCollection) { mo.InvokeMethod(observer, ServiceAction, inParams,null); } ------------- ...Show All

• Visual Studio Express Editions e-mail problem

  Hi, I received the confirmation e-mail, but there is no link inside ! What can I do MicrosoftR Visual Web Developer 2005 Express Pour terminer le processus d'enregistrement de Visual Web Developer 2005 Express, validez votre adresse de messagerie. Une fois votre adresse de messagerie validee, vous recevez votre cle d'enregistrement et les instructions pour terminer l'enregistrement de votre logiciel. Pour valider votre adresse de messagerie et recevoir votre cle d'enregistrement, cliquez sur Merci de votre inscription aupres de Microsoft.com c 2005 Microsoft Corporation. "Cliquez sur" means click on, but there is no link... My french skills are non-existant so what is ...Show All

• Visual Studio Team System How to setup TFS MSSCCI plugin to connect to SSL-enabled TFS Server?

  I am unable to get the TFS MSSCCI plugin to connect to an SSL-enabled TFS Server. How can this be done I followed the following 2 walkthoughs to enable and require SSL: http://msdn2.microsoft.com/en-us/library/ms242875.aspx http://msdn2.microsoft.com/en-us/library/aa395285.aspx We were recently required to put all web trafic under SSL and now we are unable to have our VS.NET 2003 clients to connect to TFS. To elaborate my question: can you connect to this TFS server using SSL using the command line and Team Explorer (or Visual Studio 2005) can you connect to TFS server using SSL using Msscci 1.1 by v1 you mean Team Explorer or Msscci If Msscci, is there any reason why not use the latest version Thanks ...Show All

• Windows Forms How can I change the Font.Bold in Treeview Control

  Hi I have a Treeview Control that I load all root Nodes and its Child, but now I want the Root Node Font to be Bold and the Child to be Normal, How can I do this Your Help will be highly appreciated. PJ. van de Sande wrote: You can set the NodeFont property of your Root Node Font. Thanks, thats what I needed ...Show All

• Visual C# RETRIEVE IMAGE FROM FOLDER USING SQL QUERY AND CREATING THUMBNAIL

  I am a beginner, but very dedicated student. I have been struggling with a problem for 2 weeks and this is the first time I post to a forum. So, pls bear with me if I am not doing it right. My 1st real Project: Create a picture contest site. Users upload image and visitors vote. Storing images: I read in different places it is better to store the image in a folder instead of SQL 2005, the reason is simple: the Database would become huge. The img would be referenced in the DB and could be retrieved later along with other user info. No problem with storing image and using username to rename it and refer it to the db (error handling not posted): string fileExt; if (FileUpload1.PostedFile.ContentType == "image/ ...Show All

• Visual Basic RichTextBox - Trap Highlight

  If I DoubleClick a word to highlight it I can trap the Event. But, if I highlight a word/phrase/etc by dragging the selection point with the mouse, how can I trap THAT event Alternately, how can I determine the text that is highlighted For a richtextbox there is the event SelectionChanged. The property SelectedText should return the text selected and there are a whole host of properties beginning with Select In your code type the name of your richtextbox followed by a period and then S to see the properties. SelectionStart tell you the index of the character at the start of the selection, SelectedLength the length of the selection. ...Show All

• Visual Studio Tools for Office Excel.Application Fails when application running as a Service

  I have a windows service application that watches a directory for a new file. When a file is dropped into the directory, the service attempts to create a new Excel.Application and load the file into a Workbook. When the code: App = new Excel.Application is called it fails with: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005. The exact same code works through my Windows Form test application from the same project. I have strong named the assembly, granted full trust to the assembly, ensured the log on name of the assembly has administrative rights on the box, and changed the service to run under the Local Security context. I have also a ...Show All

• SQL Server Decimal Separator in SQL Server with Comma... is possible???

  In Brazil decimal separator=comma SQL SERVER LANGUAGE=BRAZILIAN OR PORTUGUESE PRICE=MONEY "UPDATE PRO SET PRICE='1,11' WHERE COD='0001'" PRICE=111.00 all aplications use comma... impossible alter all! Programmatically in SQL you will need to use a dot insted of a comma but the data can be displayed in the front using a comma provided you have the correct regional settings on the front end. ...Show All

• Visual Studio Express Editions Database decimal to convert to double for Equations

  Here's a nub question..... I have a database and i'm trying to bring in decimal info into a form and use the decimal in equations. when i do that i get an error saying "cannot convert string to double" how can i resolve this issue Thanks, Rob you were right...(surprised ) well there were nulls. these were created because when form1 loaded it did not open form4. i corrected this by adding this line of code: Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Form4.Show() Form4.Hide() End Sub Is there an easier way of doing this i dont want form4 to be shown at load ...Show All

• Visual Basic Can I create wizards for my program?

  i was just wondering if I create wizards for my program like to accept input from user then process them and stuff. Yes, you can create a wizard for your program. A wizard is nothing more than a procedure (or series of procedures) that walks the user through accomplishing a task....think of a wizard as a mini application ...Show All

• Visual Studio Team System Can anyone give a sample to capture an alertbox in webtest?

  Hi, I need to check client validations in my web application. Since, the webtest does not playback the clienside scripting, i need a sample of the same(say e.g name is a required field) and advise me how to implement the same. Thanks - Vijay Team System has built in Validation Rules that you can use to validate responses from a request. You can check these out by right-clicking a request in the Test and selecting Add Validation Rule. You can play around with the built in ones to see what they do. You can also create your own rather easily. Here is a link to a sample that should help you out. http://msdn2.microsoft.com/en-us/library/ms182556(VS.80).aspx ...Show All

• Visual Studio Express Editions concerning media player

  renee where do I post pause button code wow that sounds complicated.....but first....this is my pause button........ then I thought I would like a back button......dont know if it should keep repeating last song or not, at the moment it just rewinds the current track to start......mmmm what do ya think pause button Private Sub btpause_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btpause.Click If WMP.playState = WMPPlayState.wmppsPlaying Then WMP.Ctlcontrols.pause() tmr.Stop() ProgressBar.Value = ProgressBar.Value btpause.Text = "paused" btpause.ForeColor = Color.Aqua Else If WMP.playState = WMPPlayState.wmppsPaused Then ...Show All

• .NET Development different output of tlbexp on different computers

  Hi all, I have a C# class library, which has a COM interface. The "register for COM interop" checkbox in the project settings is checked. On the one computer, the typelib contains the entry [id(0x60020000), propget] HRESULT id([out, retval] Siemens_SiplacePro_SPI_ComponentModel_Business_Types_CameraType* pRetVal); and on the other computer contains the entry [id(0x60020000), propget] HRESULT ID([out, retval] Siemens_SiplacePro_SPI_ComponentModel_Business_Types_CameraType* pRetVal); How comes that this property in the typelib is uppercase on one computer and lowercase on the other Both computers have the same OS installed with same language settings and same edition of VS2005. I could ...Show All

• .NET Development What did I do wrong (Getschema method in SQLServerCE)?

  I have a problem with the Getschema method in the SQLServerCe namespace - I am fairly new in C# so I may have overlooked something. My problem is that I have only the C# Express edition (I don't have the mobile projects) so I am "forced" to make my own viewer for my SQL Compact databases (.sdf) as I can't use SQL server Management Studio Express for these files. However, when I use the Getschema() method in the corresponding namespace it seems to not work. This is the code I used: string connstring = @"Data Source=c:\!studiec#\betatest.sdf" ; SqlCeConnection myconn = new SqlCeConnection (@connstring); myconn.Open(); DataTable mytable = myconn.GetSchema(); I get the error "Spe ...Show All