Sébastien Nunes's Q&A profile

• Visual Basic ReadOnly Property vs Function

  I've fallen into the habit of using properties for local variable access but there are certain occasions where I'm using a ReadOnly Property... Now that means I'm using five lines of code whereas the function version is shorter. Is there any sense in using readonly properties Have I overlooked something I see what you mean, Dick. That is exactly the way I've been using them. It just seems code heavy. I feel there should be two single-line constructs (maybe even just a variable modifier) to declare the functionality of properties. I respect that properties give the power to add in extra functionality but when you don't need them something like: Public Exposed Variable() as Type Public ReadOnly Exposed Variable() as Type ... se ...Show All

• SQL Server If...Else..Statement

  All, looking for help with outputting different text value into a cell. e.g. a column of a table will only ever have two values, Y & N. I am looking to populate a CELL within SSRS with Yes or No using a seperate Dataset. SELECT 'Yes' AS [LookupValue], 'Y' AS LookupCode UNION SELECT  'No', 'N' This gives me my two column to lookup which is what I want.  However, i need this to populate a cell with Yes instead of Y. I have tried using it as a parameter but to no avail. Anyone got any ideas If I understand correctly, perhaps you are wanting SELECT CASE [LookupCode] When 'Y' then 'Yes' Else 'No' END as [LookupValue] Is that what you are tryin ...Show All

• Windows Forms Add data source wizard not connecting to local SQL Server instance - error 25 connection string

  Hi - I'm having an error message trying to connect my VS 2005 Datagrid Control to a SQL Server (Standard Edition) database file. (and any other data related control). Going through the data connection wizard - I Choose the option to connect to a Microsoft SQL Server Database File - I browse and find my database .mdf file that I want to use - In Advanced setting I change user instance to false (cause apparently that only works as true for SQL Server Express edition which I don't have - I hope VS 2005 knows this) - In Advanced settings I change Data Source to .\MSSQLSERVER I now have a string looking like this Data Source=.\MSSQLSERVER;AttachDbFilename="C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\MediaCube.mdf";Integra ...Show All

• Visual C# "new" event handlers

  Given this declaration: Button myButton = new Button(); void myButton_Click( object sender, EventArgs e ) { MessageBox.Show("Click"); } What is difference between doing this: myButton.Click += myButton_Click; and doing this myButton.Click += new EventHandler( myButton_Click ); I've been doing it the simpler ( first ) way and I haven't had a problem (yet ), but I've noticed that most documentation I've read has it the other way, creating a new EventHandler. I'm not clear on what the effect of creating the new event handler is, and I am yet to discover what "The Bad Thing" is that's going to happen if i do i ...Show All

• .NET Development check SQL Server database/table size

  how can I check the SQL Server database & table size (in MB) using C# thank you very much.. I got this result and i wanted to know what are things i should consider or let me say; how will I know if the result was healthy database name: TEL_DATA database size: 37416.00 MB unallocated space: 1407.01 MB reserevd: 12285944 KB data: 7589280 KB index size: 4689896 KB unused: 6768 KB ...Show All

• SQL Server unable to deploy cube sourced from oracle

  Dear all I am new to SQL Server Analysis Services 2005. I am trying to create and deploy a cube with the data being sourced from Oracle. I am able to create the cube , build the project but when I try to deploy the project I get the following error: Error 1 OLE DB error: OLE DB or ODBC error: ORA-12154: TNS:could not resolve service name. 0 0 I have tried looking at the tnsnames file but of no use. Even thru the Analysis deployment wizard I am able to test the connection but when it is about to deploy I get the error. Please help me !! Thanks Shylaja The problem can be related to the service account that you run SSAS2005 under. This account must have rights in the Oracle database ...Show All

• Visual Studio Team System Power Toys failed to install

  Hi! Installation of power toys on my machine failed . The last view lines of the verbose error log are (if needed the whole error log is available): .... MSI (s) (34:C0) [08:09:57:677]: Executing op: ComponentUnregister(ComponentId={2DD323FA-3D9C-437B-BEAB-C516C569B2DB},ProductKey={C802488F-CB5F-48BE-BBD2-0C0F9E290E63},BinaryType=0,) MSI (s) (34:C0) [08:09:57:677]: Executing op: ComponentUnregister(ComponentId={98E68F3A-42CE-4CBB-ADF5-6C936BB7A9AA},ProductKey={C802488F-CB5F-48BE-BBD2-0C0F9E290E63},BinaryType=0,) MSI (s) (34:C0) [08:09:57:677]: Executing op: ComponentUnregister(ComponentId={91438838-2D70-44D4-ABB9-9F4F3D236C52},ProductKey={C802488F-CB5F-48BE-BBD2-0C0F9E290E63},BinaryType=0,) MSI (s) (34:C0) [08:09:57:677]: Executing o ...Show All

• Windows Forms HELP - data grid creating duplicate controls?

  Hi, I am using this code to crete a combobox in a datagrid, it works fine and creates the combobox in the column. The problem is it also creates a second combobox in the top left corner of the datagrid. Any Ideas Thanks. this .array = new ComboEditor (); this .array.Name = "LicenceTypeName" ; this .array.Text = "LicenceTypeName" ; this .array.DataSource = ds; this .array.DataMember = "LicenceType" ; this .array.DisplayMember = "LicenceTypeName" ; this .array.ValueMember = "LicenceTypeId" ; LicenceDataGrid.Controls.Add(array); LicenceDataGrid.DisplayLayout.Bands[0].Columns[2].EditorControl = array; ...Show All

• SQL Server Connecting on one remote computer but not the other on sql server 2005

  I am unable to connect to a remote server on Computer A from Computer B, but when I reverse it I am able to connect to a remote server on computer B from computer A. I have SQL Server 2005 Developer Edition on both computers. I am using the using the SQL Management Studio to connect. Both Computers have these settings Using Surface Area Configuration both have local and remote connections checked. Both computers using tcp/ip only checked. Using Configuration Manager both the sql server and the sql browser are running. Both computers have tcp/ip protocols enabled. Under the server properties on both computers, under the Security Tab, I have SQL Server and Windows Authentication Mode checked. Under the Connections tab I have Allow r ...Show All

• SQL Server Encryption - Protect from attacks by programmers?

  I can encrypt columns in sql 2005 but where do I store the key to decrypt the columns I can store the key in the database (or server on which the database resides) but I think that offers little security. I could store the key on another server that the sql server accesses only upon startup (though I don't know exactly how to do that). Or I could store the key on a removable drive that is read (and only needed) when the sql server starts up. What are your ideas on this matter TIA, barkingdog Hi, Before I implement your idea i would like to know more about the defenition of a current session. I am using EntLib, therefore each call to an SP opens / closes a connection from the pool. How ...Show All

• Visual Studio Tools for Office Office 2003 Interop Assemblies vs Office 2007 Interop Assemblies

  We have an Outlook add-in and have been installing the 2003 interop. That was easy as it only worked with Office 2003 or later. Now that 2007 is out, the question is which to install without having users have to make the decision. Does Microsoft have an MSI that makes that decision and installs the correct interop If it doesn't, it should have. Thanks, Pat HI Douglas it looks nice. Do you have implemented this with Registy search condition Or how do you have implemnted that Can you post or send me your example pealse. greatings CH-danman ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. New XNA 3D tutorial

  Hi all -- I have ported the first series of my MDX tutorial site to XNA beta2 code. You can find the first entry of the tut at this location: http://www.riemers.net/eng/Tutorials/XNA/Csharp/Series1/Starting_a_project.php It's an introduction to 3D game programming using XNA. During the coming weeks I will be porting the code of the other 2 series, of which you can find screenshots at the homepage: http://www.riemers.net/index.php expandall=1 As soon as XNA is released completely, the whole site will be built around it. Comments are welcome riemer Right. Certain changes to the device parameters might require the device to be recreated rather than just reset when toggling windowed/fullscreen. In that case, the grap ...Show All

• SQL Server Duplicate primary keys in input file

  'm trying to import a text file but the primary key column contains duplicatres (tunrs out to be the nature of the legacy data). How can I kick out all duplicates except, say, for a single primary key value TIA, Barkingdog No, but I will. BTW does SORT allow me to send those dups to an "erorr" file so I can see I can further investigate those "bad" records Barkingdog ...Show All

• Smart Device Development Choosing connection between GPRS/LAN/WIFI using .NET CF socket objects

  Most of our users go on-site so usually they can only connect to their internal network using GPRS. However sometimes when there are no "On site tasks", they can connect to their network on either 3 connections, LAN, WIFI or GPRS. Obviously when more that 1 connection to the network is avaible, in order to save time and money, our program should be able to choose the best connetion possible, which in this case is LAN, since choosing the GPRS connection will cost money and WIFI is slower than LAN. My question is that is there a way for the .NET CF framework to choose what type of connection lets say, HttpWebRequest will pass through Is there a manual override for this I also heard from other forums that it is automatic fo ...Show All

• Internet Explorer Development Help me Uninstall Old IE7 Beta 2 to install RC1 !!

  When I try to uninstall IE 7 Beta 2, I get an error that I can't uninstall due to a file I don't have. Now, I can't uninstall at all! Please help me!!! This doesnt work as i could not find IE7 in c:\windows and some of my utilities progs like paint, character map.... etc are missing.. sometimes windows media player ( 11) also cannot be opened! that missing file when we uninstall from Add/Remove i found in a genuine SP2 XP Profsnl. cd.. but after i clicked ok... another file is missing. a .dll file! ...Show All