Catherine Sea's Q&A profile

• .NET Development Question about SqlString

  Hi there, I'm using the datatype System.Data.Common.SqlString to convert "normal" DateTime-values into SQL-compatible values. One thing irritates me: Method "ToSqlString()" always format the Year with 2 digits (yy/MM/dd). Is there any chance to change this behaviour so that ToSqlString() puts the year as a 4-digit number in the output Thank you. Reiner Were you calling SqlDateTime's ToSqlString() method The method actually calls System.DatTime.ToString() with a null IFormatProvider. Quote from MSDN: The provider parameter is typically a DateTimeFormatIn ...Show All

• Visual Studio Express Editions Compiling Single File

  I'm trying to compile a single cpp file. I'm migrating a project from someone else's source to my way of doing things a few files at a time so I don't get lost. The source I'm currently working with is Borg 2.28 from http://caesum.com/download.php You've left us to guess what the problem is First of all, you need to create an empty project that you can add files to.  Then, I wish you luck - the whole point of a bunch of files being in a project is that they work together, and tend to be somewhat reliant on one another.  It's unlikely there will be too many classes you can compile and run  ...Show All

• Windows Forms Autoscroll

  When I use AutoScroll, scrollbars never show up if the controls are outside of the container to the left or top of it, only to the right or bottom. How do I fix this Yes you can access autoscrollbars by using p/invokes to the Windows Shell functions. Check this link: http://msdn.microsoft.com/library/default.asp url=/library/en-us/shellcc/platform/commctls/scrollbars/scrollbarreference/scrollbarfunctions/setscrollinfo.asp But this is not something you need to do know. Still you might want to check my post on richtextbox & autoscrollbars to see a sample on how it works: http://forums.microsof ...Show All

• SQL Server Collapsable Columns not showing up in export to Excel

  Dear Anyone, I have created a report that has collapsable columns. We had used the visible toggle property in reporting services. While the colpsable column works well in report manager, it doesnt work anyone when we export the report to excel. Even of the report is expanded, the report in excel would always show up with just the columns that are the basis for the collapsable column. Is this really the behavior when it comes to collapsable columns and exporting to excel Example: Column A toggles Column B, Column C and Column D. Thanks, Joseph I've solved this issue setting the hidden columns to be by defualt v ...Show All

• SQL Server SQL Server 2005 incorrectly claims I don't meet minimum service pack level requirements?

  This doesn't make any sense. I am trying to install SQL Server 2005 on SBS 2003 with Service Pack 1. According to Windows Update, there is nothing left for me to install. However, I am getting this error (while installing SQL Server Express and the Developer Edition): "Your operating system does not meet Service Pack level requirements for this SQL Server release. Install the Service Pack from the Microsoft Download Center at http://go.microsoft.com/fwlink/ LinkId=50380 , and then run SQL Server setup again." When I go to the link, there is nothing there to download (it takes me to the main Microsoft download page). I meet al ...Show All

• Visual Studio 2008 (Pre-release) How to add annotations to xps document through the DocumentViewer control ?

  Hi, I have one question to ask. How to customize DocumentViewer control for supporting annotations to xps documents Thanks! Yes, this functionality is available now. See the following SDK references for assistance: DocumentViewer with Annoations XML-Store Sample http://windowssdk.msdn.microsoft.com/en-us/ms771348.aspx Annotations Overview: http://windowssdk.msdn.microsoft.com/en-us/ms748864.aspx SDK Samples are not currently available online, so in order to get the source for the sample above, you'll either need to install the offline SDK, or download all of the WPF SDK samples from the team blog si ...Show All

• Visual C# How to Read/Write DBF file In C# use OleDb

  See the topic! Give me an example to show me how to do this ,thx! And my msn is  i_will_communicate_through_this_forum@msdn.com  I can't insert a Datetime Object into the DBF file,why Hi pj. I Try it by use Hard-code to insert data.It can insert new rows into DBF files. but when I change it to use OleDbparameter ,It can't work now. I don't know what's wrong with it. I think may be : 1,The Datatype Change wrong. OleDbType.Type is not fitted in DBF Type. like Logic(Query Out is T or F). 2,Make Parameters wrong. ...Show All

• SQL Server Importing dBase files with the SSIS Import/Export Wizard

  I saw this post by dterrie in the Wishlist thread and I just wanted to second it: " How about bringing back a simple dBase import. The SSIS guys are clearly FAR out of touch with reality if they think people who handle data no longer need to work with dbf files. I've seen alot of dumb stuff in my day, bit this is just sheer brilliance. I just love the advice of first importing into Access and then importing the Access table. Gee, why didn't I think of such a convenient solution. I could have had a V-8." I've been struggling with this the last couple days and finally decided to import the dBase III file into Access and then i ...Show All

• SQL Server System.Web.Services.Protocols.SoapException: The item '/foldername' cannot be found

  I am trying to figure out how to correctly reference the directory to my subscriptions: Dim subs As Subscription() = rs.ListSubscriptions( "/SSS" , Nothing ) System.Web.Services.Protocols.SoapException: The item '/Hedi' cannot be found. ---> FYI: I replaced sss for privacy purposes only here Does /SSS exist in the catalog For ListSubscriptions() to work, the item must exist in the catalog and either be a report or a linked report. If /SSS exists, but is not a report, then you should see a WrongItemType exception. ...Show All

• .NET Development Reading TextFile and execute command for SQL

  Hi. I was not sure where to post this, if it should be here or in the SQL subforum but I thought it would be here since it is an IO thing. OK, I am creating a "management" panel for a WinForms app, C# .NET 2.0 and running SQL Server 2000 SP4 Now I have generated an SQL Script from SQL to create a database. This works fine, as I have copied the text into clipboard then pasting it in the Query Analyzer, did a syntax check and executed the script, works perfect no errors. So I then save this to a textfile. My application will create the database. In order to create the database, it needs the script commands. So I u ...Show All

• Windows Forms "Destination File" problem

  I can't publish my project due to the following error, does anyone have any ideas of what the problem is "DestinationFiles" refers to 1 item(s), and "SourceFiles" refers to 2 item(s). They must have the same number of items.    I don't have a clue, any help would be appreciated. Mark. I don't have an answer to this problem& ...Show All

• Visual FoxPro Dynamically show and hide grid column

  Can anyone help me how to hide and show grid column using code on the fly dynamically Set the Column's Visible property to .F. to hide it, and to .T. to show it. As a general rule hiding and showing things is bad for the users - it confuses people when they sometimes see one thing, and other times another. In your specific case you may have no choice, but, as I say, generally it is not good UI design. ...Show All

• SQL Server Changing SSIS package - new user question

  I saved a simple export/import package from the import/export wizard to a .dtsx file/package. Now I want to change the package to delete/truncate all of the tables before adding data. (since this has 80 tables it would have been a pain to edit each of them individually) How can I easily go about doing this with the SSIS package. I can't find out where this would actually be executed. Also, how can I actually view the code behind the SSIS package. Thanks. fcb wrote: I saved a simple export/import package from the import/export wizard to a .dtsx file/package. Now I want to change the pa ...Show All

• Visual Studio Generate many files from one template?

  I have a DSL now taking shape, including generating code that executes properly, and I must say I am pleased with how quickly it has come together. Now I have a secondary goal to fill: producing static documentation from the diagram. I'd like to produce a set of HTML files (one for each instance of the primary classes in the DSL). I don't see how I can do that with the current structure, which allows me to generate exactly one file from each template. Do I need to create a new DirectiveProcessor or TextTransformation class Can you offer any pointers on how to create many files from one template Thanks, Brian. ...Show All

• Visual Studio Team System Who am I?

  No this is not an existential question. The Team Fonudation Server seems not to know and I can't work it out myself! Let's put it plain and simple. I am a user called "Bernd Wechner". Everything I did until recently on the TFS was clearly by Bernd Wechner. Reently (I can't tell when exactly because my activity has been low and sproadic, we're just kick starting the system) everything I do is attributed to a user called TFSSETUP. That is the history of work items I change, the "All My Work Items" query and any files I edit int he Document library (and the version history of them) show "TFSSETUP" as the user ...Show All