GiampaoloSanRemo's Q&A profile

• SQL Server DISTINCT Conflicting with my query

  I need p.phonenumber in there but then it messes up my DISTINCT ON m.number because I end up with dup m.numbers if I run just the inner select statement during testing. But then I need the phonenumber in that subquery so that I can do list.phonenumber ahh! UPDATE Master      SET master . homephone = list . phonenumber FROM MASTER m INNER JOIN      ( SELECT DISTINCT p . nu ...Show All

• SQL Server one to one relationship

  How do I create a one to one relationship in a SQL2005 Express database The foreign key needs to be the same as the primary key so it can't just increment to the next number. Don't use identity for the child table but use @@SCOPE_IDENTITY when you have inserted in the parent table to use this as the foreign key value. ...Show All

• SQL Server SQL 2000 Database through Access Linked Tables via ODBC

  I have a SQL server 2000 database that I am attempting to connect to through Access (97, 2003 - both with the same results) using Linked Tables via ODBC. When the link is established, it only brings in the first 52 fields of one table and 30 fields of another (most are varchar(50)). The tables have MANY more fields than this. I receive no error messages when I link the tables. It sounds like I may have reaching a limit with ODBC since CA-DATA ...Show All

• Visual C++ problems after updating sdk

  Hello, I have visual studio 2003 .net. After I updated the sdk my programs wouldn't compile( they worked before). I mention that I have registered psdk directories with visual studio. this is the error I get e:\Documents and Settings\me\My Documents\Visual Studio Projects\2 10 2 10\stdafx.h(34) : fatal error C1034: afxwin.h: no include path set The include directories look like this: C:\vs\SDK\include $(VCInstallDir)include $(VCInstallDir)atlm ...Show All

• Windows Forms ComboBox dropdownwidth in DataGridView Control

  Hi, I have a DataGridView in which one of the columns is a ComboBox control. I am setting the dropdownwidth of this ComboBox to the longest length string. I do this by handling the EditControlShowing event of the DataGridView and then handle the dropdown event of the comboBox and set the dropdownwidth. Everything works the first time(the dropdown expands to the longest item), but after that every subsequent time the dropdown shrinks to the ...Show All

• Windows Forms Controls arrays

  In Dot.net is it impossible create vb6 controls arrays  (txtbox(1)..txtbox(2) ecc.) thanks in advance how abuot this: <a href="http://www.windowsforms.net/default.aspx tabindex=6&tabid=47&ItemID=16&mid=142"> Erik Porters Control Array</a> ...Show All

• Visual Studio Team System GroupsandPermissions - I could have sworn

  I cold have sworn I have used a command line command to upload GroupsandPermissions.xml up to existing Team Projects. For the life of me I cannot find it or recall it or my notes on it. Can anyone help me out. Thanks, Which brings to mind another question. When utilizing the API's for such things as making these sorts of mods ane especially when there are command line tools that do similar things... are there any published un ...Show All

• Windows Forms Unable to view designer in vs2005 c#

  I am trying to get some help with a very strange problem.  When I opened up vs2005 today my form designer would no longer work and caused vs to crash.  This happens on all projects, even newly created ones. I have tried reinstalling vs, but the problem persists.  If anyone has seen this problem or knows how to repair vs I would be very happy to hear from you. Thanks. DC. Disable that the tool ...Show All

• Visual C# CTS Can Be Compromised

  Take a closer look at this code: class Program {     public static void Main()     {         Base b = new Base();         Derived d = new Derived();         Console.WriteLine("base's actual type: {0}", b.GetType());         Console.WriteLine("derived's actual type: {0}", d.GetTy ...Show All

• Visual Basic How to avoid stepping into the Enterprise Library when debugging?

  Hi, <<<< Note: I first posted this in the "VB General" forum, but decided it is more appropriate here. Please help! >>>> I'm sure this is an easy question to answer for someone that has a better understanding about how debugging works in Visual Studio (2005). I've been trying to figure out how to avoid stepping into the DAAB (Enterprise Library Data Access Application Block) when debugging. I have "Just my ...Show All

• Windows Forms Automating login to website with IIS basic authentication

  Hello all, Can someone point me int the direction of writing a script to automate login to a web application that uses basic authentication instead of a normal post login from a form   Basically what I am trying to do is make the authentication ...Show All

• Visual Studio Tools for Office win 2000 ,powerpoint 2000 and VS 2005 interoperability issues

  hi, Firstly it feels great that many of the members here actually have written the KB articles that i have found extremely insightful . Cheers to that ! im using VS 2005 ,and working on a windows applicaiton that opens powerpoint files. I ahve stumbled upon the folowing problems : 1. no pIA 's for office 2000 . what do i do 2. i managed to use ildasm to try to generate my new powerpoint dll's . as follows in VS command prompt of ...Show All

• SQL Server Connectioni leak with MDAC 2.82

  Hi, I have troubles with a threaded application on W2003 server. It seems to leave open connections behind time to time, it sums to hundreds over a day (the application make thousends). It is using the SQL ADO provider, MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2 (3790). Is there a knwon bug like this Is there a way to trace the ADO provider Hi, sorry for the delay, the forum alert seems not ...Show All

• Windows Forms Tab control shortcut key

  How can you set a shortcut access key for each tab of a tab control Using the & sign like you do for labels and command buttons doesnt work,(it just puts the & in the text). Also Im using vs 2005 C#. Thanks, You'll have to draw the tabs yourself. Take a look at the Add Mnemonic support to TabPages example on my site. If you don't want to do it yourself then TabControlEX supports this feature: ...Show All

• Visual Studio Changing Wait Message

  I'm looking for a way to change the wait message that appears when a remote report is running in Async mode.  I tried setting the font properties of the WaitMessageFont (set the size to 0pt) in hopes that I could at least hide the wait message but this seems to have no effect.  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=127573&SiteID=1 ...Show All