5thCav's Q&A profile

• SQL Server Shading By Value

  Currently in my reports I am shading every other row by using an expression in the background color property. This works fine. Is there any way to shade by other options I have a report with a non-unique id as the first column. I would like to be able to alternate the background color based on these id's. For instance I might have three rows of white background (id = 1), five rows of grey background (id = 2), and two rows of white background (id = 3) etc. Is there a way to do this in MS Reporting Services You could try this for the background color or for the font. =iif(Fields!FieldName.Value = " ...Show All

• Windows Forms TreeView Double Click and canceling expansion

  Does anyone know of a way to cancel the node expansion on double click in a treeview   I can't seem to figure it out, it seems that the events happen in an order that does not allow me to do this, has anyone figured out a workaround Thanks, paul Tyng Silly question but is there anything wrong with  Private mbIsDoubleClick As Boo ...Show All

• Windows Forms Quicktime ?

  Any one had any luck using quicktime ocx in a windows form  When I use it I get : An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in axinterop.qtactivexplugin.dll Additional information: Exception from HRESULT: 0xFFFFFFCE. But this may be because I have not initialized the control properly. Thanks in advance. ...Show All

• Visual Basic Number Only Input

  First of all, Sorry of this is a really simple question. I'm a bit of a noob. Is there anyway to make an input box that will only allow the input of numeric characters Thanks in advance. EDIT: The following code was taken straight out of help and was used to allow only numbers to be entered into a textbox.     ' Boolean flag used to determine when a character other than a number is entered.     Private nonNumberEntered As Boolean = False           ' Handle the KeyDown event to determine the type of character entered into the control. &nbs ...Show All

• Windows Forms textproblem

  Hello, I've got a problem with showing a textfile in a correct manner. Blank characters makes my "columns" that I have made with blank characters/tabs. Let me show what I meen... my textfile: text    mjukdjur   datum                        9999-66-33                        9999-66-33   Now everything is fine, but when I try to put the text inte a control my "columns" is "corrupt". I've t ...Show All

• SQL Server Redudant Data on a table column...

  Good mornig, I want my table column to accept redudant data type, so what to do Regards What do you mean by that HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C++ I have a problem with SetDlgItemInt

  int a; void CCALCULATOR01Dlg::OnBnClickedButton1() { // TODO: Add your control notification handler code here GetDlgItemInt(IDC_EDIT1, &a ,TRUE); SetDlgItemInt(IDC_EDIT2, a ,TRUE); } In VC++ When i compile it 1>------ Build started: Project: CALCULATOR01, Configuration: Debug Win32 ------ 1>Compiling... 1>CALCULATOR01Dlg.cpp 1>Linking... 1>Embedding manifest... 1>Build log was saved at "file://d:\Work Sheet\CALCULATOR01\CALCULATOR01\Debug\BuildLog.htm" 1>CALCULATOR01 - 0 error(s), 0 warning(s) ========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 s ...Show All

• Windows Forms Error when compiling - Totaly Lost !!!!!

  Hi guys. I have a form, with a tool bar at the top File, Edit etc etc When I compile I get a few errors. Not sure what they mean, and how to get rid of them. I followed the instructions from my book ( wrox, Beginning VB.NET ) Attached is a copy of the screenshot I took to show the errors. Thanks in advance for any help given Best Wishes Max http://www.auxi59.dsl.pipex.com/diagram2.jpg Below, Code for the menus.... Private Sub ExitToolStripMenuItem_Click( ByVal sender As System. Object , ByVal e As System.EventArgs) Handles ExitToolStripMenuItem.Click         Me .Close()     End ...Show All

• SQL Server An incorrect or unsupported HTTP function call was made error

  Hi All, I've got this error " An incorrect or unsupported HTTP function call was made " I can't browse SQL CE Agent using IE also. How to solve this error TQ thankss Darren, I tried so many time to generate new snapshot but I still got that 2 error. Finally, I've re-install my SQL Server 2000, SQL Server SP3a and SQL Server CE Tools.. n my replication success.. :D ...Show All

• SQL Server Problems with Date And Time

  Hello everybody, I have a problem with a date. I retrieve data from an Access database, where there are two fields, one for the date and one for the time. I have to join this two fields in my destination column, but I don't know how to do it... I tried using a Derived column, in which I cast this two fields in string, concatenate them and then cast them back to datetime, but it doesn't work.... Does anyone knows how to resolve my problem Thanks Did you get an error from SSIS when trying to parse the derived column code (DT_DATE)((DT_STR,4,1252)YEAR(<DATE_COLUMN>) + "-" + (DT_ ...Show All

• Windows Forms A component does not recognize if it is in design mode!, a bug?

  Hi I just discovered something interesting while I was creating my library If you are using the last release of Microsoft Visual Studio.NET 2003, create a new component, and in the component constructor add the following: if(this.DesignMode) System.Windows.Forms.MessageBox.Show("Design Mode On"); Now, compile the code, place the component on a form, close the form and open it again ...Show All

• Windows Forms SaveFileDialog actions wrong

  I have a strange issue. Seems like a few others have had it, but I couldn't find a post on msdn about it. SaveFileDialog either returns DialogResult.OK or DialogResult.Cancel. The problem is if the file name the user wants to save the file as already exists in the current directory, another dialog pops up and asks if the user wants to overwrite. Even if I click "Yes", the SaveFileDialog returns DialogResult.Cancel. Even if this is the correct action C# creators intended to have happen, it goes against all logic and doesn't allow me to know that the user wants to continue on with the save. On another site's forum, someone resp ...Show All

• SQL Server DW data load speed and sql page size

  We are working on our first DW in sql 2000 (later sql2005). We anticipate loading 30GB+ of data into our Analysis server. Is it possible to increase the sql page size from 8K to something larger (I'm hoping that doing so would facilitate the data loading speed. Or would that just cause more trouble down he line ) Bill I have loaded a 120gb db with 115 million rows, many dimensions and hierarchies in 2hrs on a Quad x64 with 8gb. The cube is 6gb in size. Partitioning the cube improves thr throughput, as the partitions are processed in parallel. I have not changed any parameters in db engin ...Show All

• Visual Studio Team System Problem Creating New Team Project

  Hi. Using 2003 Server with Beta Refresh 3. Sharepoint is extended on the default and no other site. Browsing to http://servername/ works but not Reports or ReportServer. When I create a team project the following error occurs:   Error Unable to connect to the specified SQL Reporting Services at EVERSERVER1.   Heres the Log   1/9/2006 12:06:44 AM | Module: ELeadServiceMediator | Team Foundation Server proxy retrieved | Completion time: 0.359375 seconds 1/9/2006 12:06:44 AM | Module: ELeadServiceMediator | The template information for Team Foundation Server "EVERSERVER1" was retrieved from the ...Show All

• Windows Forms how to get the size and type of images?

  hi i have a windows form . users can send their images , from that. but i want to chek the size and type of that files to be in appropriate formats. for ex. they should be able to send only .jpg files , with a defined sizes, and not else. how can i do that thank u You can load the image using the Image class.  On this class are properties to tell you the format and size of the picture.  You might consider making an enhancement to automatically convert images to the correct size and format.  You can do this through the same Image class.  Size - Size of image in pixels. RawFormat - Will ...Show All