bjquinniii's Q&A profile

• Windows Forms Format phone number

  Hello, I have a text field where the user types in a telephone number. When the user is done typing the number and the text field loses its focus I need to take whatever the user typed and format it to a standard format. i.e. ###-###-#### If a user types 1234567890  I need it to change to 123-456-7890.  Any ideas on how to do this or examples Thanks! You want to create a control based on the textbox ( or add an event handler for lose focus in your main code ) and then reformat the string there.   ...Show All

• Visual Basic No editor for ".vb" in VS2005 Beta2

  Hi, I have received the VS2005 Beta2 DVD from Microsoft last week, installed it, and it worked fine for a couple of days. Then I went to the .resx file to edit some resource for the project. I then come back to open the .vb file and there it goes, the editor is replaced by a "Catastrophic Error" page  (not an error dialog box) sayiong something is wrong with the VB editor. I quit the IDE and reopen, then reload the vb project up. Quite unusual it starts up with the .resx file and not the .vb file as usual. I then double click on the .vb file from the solution explorer, and then an error box came up: There is no editor avai ...Show All

• .NET Development MessageQueue.BeginReceive method

  I like to know whether MessageQueue.BeginReceive() will receive messages FIFO or not. Another Question MessageQueue.BeginReceive uses IAsyncResult to callback which intern uses ThreadPool to call to client. Its any drawback of using ThreadPool. vichu wrote: Thanks for your quick reply. I am consuming the message one by one. Once I process the message then I call BeginReceive method. Its Ok. My code is like this. private IAsyncResult m_asyncResult; public void Start() { queue.ReceiveCompleted += new ReceiveCompletedEventHandler(OnReceiveCompleted); m_asyncResult = queue.BeginReceive(TimeSpan.Fro ...Show All

• SQL Server Works fine inside BI Dev. Studio, but fails when scheduling it in SQL server 2005.

  Hi! We are currently developing a project in SQLIS using the BI dev. studio. The package executes with no problems in the development environment, but when I try to deploy it and execute it using the SQL Server Agent, the package fails. "Work flow" ----------- 01. Build a package deployment utility (Rebuild all). 02. Runs the deplotment utility. 03. Checks that the latest package has been installed. 04. Creates a new job in SQL Server, using the SQL Server Agent.  05. Adds a new step to the job. 06. Sets that it is a DTS package that should be run ("file-based") 07. Sets the location of the package. 08. Saves the job. 09. Starts t ...Show All

• Windows Search Technologies PST

  I have thousands of Mails archived in PST files. Is there a possibiltiy to search also these mails Yes, but open up outlook and then open up at least the top level folder in each .PST file. It seems like the indexer doesn't recognize it until it is opened in Outlook, (perhaps a FileWatcher thing rather than a Sessions.Folder quiz, dunno.) You can check it has found them by using the 'Indexing Status' window, i.e. when I first went back and clicked on a seldom used old PST my 'Items left to scan:' jumped up by a few thousand - a good sign it's found the content to index. ...Show All

• Windows Forms Displaying An XML Document In a WebBrowser Control

  I have an in memory XmlDocument that I would like to display in a windows forms application. I figured it would be easy enough since IE displayed XML well and I could just use a web browser control and pass the raw XML to it. Unfortunately the control treats the text as HTML and tries to format it accordingly. Any Ideas Does your xml data contain some kind of header to inform the WebControl that it deals with xml data I mean something like: < xml version="1.0" > - < info xmlns =" x-schema:#SchemaDomainInfo " >........</info> I shoud try it too... ...Show All

• Visual C++ How to handle CString in COM Interop

  Hi, I have a C# dll which has functions: public string a() { string aa; . . return aa; } public void b() { } and a wrapper header created by system when I added MFC type library of C# dll into unmanaged c++ has: CString a() { CString result; InvokeHelper(0x60020005, DISPATCH_METHOD, VT_BSTR, (void*)&result, NULL); return result; } Now I am trying to get return value of a() and convert to char *, but following code doesn't work. if (obj.CreteDispatch("...")) { obj.b(); CString str = obj.a(); } obj.b() works but obj.a() is error. Can anyone help to work this out and how to convert CSt ...Show All

• Visual Studio Team System tfsbuild delete working but report not changing

  There's a cryptic title. Here's the situation: I created a couple of builds using Team Build and everything was correctly published. I used tfsbuild delete to delete these items because they were test items. The items were reported as deleted (and all of the build information was deleted (drop location, build location, etc.). However, when I re-ran the build report, those builds were still listed there. Is this a known bug or is there a manual way that the results of that report has to be changed Thanks. Jeff Hi Jeff - Thanks for reporting this. We are investigating this currently. Are you working ...Show All

• Windows Forms How to pop-up text edit window in DataGridView?

  One of the textboxes in my DataGridView holds lots of text (like a detailed description). I'd like to present a large text editing window to the user when she edits this column.  Is there any way to do this Thanks The easiest way to do this is to handle the EditingControlShowing or the CellBeginEdit event and basically perform a ShowDialog call on your pop-up text window. I tried this with a second form (form2) that has a textbox and button on the form. I have a public method called ShowDialog that takes a string value and returns a string value: public string ShowDialog( string formattedValu ...Show All

• SQL Server Aliasing columns for a DMX subquery

  I require the column of a nested table (KOL s) as part of the output of my DMX query, which needs to be written out to a relational table. Hence, I flatten the <select_list> of the SELECT DMX query as below: SELECT FLATTENED ([Speciality].[SPECIALITY ID]) as [Speciality_Id], (0) as [Bool_NameInAuthors], (0) as [Bool_EmailInAbstract], (0) as [Bool_AffiliationInAbstract], ( SELECT ([KOL ID]) as [Id], ([FIRST NAME]) as [FirstName], ([MIDDLE NAME]) as [MiddleName], ([LAST NAME]) as [LastName], ([AFFILIATION]) as [Affiliation], ([EMAILADDRESS]) as [EmailAddress] FROM [Speciality].[KO Ls]) , ( S ...Show All

• Windows Forms Display Blobs on Reports??

  I need to create this typical report in which I need to show that actual content stored as blobs in the SQL Server Database. The problem is that some of them are PDF documents while others can be word or image files. So my complex problem if broken into two are : 1. What is the best approach for creating reports which have content in case of a Winform application ( ReportViewer or Crystal or ) 2. Since the content is of varying nature , is there some solution to first have them change into a common format and then have it displayed ( for ex: convert .doc and .gif files to PDF and then show it ) or is there some container with ...Show All

• SQL Server 2005 Cursor Looping Issue

  I've just begun to work in 2005 and am trying to run a cursor without any modification, which has proven to work in SQL 2000 and it's not looping. the cursor has a few declared variables, running a select statement and assigning the returned value to the variables, then executing a sp using the variables as input.  It is really written out textbook, for example: declare @var1 int declare cuMyCursor Cursor For (Select etc...) Open cuMyCursor Fetch Next from cuMyCursor into @Var1 while @@fetch_status = 0 begin execute myStoredProc @var1 Fetch next from cuMyCursor into @Var1 end close cuMyCusor deallocate cuMyCursor 1 record ...Show All

• Visual Studio Problem extracting source code from VSS to local folder.

  Hi guys, i been trying to extract a certain project based on the labels that a user select from a web based UI that i have developed,however when my backend code tried to retrive the project based on the label, the source code just does not appear in the folder i specified. I have attached a fraction the code that does the getting of source code from the VSS. foreach (IVSSVersion ver in labelCollection) { if (ver.Label.ToString().Equals(srcLblName)) { labelNum = ver.VersionNumber; //the label index to extract   Console.WriteLine("Version Label Num to be extracted:"+labelNum.ToString()); Console.WriteLin ...Show All

• SQL Server Blocking updates of a table

  Hi, I've been trying to design a way for me to issue a transaction that: Block all inserts on a table when row X has a certain value (call it A) Add a row to the table with row X containing A Add rows to another table Unblock inserts Commit transaction Is this possible Can anyone give me some pointers as to what to do Thanks in advance! I assume you only want to block Inserts but not Updates, Deletes and SELECTS. You could try using an Insert trigger that would rollback the other transactions until a condition has been achieved. ...Show All

• Windows Forms datagridboolcolumn

  Hello I've got an datagrid and in it i have a column with datagridboolcolumn. It works fine but the problem is that i'm filling the grid with empty rows when it's not filled with data. The problem is that a would like to get rid of the checkboxes on the empty rows. I'm filling the empty rows from the dataview and the rows contains d ...Show All