Ron McMahon's Q&A profile

• SQL Server Usage-based optimization in AS 2005

    Hi,   It is easy to use usage-based optimization in AS 2000.   There is alyways a error message when I use usage-based optimization wizard in AS 2005.   The error message as following:  Invalid object name 'OlapQueryLog' .   It seems like somewhere must to be set.   Anyone could tell me where the problem is thanks, Denny Lee's blog explains how to set up the OLAPQueryLog DB: http://spaces.msn.com/members/denster/Blog/cns!1pvF91EMBBNxnTGlLGUgGehg!297.entry >> November 23 Analysis Services 200 ...Show All

• Visual Studio Team System How can i dynamically create test suite?

  Using MbUnit framework i can create TestSuiteFixture and mark some method with the TestSuite attribute and i'll get dynamically created test suite. For example: [TestSuite] public TestSuite GetSuite() {   TestSuite suite = new TestSuite("a");   suite.Add("SomeTest", new TestDelegate(SomeTest), null );   return suite; }   How can i do this in VSTS What do you define a test squite as If you mean a group of tests: No, We dont completely support that. You can use data driven tests to provide a single test case with multiple input values. If you could describe a bit more about wha ...Show All

• Visual C++ help creating a .dbg file

  I have read somewhere that I can use rebase to create a .dbg file from an existing .pdb. How exactly do I do this I am using Visual Studio Standard 2005. For those who are curious, I am trying to use a MinGW version of gdb to debug a Windows executable. To do that, I need symbols. I would request that you not ask me why I want to use gdb or try to disuade me unless it is just not possible. Thanks!   No rebase can just extract debug infos in an exe file, remove it and place it into a dbg file in another directory. Why dont you create dbg files for your project. AFAIK there is no tool ...Show All

• Windows Forms Saving datatable to database

  I am working on an inventory application using the .net compact framework and Visual Studion 2005 I have created a dataset with the following tables from a SQL Mobile database tblItems tblUPC tblSalesCallItems I've also created two additional table adapters by joining the above tables with a query viewSalesCallItems viewItemUPC The portion of the application I am working on right know consists of two forms: the first form has a textbox, OK button, datagrid, and a save button. The user types an UPC in the textbox, then clicks the OK button. This brings them to a second form (item details) where they can add additional information abo ...Show All

• Visual Basic Adding Timestamp to RichTextBox

  how do i go about doing so all im looking for is the time "HH:MM AM/PM" ahh ok that seems to work, sorry about before i was running late to work and didnt have a real good chance to read. but i re-read it and found out Dim Time As Date = System.DateTime.Now Time = Format(Time, "Medium Time" ) gave me " 5:49:30 PM " ...Show All

• Smart Device Development Junk characters when display in pocket pc through web service

          I have made a small program in which there is a web service which reads an xml data and returns a dataset of it. At the same time I made a pocket pc application that consumes the web service and displays the values of the dataset on a text box of pocket pc. but problem is when it displays the data on text box the data have some junk character. I am a beginner of using this please help me this is code of web service:-   <WebMethod()> Public Function BuildDataSet() As DataSet         Dim DataSetObj As New DataSet        ...Show All

• Visual Studio Team System TFS Version Control Tasks

  Microsoft.TeamFoundation.Build.Tasks.VersionControl.dll contains a get MSBuild task but no tasks for CheckIn or CheckOut. Are we relegated to calling the command line versions Pretty lame if so... Also not the original poster, but my team uses a Team Build for continuous integration. We also use code generation (lots!). To make sure we are building and testing the code from the code generation templates, we checkout, codegen, checkin, relabel and compile our projects. This allows us to promote a version of code to the Enterprise build that doesn't require code generation at that level as they can Get by label. We use are large ...Show All

• Visual Studio struggling with vsip

  Hi, As you can probably see from my other posts, I'm getting to grips with VSIP for Visual Studio 2003. My main task is to sort out help integration with Visual Studio and MSDN. I've now got my help integrated with Visual Studio but I don't think I can integrate with MSDN until the next version appears. I have converted my class comments <summary> etc into help but I'd like to add a few articles into the help. I've noticed that the Figures help contains articles and not class comments. The Figures help folder only contains the compiled files- is it possible to get the original files so I can understand how to create help which is artic ...Show All

• SQL Server Simulate ROW_NUMBER () in SQL 2000

  I would like to generate an incrementing column value to each row found in a query in SQL Server 2000.  My understanding of SQL Server 2005 is that you can accomplish this approximately along these lines:    insert into MyList (myNo, lName)    select ROW_NUMBER() myNo, lName    from Employee    select * from MyList    order by myNo    myNo         lName    -----         ------    1           ...Show All

• Visual C# Anyone used Visual SourceSafe with C# ?

  Hi guys, i am relatively new to C# and the VS.NET 2003 enviroment.I am currently developing a web-based application for my team onsite to allow programmers to rebuild applications into dlls based on the labels they specified on their sourcecode found within the Visual Source Safe DB. The primary flow can summed up like this; 1) user select csproj that they wish to rebuild 2) webpage display a list of all C# files and ALL instances  labels associated with that file. 3) Select the C# files they wish to rebuild 4) Process the rebuild process. Actually i am concerned more with how can access the VSS and actually extracting the labels ...Show All

• Windows Forms How to paint row with different background color if any row cell has changed?

  I have beaten my head against the wall trying to find a way to get the DataGridView to let me have a different background color for rows in which any cell has changed (in other words, rows that need to be updated to the database OR new rows that have been added). I have tried many different things, but none seem to work. Any definitive answer on how to do it would be greatly appreciated. Thanks. While I don't know the DataTable/View info to what rows have changed (rows updated or new rows), you can paint the row with different background color either by setting the row's DefaultCellStyle BackColor property o ...Show All

• Windows Forms FlexGrid / Datagrid question

  Hi, I know that there is no Flexgrid in VB.NET 2003, and most posts I have seen are directing people to the datagrid. My problem is that I don't think the datagrid is an option in my case. I have recently upgraded my VB6 app to VB.NET 2003, which uses a FlexGrid. I populate the grid at runtime...and NOT from a database table The grid uses column AND row headings, which I need to be fixed in place...ie when the user scrolls horizontally or vertically, the first row and the first column must always be visible. Here is an example of what I need, but imagine the grid being 40 cols by 300 rows: Hours Days Years Something.... ...Show All

• Windows Forms AutoScroll doesn't Paint until MouseUp?

  If I set a Panel to AutoScroll = true, and then at run time drag the scroll bar slider up and down, the contents of the Panel don't actually refresh as I am dragging the slider, but instead only after I release the mouse button. This is NOT good. How can I get the Panel to Paint itself dynamically as I am moving the scroll bar slider I figured out a workaround. The pseudocode is really: "if (!draggingSlider || showWindowContentsWhileDraggingSystemSettingEnabled ) { DoScroll() }". So I found out that the scrolling actually works "out of the box", as long as the computer is co ...Show All

• Visual Studio Team System Missing something fundamental?

  Hello! Im new to using the test features in Visual Studio. I tried some simple webtests and loadtests and it works good. But over to my problem: Two computers involved: 1. My computer with VS 2005 RC 2. Webserver running web application hooked to a Oracle DB. I record a new web test: 1. I enter username / password and press login. 2. I am being transfered to a page where I can perform different tasks involving a Oracle database. I do some changes to the database. 3. I log out. Recording everything works like a charm. But I cannot play this web test without an error on the login page! So everything that is recorded after the login is nev ...Show All

• SQL Server remote connections, permissions SQL express

  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=231616&SiteID= not sure why my post didnt post here but see the above link for the problem and the solutions i needed, ...Show All