Dan Di Mambro's Q&A profile

• SQL Server What is SQL?

  my apoligies for the simple question. i have just had to load sql server onto my desktop in order to use some software called OnTime. OnTime needed to buid a batabase. so i undestand sql server can make databases. im after a real basic paragraph stating what sql server is or can you point me in the right direction Can web sites be loaded onto my SQL server Can other computers access my SQL server Is it purely just for databases Development of SQL Server: http://msdn2.microsoft.com/en-us/sql/default.aspx Product info: http://www.microsoft.com/sql/default.mspx In a nutshell SQL Server is a Relational Database Management System... It is an application that manages databases! ...Show All

• SQL Server Lookup task based on a variable

  This doesn't seem possible but I'll ask anyway... Can I build a lookup task where the lookup query is based on a variable, rather than hardcoding the SQL staement No, there is no support for this. The best you can do is write a query and then use values in your input data as parameters, to help filter the rows. Seems obvious, but often I have got stuck thinking I wanted a parameterised query, so that results are filtered before I do the lookup, which cannot be done. This is probably not as effcient, but the closest we have. ...Show All

• .NET Development How can I automate "Update Web References"?

  Where I work we have several teams that develop web services as well as several teams that develop web applications which consume these services.   I have seen cases where changes within a service would cause web applications to break.   And in all such cases, we were not able to detect such problems at compile time.   As far as I can tell, the only way that exists for these applications to stay in sync with the web services is to manually select "Update Web References" (from the Solution Explorer) on each of the web services within a web application.   According to Patterns & Practices: Team Development with Visual Studio .NET and Visual SourceSafe ( http://msdn.microsoft.com/library/default.asp url=/librar ...Show All

• Visual Basic vb.net string

  Hi i have a project which automatic help the company to generate 4 years data into the excel privot table. my problem is the vb.net string not aford to store the query string completly......the query is really really long. Can microsoft people help me what is the best solution The visual basic "string" data type can hold 2 billion characters...if your SQL String is longer than 2 billion characters I would consider rewriting as a stored procedure and calling it by name ...but really 2 billion characters ... From MSDN: Visual Basic Language Reference String Data Type (Visual Basic) Holds sequences of unsigned 16-bit (2-byte) code points ranging in value fro ...Show All

• Smart Device Development Can'nt execute DeviceApp.exe on HP(JPN) Mobile5.0 PPC

  I created a test Mobile5.0 PPC program by VS2005. It's a simple "Hello" program. On the emulator that runs well. I deployed it to the device and then tryed to run. The HP iPaq2490 device messages in Japanese, "newer CF is needed to run this program." Because HP iPaq2490 is Mobile5.0 PPC. Is there any service Pack for Mobile5.0 VS needs to deploy and install NETCF runtime, that takes a while. That is only done ones, after that VS would deploy your application only. ...Show All

• Visual C# Does not exist in the Current Context?

  This is a noob question. I'm writing a simple program that creates a student object using constructors, then outputs the variables. When I compile, I getthese errors: Error 4 The name 'Jonathan' does not exist in the current context C:\Documents and Settings\student\My Documents\Visual Studio 2005\Projects\Project1\Project1\myInfo.cs 20 48 Program2 Error 5 The name 'Jonathan' does not exist in the current context C:\Documents and Settings\student\My Documents\Visual Studio 2005\Projects\Project1\Project1\myInfo.cs 21 47 Program2 Error 6 The name 'Jonathan' does not exist in the current context C:\Documents and Settings\student\My Documents\Visual Studio 2005\Projects\Project1\Project1\myInfo.cs 22 ...Show All

• Visual Studio 2008 (Pre-release) Positioning a UserControl

  I'm trying to position my UserControl on my form. To do so I have a method which picks a position for it. I've verified that my method is in fact returning unique positions, but all my user controls are rendered in the exact center of the window. The relevant code looks like this: MyControl ss = new MyControl (); System.Drawing. Rectangle ssRect = new System.Drawing. Rectangle (10,10,10,10 ); System.Drawing. Point newLoc = PositionPost(ssRect); this .Grid.Children.Add(ss); Canvas .SetLeft(ss, newLoc.X); Canvas .SetTop(ss, newLoc.Y); "this" is my main window which has this hierarchy DocumentRoot --> Canvas --> Grid. I initially did not have a canvas on there at all, but could d ...Show All

• SQL Server I need identity on updatable partitioned view

  Ok, already read that is not allowed to have identity column in any member table of a updateable partitioned view. But I need an identity column. Is there any other way or ide how to solve this problem I tried and resolved this problem using partition tables... With partition views this was impossible, (not impossible, but just too long and complicated, which in generall means a lot of bugs) ...Show All

• SQL Server Chr(13) not working as intended

  When I use Chr(13) in my textbox expression, it does not produce a carriage return in the text. For example if I use "Test 1" & Chr(13) & "Test2", Test1 and Test2 come in the same line but if I use just Chr(10) in the place of Chr(13), it works as intended. In Crystal reports, Chr(13) does produce a carriage return and the text come in 2 different lines. Thanks, Shyam It is a common issue here and you are right the difference with crystal is apparent. You have to use a line feed to get an actual line return (10) as the carraige return (13) just feeds the symbol for systems to translate as they feel and the HTML report viewer will not action a (13) whereas the crystal v ...Show All

• Visual Studio 2008 (Pre-release) MenuItem Click event. Which menu was clicked?

  I'm using a single MenuItem click event for all of my menu items. In this event I want to use a switch to determine which MenuItem was clicked and then call the appropriate method. How can I identify which MenuItem was clicked I add a value to the Name property of the MenuItems, but the MenuItem variable is null below. private void MenuItem_On_Click ( object sender , RoutedEventArgs e ) { MenuItem mnu = ( MenuItem ) sender ; switch ( mnu . Name ) { case "mnuAddSeg" : AddLineSegment ( thm ); break ; case "mnuRemoveSeg" : RemoveLineSegment ( thm ); break ; } } ...Show All

• SQL Server How to To transfer SQL server Express to web hosting Provider

  Hello, FYI, I'm using Visual Studion 2005 with SQL server Ex Edition in my developer PC. So the problem now is how i can migrate the database into my web hostin provider . The provider also use the same version of SQl server. What i noticed the express editon dont have function to import or export. Anybody iin here know how to solve Right now, i'm create the databse using my controll panel in my web hosting then i create tables using management studio express, this way i must do twice works, 1st in my developer PC then into my web hosting..please anybody give a hand please I already copy web site include the app_data into my web hosting, but unfortunately i dont know the connections strings when i ask the provider they told m ...Show All

• Visual C# AppDomain Evidence declaration question

  I'm using a text which sets the AppDomain evidence (as variable e) with the following code: 1. Zone safeZone = new Zone ( SecurityZone .Internet); 2. object [] hostEvidence = { new Zone ( SecurityZone .Internet) }; 3. Evidence e = new Evidence (hostEvidence, null ); 4. AppDomain d = AppDomain .CreateDomain( "New Domain" , e); 5. d.ExecuteAssemblyByName( "ShowBootIni" ); My Question is, what is the purpose of the first line: Zone safeZone = new Zone ( SecurityZone .Internet);, I don't seem to be using the variable 'safeZone' anywhere else in the code, but it functions as described. Is this line even essential or does the 2nd line defining the object hostEvidence provide everything ...Show All

• .NET Development Decrypt DES-encrypted .gz file

  Hi, I need to decrypt a DES-encrypted .gz file. I tried the following code (most from http://support.microsoft.com/kb/301070/de ): Are you doing encryption and decryption using "MyKey". Listen, Every Encryption and Decryption algorithm has its valid key sizes depending on the Algorithm like 256 bit key means 32 bytes. So your code seems fine to me except you are using an invalid key. Better Try to get a key like this: DESCryptoServiceProvider DES = n ew DESCryptoServiceProvider(); string key = Convert.ToBase64String(DES.Key); use key // for Encryption and Decryption becuase its now valid in size Second point to get bytes from key string, dont use ASCII encoding or some other try convertying it with Con ...Show All

• SQL Server Pattern Matching - Searching for Numeric or Alpha or Alpha-Numeric characters in a string

  Hi, I was trying to find numeric characters in a field of nvarchar. I looked this up in HELP. Wildcard Meaning % Any string of zero or more characters. _ Any single character. [ ] Any single character within the specified range (for example, [a-f]) or set (for example, [abcdef]). Any single character not within the specified range (for example, [^a - f]) or set (for example, [^abcdef]). Nowhere in the examples below it in Help was it explicitly detailed that a user could do this. In MS Access the # can be substituted for any numeric character such that I could do a WHERE clause: WHERE Gift_Date NOT LIKE "####*" After looking at ...Show All

• Windows Live Developer Forums bulk geocoding canadian addresses

  im looking for tool to bulk geocode canadian addresses. will have to geocode over 200, 000 addresses at first then 10-20% on daily basis. steph I'm in a similar situation for Australia but for reverse geocoding. I looked into various web services etc but for thousands of lookup per day you can't use free services and the paid services were not cost effective, not to mention the performance was terrible and the bandwidth used wasn't great. We bought the dataset and will be creating the logic ourselves for performance. For Australia its not cheap but maybe Canada is cheaper, I know the US is free for the tiger data. John. ...Show All