SuNcO's Q&A profile
SQL Server What is up with Defaults in 2005????
To keep inline with BOL, I have gone away from the CREATE DEFAULT and sp_binddefault when using defaults, and have gone to using what BOL suggests and specifying the default on the column definition when adding a column. However, I cannot find anywhere how to REMOVE a default when applied in this manner. I need to delete a column via T-SQL and according to BOL it says a column cannot be deleted when it is associated with a default that is defined with the DEFAULT keyword (such as in my case), as follows: CREATE TABLE [dbo].[Test] ( [icheckno] [int] NOT NULL DEFAULT 0, ) ON [PRIMARY] GO OK, fine, so how do I remove the DEFAULT to dro ...Show All
Visual Studio 2008 (Pre-release) What support does DLinq have for SQLXML, and can I do XLinq queries with it?
Hi there, Just interested to know how I can translate a "XML" column into DLinq. Does it support it only as a string primitive as of yet Better yet, any chance of it being supported as a XDocument I can most likely do this with custom read and writes, but doing something like this is what I would consider most correct: [Table] class Users { [Column(DbType="uniqueidentifier", Id=true)] public Guid UserID; [Column(DbType="xml")] public XDocument UserDetails; } Does this work now and I just am not doing it right Does anyone have any i ...Show All
Visual Basic get ip address using vb.net in aspx page
I tried the asp.net forum, the link is broken. I need a little help collecting the host ip using vb in an aspx page. I tried adding Imports System.Net at the top of the page. The error returned was DNS not declared. Here is what I had; <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title></title> <meta name="GENERATOR" content="Microsoft Visual Studio .Net 7.1"> <meta name="vs_targetSchema" contenet="http://schemas.microsoft.com/intellisence/ie5"> </head> <body> <% Dim MyHostName as String = DNS.GetHostName() Dim MyHostEntry as IPHostEntr ...Show All
Windows Forms Creating XML documents in C#
Hello, I want to know if it is possible to automatically create a .xml file using an existing schema. If so, how is this done. thankyou. fss It's early, and I'm still missing some brain cycles here, but you can load some XML files directly into a DataSet object using the schema you supply, and can edit the data within that DataSet, and&nb ...Show All
Visual Studio Express Editions How can I play a wav sound with Visual Basic 2005 Express Edition
I am a very begginner in this software and I am having problems to play sounds with Visual Basic. I have copied the code suggested by the Help (my wav file is called 1) but even though there seems to be no errors, there is no sound. Sub PlayBackgroundSoundFile() My.Computer.Audio.Play("C:\Windows\1.wav", _ Audio.PlayMode.Background) End Sub Thank-you very much. I am a very begginner in programming with VB and I cannot play a .wav sound. I have tried with related questions and in the program's Help but even though there seems to be no error in the code, I cannot listen anything. Thank-you v ...Show All
Visual Studio Express Editions Problem with installing Visual Basic Express Dist.
Hello Geeks, I downlaoded an ISO image of Visual Basic Express and tried installing it on my PC. The Windows Istaller and Dot Net Framework succeeded, but Visual Basic failed to install. I tried to install from a CD and from the harddrive, and I tried on three different machines, all running XP Pro with SP2, but always failed. Error Signature: EventType : visualstudio8setup P1 : 10859 P2 : 8.0.50727.42_rtm_x86_ixp P3 : msi P4 : inst P5 : f P6 : - P7 : - P8 : 1603 P9 : - P10 : - VSSWMSI Summary: ======================= MSI HEADER INFORMATION: ======================= === Verbose logging started: 18/06 ...Show All
Visual J# Application does not exit, remains in memory
I have a quite sizeable application written primarily in J# (with some C#). Under the .NET framework 2.0, when the close button on the main window is clicked, the exe remains in memory after the application exits. In the previous version of the .NET framework this did not happen. There is one slight difference in the code under 2.0. In the form_Closed() event, it is now illegal to put a System.exit() call which worked perfectly well in the previous version. I have set a breakpoint in the debugger in the Dispose() method to see if there are any active threads, and find only a few system threads with <no name>. How can i get this exe to ...Show All
Windows Forms Visual Studio.net cannot find "System.Drawing"
It says that VS.net 2003 can't find system.drawing; what could be the problem I am having this same problem in VB and I tried your remedy, but it doesn't work. Is there something else I need to do Thanks ...Show All
Visual C# FAXCOMLib
Has anyone had any luck to get faxing working with C# Here is the code I have using System; using FAXCOMLib; namespace ConsoleApplication3 { /// <summary> /// Summary description for Class1. /// </summary> class Class1 { public Class1() { } public void FaxDocument(String TheFile, string faxnumber) { FAXCOMLib.FaxServer server = new FaxServerClass(); FAXCOMLib.FaxDoc doc = null; int response = -11; try { server.Connect(Environment.MachineName); } catch(Exception e) ...Show All
Visual C++ Parallel port interfacing using Visual C++
hi Can anyone help me that how can i interfaced parallel port by using VC++.what are the commands or functions are used 4 this purpose.Please send me any information about this.I have to interfaced DC motor control via parallel port using VC++ I will be very thankful to you. shorash_leo@hotmail.com http://www.naughter.com/parallelport.html ...Show All
Smart Device Development uninstall device emulator version 1.0 beta 2
I am uninstalling vs2005 beta 2, and there seems to be an order that I should've uninstalled in but I didn't find out until afterwards. Now this device emulator software is stuck, installed on my computer and I can't get it off because it's asking for an msi file on a dvd that I don't have http://blogs.msdn.com/vsdteam/archive/2005/10/05/477539.aspx has the instructions about removing DMA patch. ...Show All
Software Development for Windows Vista NVidia GeForce FX Go5200 LDDM Driver doesn't work on 5270
I have been driving myself crazy with this for weeks. I have a Toshiba Satellite with an NVidia GeForce FX Go5200. The non-LDDM driver works fine but that's no real fun or use. There IS an NVidia GeForce FX Go5200 LDDM driver that worked in all previous builds. Now it doesn't. If I install that driver, I get a blank screen just after the Longhorn logo on boot right as its trying to display the login screen. Does anyone know what is happening Has anyone gotten this card to work with LDDM/Glass Why did it regress ...Show All
Windows Forms DGVComboBoxColumn gives ThreadStateException
I'm having a problem when selecting cells in a DataGridViewComboBoxColumn. Each time a cell is selected I see the following error: "DataGridView Default Error Dialog: System.Threading.ThreadStateException: Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that you Main function has STAThreadAttribute marked on it. ..." Firstly, I don't use any Main() methods in my application. I did try adding one with the suggested attribute, but it had no affect. Does anyone know what this means Thanks, Nate Another note: After clicking OK for th ...Show All
Software Development for Windows Vista Release date of next working WinFX SDK CTP?
Since the current Jan CTP was not installable on my machine due to known errors ( see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=220146&SiteID=1 ) I still have no access to beta2 of WF. So can you please tell me when the next (hopefully installable) version of WinFX SDK will be available for unrestricted public download Thank you. You can have access to WF Beta 2 without installing the WinFX January CTP. Just install from here . It is available for unrestricted public download. Cheers, Paul ...Show All
SQL Server Deploying Report Model Error
I receive the following error when I attempt to deploy a report model to the Report Server. This is the on the SQL 2005 June CTP. Does my config file for the Report Server need to be modified Any help would be appreciated. Thanks -JW Client found response content type of 'text/html', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title>Server Unavailable </title> </head> <body> <h1><font face=Verdana color=#ff3300>Server Application Unavailable </font> ...Show All