ywz's Q&A profile

• Visual Studio Express Editions DataGridView question - using different fonts

  Is there a way to use different fonts/sizes in different cells in a DGV ie. I want a certain cell to have a larger text size or different color or font than text in the other cells. Is this possible Thanks... ...Show All

• Visual Studio 2008 (Pre-release) MatchAllEndpointBehavior is Gone

  Is there a replacement behavior I really do need similar functionality, and was using that extensively. Any ideas The ServiceBehavior property AddressFilterMode is what replaced MatchAllEndpointBehavior. Setting it to Any should give you what you want. ...Show All

• .NET Development Exception: DataTable internal index is corrupted: '5'. on ...

  Hi, I have a problem with bindingsource component in framework 2.0. I have a combobox bound to a bindingsource which is also bound to a dataset with 2 related tables and a datagridview bound to the same bindingsource. What I want to do is : When the selectedindex property of my combobox changes, the corresponding cell value must be changed in the datagridview. But although the value in bindingsource changes, datagridview does not display the new value. That value is displayed after I move the mouse over that cell and make it invalidate its region manually. Another error I caught is the one that you can see as the subject of my post. I do not know why i have that message when I try to change the property of ((DataRowView)mybindi ...Show All

• Visual Studio Team System Upgrading Workgroup to "Real"

  Apologies if this has been asked before, but I looked and didn't find a relevant post. We installed TFS Workgroup edition to mess with it. At this moment we're on the verge of finally "going live" and adding real projects. We have four users now, soon to be five. Eventually though we know we'll blow the 5-user limit. Turns out our Partner level (Gold with ISV competancy, etc, etc) gets us a "real" server license. We got a disk but it was bad so we're awaiting a replacement. So I have a couple of specific questions to put my mind at ease: 1) Are we supposed to just install the "Real" version over top of Workgroup We don't need to blow away everything and start from scratch I hope. 2) In the short term, if we in ...Show All

• Visual Studio Express Editions SQL querry between two dates

  Hi, I need some help with this please. I have a database table which contains customer orders. I am trying to code my SQL select statement to: 1) Only return records where the record orderdate is within the last 30 days 2) Between two dates, selected from the datepicker control. With regards to issue 1, I could fill a table with all the records for the account in question and then for each record do a datediff between the records order date and the current date to determine if the number of days is within 30 days. If yes then add this record to a temp table and then set this table as the datasource for the datagridview. There must be a more efficient way With regards to issue 2) ...Show All

• Windows Forms Click Once deployment issues from TFS Build

  I am trying, for a while now, to publish a VS2005  win app to be available using click once deployment.  Basically it is the application from   Mike Bouck's RAM  blog. I added this solution to TFS and created a build type integrating the deploy.proj file supplied by Mike Bouck's RAM  solution. When the application is 'Team build' (Trying solution build  by TFS, and devev /rebuild and MSBuild using corecompile target override in the tfsbuild.proj file), t he build process runs fine after modification of the Deploy.proj file for my environment. Deploy to the virtual root is subsequently successfull.  The issue here is that when i try to install the app from the publicationu ...Show All

• Microsoft ISV Community Center Forums Help with comma separated values in report

  Hi! A bit of a stuck-up. It’s no problem in creating a coma separated fields in .txt kind of file. But I have another problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing). I want to show several different values from one field (in query) on the report - now check this - They have to be separated by a comma in one line. If anybody is familiar with the solution just show me the direction and I’ll try to solve it by myself. Thanks in advance Nice try - wanna..... But maybe a step closer to the solution. I'm not receiving that error but instead another : Too few parameters. Expected 1 ...Show All

• Windows Search Technologies Windows Desktop search is inbuilt in Vista?

  Is windows Desktop search inbuilt on vista I think so for files, but not sure about emails and other resources. To be exact there is no WDS UI on Vista, as Vista has its own UI for search (i.e. in every explorer windows, in Start menu). Additionally, when one uses Outlook 2007 there is no need to download WDS as the engine is already there. ...Show All

• SQL Server Msg 2801, The definition of object 'xxx' has changed since it was compiled.

  1. Create table and 2 triggers with script below (*) 2. Run the following script: use testjrl ; begin transaction ; update testtable set workphone = '333' where id = 1; rollback ; Get following error message: (1 row(s) affected) Msg 2801, Level 16, State 1, Procedure trgTestTableInsertUpdate, Line 7 The definition of object 'trgTestTableInsertUpdate' has changed since it was compiled. The statement has been terminated. 3. Change trgTestTableInsertUpdate trigger to alter table TestTable disable trigger trgTestTableDelete select 1 alter table TestTable enable trigger trgTestTableDelete 4. Run the script from step 2 again - works fine. Questions: a. Why does first error occur ...Show All

• SQL Server WHERE clause

  Hello. I have a database that a client set up that's kind of a mess, but I need to pull records from it. Is it possible to use a WHERE clause with an array The SQL I am getting is really messy, kind of like SELECT Title FROM Master WHERE Cat1 = leg OR comm OR err OR and so on... OR Cat2 = leg OR comm OR err OR and so on... there are multiple categories for each record in the table, with subcategories under main categories. But he only has one record in the table with all of these categories specified. Any help is much appreciated.   MarcD wrote: select columns from table where col1 in (comma, delimited, set) or col2 in (another, comma, delimited, set) Hope this helps. bill and cl ...Show All

• Visual Studio Tools for Office Hiding Columns based on named ranges or variables

  Hello, I'm new here and hoping that you can help me out with a problem I have encountered while attempting to write some VB to hide a number of columns in Excel based upon a form. The problem I am having is finding a way to select multiple columns to be hidden, as I cannot use the .hidden property with a range but have to resort to Columns(foo,bar). For example I want to be able to do something like Columns("C:Z").Hidden = True without having to hardcode the C:Z portion. Unfortunately I can't find any other way to parse the columns function except with the quotes and : I attempted to replace C and Z and concatenate the variables with ":" but had no luck as VB did not like syntax. I'm certain I must be overlo ...Show All

• SQL Server Multiple rows into single column

  I'm working on a Reports and I need to combine data from multiple rows (with the same EventDate) into one comma separated string. This is how the data is at the moment: EmployeeID EventDate 2309 2005-10-01 00:00:00.000 2309 2005-10-01 03:44:50.000 2309 2005-10-01 08:59:00.000 2309 2005-10-01 09:29:44.000 I need it in the following format: EmpID EventDate EventTime 2309 2005-10-01 00:00:00,03:44:50,08:59:00,09:29:44 There is no definite number of EventTime per Employee for a particular EventDate. And i don't want to use Iterative Methods. Thanks & Regards Rajan Hi Rajan, If you have access to sql server magazine take a look at this article, http://www.sqlmag.com/Article/ArticleID/93907/sql_server_93907.html ...Show All

• Visual Studio Team System [Urgent Help needed] VSTS unable to log into ADFS!

    Hi All, First of all, here is what the performance rig is like 1) Two webservers in clustered environment on a subnet. 2) One ADFS server in the same subnet as the webservers for authentication. 3) One DB server on the same subnet. When user navigates to the http://webserver/ they are redirected to the http://ADFS/ machine which would display the user a page where he/she would choose their federation server, once they choose their federation server this page would place a cookie and would not be displayed next time user is redirected for authentication. After choosing the fedration server user is presented with a login page which is hosted on the ADFS box, user would put their CORRECT user name and password ...Show All

• Visual Studio Express Editions FileSystemWatcher.Filter questions

  Looking at the MSDN documentation's examples, they only show how to specify certain types of documents. For example, using *.* for all files, *.txt for just text files, *doc.txt for files ending in doc.txt and so on. I'd like to know if I would be able to specify multiple document types in the filter. For example, I would like to find all types *.txt and *.doc I understand that I can just find all files and then filter out the ones I want in other ways, but since the class contains a property to filter types, I'd just like to know if multiple types can be specified in the filter property. Thanks, Bill ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to change Model indexbuffer

  I'm currently trying to change indexbuffer of a model with a SetData func, but it remains unchanged... My general task is to draw certains polygons of a model, what i must to to make it I found here topic about how to get vertexbuffer of a model, but i still can't set my indices... Any help would be appreciated :) i don't understand why setdata didnt work... anyway this is funny "The XNA Framework Content Pipeline, which is a set of tools that allow developers to more easily incorporate 3D content into their games." - XNA FAQ in mdx all i needed is load a model and in xna (that helps me save my time!) i need to write my own classes to make things that in mdx i already could use without any problems........ ...Show All