Gess Man's Q&A profile

• Visual Basic Export Data to Excel sheet from SQL Server. (Urgent)

  Hi All. I am using VB.Net 2003 to write a Web application for exporting data from MS SQL Server to Excel sheet. When I click the button to export the data, I got the following error message. Microsoft Excel cannot access the file 'C:\inetpub\wwwroot\AndrewDatabaseFinal'. There are several possible reasons: ? The file name or path name does not exist. ? The file you're trying to open is being used by another program. Close the document in the other program, and try again. ? The name of the workbook you're trying to save is the same as the name of another document that is read-only. Try saving the workbook with a different name I have no idea how to solve the problem since I am a beginner of VB.Net. I have attached my source code as th ...Show All

• Visual Studio 2008 (Pre-release) XamlWriter, MarkupObject How to ?

  I'm trying to serialize a tree of object in xaml in some designer app. some node of this tree refers to the same reference that i added to a resource dictionnary. XamlWriter won't serialize the reference to the dictionnary resources as a StaticResource + ResourceKey but i understand reading this post : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=286265&SiteID=1 that this should be possible using MarkupObject and modifying the ouput for some node. let say : Transform3DGroup TG1 = new Transform3DGroup (); Transform3DGroup TG2 = new Transform3DGroup (); TranslateTransform3D ts2 = new TranslateTransform3D (); TG1.Children.Add( new TranslateTransform3D ()); ...Show All

• Visual Basic USB DRIVE Detection

  I have an ALL in 1 Card Reader - for mobile multimedia card such as MMC - that I want to monitor from my program it connects to the computer through a USB port and the computer assignes a four drive letters to it you can think of it as multiple USB Stick Drives 1 - how I can obtain the drive letters associated to it when it connects to the usb port 2 - how I can monitor the insert/remove of any card I think there is a soultion arround Win32_VolumeChangeEvent but I've failed to find it and I've tried a piece of code based on Win32_DiskDrive and it didn't give me the desired result can any one help me please thank you mr. KevinBB I read that code before I post here It work ok if the card is ...Show All

• Visual Studio Team System Revisiting - Deleting a project from GUI

  I have removed (deleted) a project from the TFS database. However the project folder (although empty) still appears in the Folders section. Is there a way to remove this project folder Thanks, Kerry I am revisiting this issue of removing a project from the Source Code Explorer. I understand this to be a "bug" that has no current plans to fix. Our problem here is that we have old project and branches from the days of . . . (well, they're certainly very old and unuseful). There are so many of them the Explorer window is cluttered with these unnecessary entries. Having said that, is there anyway to manually remove the deleted projects from the Source Control Explorer It would seem this in ...Show All

• Visual Studio 2008 (Pre-release) problem executing SVCutil

  I am not able to generate proxy of the wcf service from client machine svcutil.exe http://192.168.1.1/JumpStartService/UnitInfoService.svc wsdl when i try to execute this command prompt of VS , I am getting the following error Error: Cannot obtain Metadata from http://192.168.1.2/Jumpstartservice/unitinfoservice.svc If this is a Windows (R) Communication Foundation service to which you have access, please check that you have enabled metadata publishing at the specified address. For help enabling metadata publishing, please refer to the MSDN documentation at http://go.microsoft.com/fwlink/ LinkId=65455. WS-Metadata Exchange Error URI: http://192.168.1.2/Jumpstartservice/unitinfoservice.svc Metadata contains a reference that cannot ...Show All

• .NET Development Using multiple SMTP server with SmtpClient

  I want to send email with the SmtpClient, but I have two possible SMTP servers. Can I check the availibility of both of the servers, before i choose one of the servers to send the mail Pseudo-code: If server1 is alive then dim mailserver as smtpclient = new smtpclient("server1") elseif server2 is alive then dim mailserver as smtpclient = new smtpclient("server2") else throw new exception("too bad") end if Can anyone help Eric ...Show All

• Visual Basic Upgrade (Event Order Changes)

  Hi, I have upgraded VB6 to Vb.net 2005. In VB6 I have a ComboBox for Country List, and Event called "cboCountry_GotFocus". Code: Private Sub cboCountry_GotFocus() If txtAddress.text = "" then MsgBox "Enter Address First", , App.Title txtAddress.SetFocus End if End Sub Above event fires, once combo box got focus. After conversion, in VB.net its converted as "cboCountry_Enter". Problem is once form is loaded The code under "cboCountry_Enter" is executing directly. Which I don't want.. Code: Private Sub cboCountry_Enter(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles cboCountry.Enter If txtAddress.text = "" then MsgBox &q ...Show All

• Visual Studio 2008 (Pre-release) WCF and ADO .NET Entity Framework

  Hi, How I do a class serializable (class Customer) in WCF when this class is automatic generated by a ADO .NET Entity Framework In ADO .NET Entity Framework I define a data model and then I have a classes of my data model by means of a mapping. This class don’t have a datacontract and datamenber attributes. It’s posible make this classes serializable without make a new class thank you If you don't want to add DataContract and DataMember attributes. Adding a [Serializable] attribute will make it an implicit datacontract. I haven't worked with ADO.NET Entity Framework yet so not sure about the classes generated they might already be serializable. ...Show All

• Visual C++ Tooltips disappeared after switch from VC 6 to VC 8 due to breaking change in CWnd::OnToolHitTest()

  Hello everybody, after switching from Visual C++ 6.0 (VC 6) to Visual C++ 2005 (VC 8), many tooltips in my dialogues would not show up anymore.  It took me quite a  while to pin down the reason for this behaviour: The tooltips don't show up anymore for all child window controls which lie inside the window rect of another control like a group box or a tab control(*) preceding it in the tab order. The enclosing control has child window id IDC_STATIC, which in VC 6 meant that it was ignored by CWnd::OnToolHitTest()  (more precisely by _AfxChildWindowFromPoint(), which is used by OnToolHitTest(), see below). Now in VC 8 the constant for the controls-to-be-ignored chang ...Show All

• SQL Server Report Parameters creation via Code

  Hi, I have a report that that needs to be filtered by StartDate, where StartDate is the first day in the week of a specific year. The values will be each week of the year (52 weeks = 52 Start Dates) and the range of years is between 2006 (current year) back to 2003. My questions is how to generate these values for the StartDate parameter. I don't want to define actual database tables to store these values, as it seems like something I should be able to easily generate via some code. After trying it out for while and searching the forum, I'm starting to think I will need to statically store these parameters. Can anyone offer any advice on how to solve this parameter value generation issue Thanks, - Jim ...Show All

• .NET Development How To Handle HTTP Header

  Hi Experts, How to add a http header which says: HTTP/1.1 200 OK and send it back as response Regards, Suman Assuming that we are talking about a ASP.NET web application the The HTTP status code 200 is set by default unless somewhere in the HTTP request pipeline the StatusCode is changed. If you need to change the status code you should do this by setting the StatusCode property of the Response object. Then you can stop the execution of the page with a call to Response.End(). ...Show All

• Visual Basic REALLY Weird "Threading Problem" - Hard to explain

  Hello all. I''m currently in the [process of making an audio player application that will read out MP3 tag information using the Speech library (the MS Text-To-Speech thing - like the one in control panel.) Well, I had built the application using the VB .NET 2005  Betas, and it worked fine throughout - no problems. I downloaded the final version of both the framework and VB IDE itself. I compiled & ran, and got some strange error that I had never gotten before. Below is the result of what the IDE could tell me. ContextSwitchDeadlock was detected Message: The CLR has been unable to transition from COM context 0x1af778 to COM context 0x1af8e8 for 60 seconds. The thread that owns the destination context/apartment is most likel ...Show All

• SQL Server Create a calculated member on one measure.

  I have a Version dimension which is used to break out the Net measure by 'Actual' or 'Budget'. Net is the only measure I'm using. By not using the Version dimsion. The net is incorrectly totaled by both values. Both are not used together. 'Actual' and 'Budget' are the only two members of the Version dimension. I want to add a third member which subtracts 'Budget' Net measure from the 'Actual' Net measure and call it variance. A caculated measure isn't working for me because obviously subtracting Actual - Budget doesn't work so well. Can anyone help me with that OK I got it to the point where there are no errors, but the Variance member will still not show up in the Version dimension. WHat could be the cause /* The CALCUL ...Show All

• Visual C# free memory

  hi my operatin system is windows server 2003. I have program that use big text files , when i run that my computer Page File Usage is being the highest . If i close my application , Page File Usage won't decrese how can i free memory The best thing to do is to do in C++ way / asp way: object = null; that's the only way u free resources in .NET without exit ur application. See the link i provided somewhere in this page. ...Show All

• SQL Server How to guarantee unique of columns > 900 bytes

  We have an app that threads together emails coming out of Exchange, using their messageid. To ensure threading works correctly, we need to ensure uniqueness of messageid, which we do with a unique index (we also need to be able to lookup by messageid when a message comes in). We are currently porting the app from Oracle and PostgreSQL to SQL Server and are having problems with the 900 byte max length of an index. The problem is that the maximum size of a messageid (according to the Exchange docs) is 1877 bytes. How can we guarantee uniqueness Yes, hashbytes should be marked as deterministic. It was a bug. We found it after RTM and fixed it in SP1. So if you try it on SP1 like below it will work ...Show All