William Choong's Q&A profile

• Visual C# Avoid duplicate data

  Hi, I want to insert data in a database. How is it possible to avoid inserting duplicate data If I want to insert a row which also is in my database, I get an Exception and my program stops running. How can I tell my programm to go on without stoppng even if there was an Exception Or has anybody a better and faster solution ! Thank you! 1.  For each table create a stored to do the insert/update. This will provide a gain in that the sql will be compiled.  given Table1( key int, data1 varchar(50), data2 datetime) then:       Create proc Process1(@key int, @data ...Show All

• Visual Basic Using each digit of a byte

  This one is kind of interesting. A byte consists of two digits, right Now, each digit of this byte holds data for a different object. Say the byte is 7F. The 7 would be the data for one object and the F would be the data for the other object. Or say the byte is 04. 0 would be the data for the first object and 4 would be the data for the second object. Get it How would I write the byte this way Say I have two textboxes, txt1 and txt2. txt1.Text = 4 and txt2.Text = 9. I want to write the byte 49h to an address to be specified later. And to read it Now say that the byte is 3F. I want txt1.Text = 3 and txt2.Text = F. I hope I have made ...Show All

• Visual Studio Team System InstallationError 32000: in SetupWarehouse.exe (Team Foundation App-Data Tier Beta 2 Setup)

  Hello All, After a lot of installation problems installing Foundation Server I cleaned the Windows 2003 Server Standard Edition and started, allmost desparate, all over again. I checked everything and even started reading the installationmanual. I checked the User (TFSSETUP and TFSSERVICE are local Administrators) and  all the services (Analysis Server, Report Server, SQL Server, SQL Server Agentand Sharepoint) and started the installation Eveything seemed to be fine for a while. Then, almost at the end of the installation, the following Exception occurred: Message on the Screen: Error 32000. The commandline "C:\Program File ...Show All

• Visual Studio Team System Cant start a build

  Something has happened to our Team Server. Yesterday afternoon, the server stopped allowing us to start a Team Build. I have tried both through the IDE and the command line. After a couple minutes the process times out with message: Failed to retrieve data from the server. Please verify the network connection and try again. To my knowledge, no settings were changed on the server.  We had run several builds in the morning, and then it just quit in the afternoon.  We are still able to use Source Control, so we are connecting to the server. Any thoughts I will try to get my network guy post anything seen in the event logs. --MikeH ...Show All

• Architecture Message vs Service.

  EmailValidation message vs EmailValidation Service. SOA is mostly about services and messages. Rather than create a number of services with different names would it be recomended if we create 1 generic service and have it request/reply messages. For ex: EmailValidation service. Instead of creating a service for email validation, create a validationService and have it process all the validation messages for the application. Just wondering how others are approaching this. Thanks Sailu Hi sailu, I think SOA is more about bringing people, business processes, policies and technology more closely aligned by using loosely coupled ...Show All

• Visual Studio Team System What is the MSDN Visual Studio 2005 Team Suite "Trial" Edition?

  Hi everybody, Today I found the Visual Studio 2005 Team Suite Trial Edition in MSDN Subscriber Downloads. I am a MSDN Universal subscriber and have transitioned my subscription to get access to the Team Suite for Software Developers edition. Maybe anybody from Microsoft can clarify: - What is the "trial" meaning Usually MSDN software is not limited as towards features or usable time - Is the trial edition the one which I get due to the transition Best regards Ralf The setups for the agent and controller are located on the Team Test Load Agent media, which is not available for download through MSDN Subscri ...Show All

• Windows Forms More of a Visual Studio Wish

  Why doesnt the "add new item" dialog have an "Interface" entry   We have to create a class and then go in and delete the constructor, and replace "class" with "interface". Its not a big deal, just one of those little nits that annoys you every time you use it. It's funny and a nice feature (at least in VS ...Show All

• SQL Server problem with panda antivirus and olap cubes

  I have the next problem: i have MS sql server 2005 installed in a server. We have some olap cubes in the server deployed with analysis services 2005. When we try to connect to the analysis server from a client pc using pivot tables we obtain this error: "Errors in network layers. Error code=0XC10D0009, External code=0x00000000" The client pc has panda antivirus (corporate) with true prevent When i unisnstall it, we can connect to the analysis server and to the cube normally and when we install the antivirus again (without true prevent and with the minimun options) the problem starts again and we can't conect to the analysis server. ...Show All

• SQL Server Retriew number of sunday,s for a given month in sql server

  hello i am student and developing project having the fallowing problem 1: i want to calculate the number of sunday,s in a given month. OR between two given dates like 01/02/06 and 28/02/06 . thanks Hi, this should solve the problem, input is the day of the week you want to get. CREATE FUNCTION NumberOfWeekdays ( @StartDate DATETIME, @EndDate DATETIME, @Weekday TINYINT ) RETURNS INT BEGIN DECLARE @dt DATETIME DECLARE @NumberofDays INT SET @NumberofDays = 0 SET @dt = @StartDate WHILE @dt < @EndDate BEGIN SET @NumberofDays = @NumberofDays + (CASE WHEN DATEPART(dw,@dt) = @Weekday THEN 1 ELSE 0 EN ...Show All

• Visual Studio Express Editions BackgroundWorker Problems.

  Hello, I'm working on a simple app. that uses the GUI and 2 threads(backgroundWorker) to do some reading on some ports and to handle some alarms. The problem is that when ran on the target machine, it doesn't fire the update function, until it has finished or stopped. here's the basic function. 1- GUI loads. 2.- user configures the reader thread and starts the thread that keeps reading some ports. 3.- If the thread reads nothing, it updates with some progress, and if it reads something wrong, it updates with another progress (yes, I use the progress as status code, as there's no other way to do this with it... or is there a way ) 4. ...Show All

• SQL Server Questions about SQL Express

  What is the user limit for SQL Express Is there a free way to convert Access files and import them into SQL Express Is there any way to take databases offline without have to detach them If anyone knows the answers to even just one of my questions feel free to post. ...Show All

• Visual Studio Team System Wrong URL for reports & documents in team explorer?

  The documents and reports folders in team explorer are disabled. When I check the properties of the folders, the server name is correct (it's the URL) but the URL isn't. The server name shows as computername.xxxx.com but the URL just shows as http://computername/xxxx . All the services are running correctly and I can properly navigate to reporting and sharepoint using http://computername.xxx.com/... How do I tell team explorer that it is looking in the wrong place (as though it is on a LAN instead of WAN) Thanks! When you set it up, the server is populated with the computer name for Sharepoint server.  ...Show All

• SQL Server (MDX) EXISTING operator - inconsistent behaviour when using subcubes?

  I am getting what I think is inconsistent behaviour when using the EXISTING operator to obtain a set defined by the current query context... See the two queries below (explanation follows). WITH MEMBER [Measures].[MyDate] AS Tail ( EXISTING [Date].[Calendar].[Date], 1). item (0). membervalue SELECT {[Measures].[MyDate]} ON 0 FROM [Adventure Works] WHERE [Date].[Date].[October 26, 2002] ... returns [26-10-2002] WITH MEMBER [Measures].[MyDate] AS Tail ( EXISTING [Date].[Calendar].[Date], 1). item (0). membervalue SELECT {[Measures].[MyDate]} ON 0 FROM ( SELECT [Date].[Date].[Oc ...Show All

• Smart Device Development Treeview Click Event

  Does anyone have a good solution to the Click Event for the Treeview control in .Net Compact Framework   Any third-party control suggestions (I'm using VB.NET) I am currently using AfterSelect event, as prescribed by Microsoft and many others.  However, when I click a node, I open a new form based on the node I clicked.  When the form closes, it updates the treeview control, which causes the AfterSelect event to fire again and reopen the form.  Also, once selected, you cannot select the same node again unless you move off it and back on it.  In my case, causing a new form to open when moving off it.  In additio ...Show All

• .NET Development (500) Internal Server Error.- System.Net.WebException.

  I need to send SOAP requests to a webservice via HTTP (HTTPS), I have 2 URLS, when I use telne t command using first one (test) I am only getting this message Connecting To xxx.xxx.xx.net 443...Could not open connection to the host, on port 443: Connect failed While the second one(production) is giving me a blank screen, when running the below given program with that URL getting this error, The remote server returned an error: (500) Internal Server Error.- System.Net.WebException. url = " https://xx.xxx.xxx.net :13710 /xxx/xxx/WSRPCRouter "; try { XmlDocument doc = new XmlDocument(); doc.Load(@"C:\soapreq.xml& ...Show All