stsong's Q&A profile

• Visual Basic Data Connection Wizard

  Hey guys, when you do the data connection wizard and you create a new connection for a database, where do those data connections reside   If I wanted to delete that connection, where would I go to find it Oh and in the connection string, so that my password for my SQL Server database doesn't show, I chose to not include the password.  Where do I go to add the password later so that the database is accessible Hi I hope you are using VS 2005. 1. Open View >> server explorer >> 2. If already you have connection. then it will be available ini Data Connection Node. If not you can create new connection here. ...Show All

• SQL Server Variables in CONTAINSTABLE. IS IT POSSIBLE? NO ERRORS AND NO RESULTS.

  I know the use of variables is allowed with CONTAINS but I can't seem to get return results with CONTAINSTABLE My test Code: DECLARE @textstring varchar(4000) DECLARE @firstword varchar(80) DECLARE @secondword varchar(80) SELECT @textstring = ltrim(rtrim('SAP America Inc') select @firstword = dbo.GETWORDNUM(@textstring, 1, ' ,.:') --Returns the first word with no spaces, commas or colons select @secondword = dbo.GETWORDNUM(@textstring, 2, ' ,.:') --Second word select @thirdword = dbo.GETWORDNUM(@textstring, 3 , ' ,.:') --Thirdword SELECT c.companyIntID, c.CompanyName, KEY_TBL.RANK FROM Companies as c INN ...Show All

• Visual Basic Selected Date becomes the starting date for the control?

  I have two month calendars. Monthcalendar1 and monthcalendar2 I have set monthcalender 1 to be the computers clock date monthcalendar2 date can be chosen bu the user How do i get the difference in the number of days btw those to calenders MonthCalendar1.SetDate(#11/11/2005#) works....its looking for a *Date* data type. To cast a string use the # symbols or you can cast your own date variable and then pass.... selectionstart may work but it is used for selecting multiple dates... sorry about the value thing that was off the top of the head... ...Show All

• Windows Forms Http Download & Resume

  Can anyone supply me with some basic code on how to download a file via http & have the chance to resume it in VB.NET 2003  If possible, using a progress bar too. This is getting frustrating for me now, as I can get a file to download, but not resume. Please help!! ...Show All

• Architecture Does XmlChoiceIdentifierAttribute break the 3rd tenet of SOA ?

  The 3rd tenet of SOA, according to MS, states that "Services Share Schema and Contract". When I use the XmlChoiceIdentifierAttribute in my shema, I actually say "when you call me, you will get in response one of the following possible types and you should check yourself the returned value to decide what you got from me". In the SO point of view, does this decleration of "possible" types makes my contract less structured or does the fact that I declare the possible values in my contract (via the WSDL file) means that is it well-formed (and the fact that the client needs to evaluate the response is meaningle ...Show All

• SQL Server SP_WHO2 on SQL 2005

  The behavior seems to have changed on SP_WHO2 in SQL 2005. In SQL 2000 I could be logged in as a regular user in my system and run SP_WHO2 and get all the users currently logged in. This is no longer working in SQL 2005. It now only returns "me". What kind of rights do you need to have to see who is logged in It looks like sp_who2 is not documented yet in Books Online. I'll open a bug to address this. I expect that sp_who2 has similar permission requirements with sp_who. http://msdn2.microsoft.com/en-US/library/ms174313.aspx The user must have VIEW SERVER STATE permissi ...Show All

• .NET Development HTTPHandler and CustomErrors

  Hi, We've a HttpHandler that parses requests to .html files on our site. The URL will contain an ID that we'll use to draw data from the database. We also have a custom 404 page setup in the web config (this works fine for .aspx pages). For the files parsed by the HttpHandler if the ID refers to an object that isn't 'live' we want to show the custom 404 page. I've tried this in the same way we do for other pages when we're programmatically calling a 404, I use the HttpContext.Current.Response object, I call .Clear() and set it's statuscode to 404, then call end() (I've also tried calling .Flush() instead of end() and doing both, flush( ...Show All

• .NET Development genrate pdf file using xml file

  Hello, Its really helpful for genrating rtf file but i am getting still problem with pdf file. I have complied file at my disk inspectorODetailFO.xsl and InspectorODetail.xml . Dim xslsh As New MSXML2.DOMDocument40 Dim output As New MSXML2.DOMDocument40 Dim xslt As New MSXML2.XSLTemplate40 Dim xslDoc As New MSXML2.FreeThreadedDOMDocument40 Dim OBJxmlDoc As New MSXML2.DOMDocument40 Dim path As String Dim str As String Path = Environment.CurrentDirectory OBJxmlDoc.async = False OBJxmlDoc.validateOnParse = True OBJxmlDoc.resolveExternals = False OBJxmlDoc. ...Show All

• Visual C# Exception Handling Techniques for ASP.NET Application with Multiple Layers

  We have an ASP.NET 2.0 (C#) application that is divided into multiple layers. The multiple layers come from having a web project and 2 different class library projects in the same solution. I'm having difficulties figuring out the best way to handle (catch) exceptions in the different layers and then propagating those errors back up through the call stack to ultimately display something to the end-user. Note this is an intranet application to be used in-house by company employees; it will not be a public Internet application. See the code snippets below for an example of how we're handling things now. ASP.NET Application Web.con ...Show All

• Visual Studio 2008 (Pre-release) MediaElement.Volume = 0 not working ?!?

  Hey! I’ve created a customcontrol where i set a MediaElement as a texture to a Viewport3D-object. What I would like to do is to set the it’s volume to 0 but it doesn’t work properly when i use... myMediaElement.Volume = 0 ...when initializing my object. Anyone that have had the same problem and worked arount it somehow I create everything frome codebehind using a MediaTimeLine, MediaClock, MediaElement if that help you guys to give me an answer cheers /erik I'm using a MediaElement in one of my project and I've got no problem.... Are you using myMediaElement.Volume = 0 in the MediaOpened ...Show All

• Visual Basic Stream Video from network PC via webcam?

  hey all, I've just recently kicked back into .NET...and I have a little project I'm workin on that I need some help with: I have a little Logitech USB Webcam that I have attached to a laptop and I want to be able to view a video stream from it. I already gathered it will need to be a client/server model...and I probably need to use TCP/IP and/or Winsock (if its still even used)... ..but I have no idea how to really approach this application as far as the video capture process I don't have a need to really record video in any way so if i can just "preview" the video thats fine, although recording would be a neat bon ...Show All

• Visual Basic vb - How to set the page length for rolling sheets? (Urgent)

  Hi guys, I wish to know how to set the page length for rolling sheets (Continously rolling paper). I am developing a software for a restuarent. They will print the billing in the rolling sheets. That is the length of the page is decided after the items are ordered by the customers. So, How could we dynamically set the page length at runtime while running DATA REPORT or CRYSTAL REPORTS. This means, how to stop the page ejection after taking the report. Because, we don't know the exact length of the bill. The A4 / letter/ legal will not suitable for little no. of items. This is urgent. Yours, Senthil ...Show All

• Visual Basic Datagrid with Combobox column - Null values

  Hi all, I've done some programming before but am new to VB 2005 and to databases. Up until now I've managed to solve all my problems by gleaning information from MSDN and other web sources but this one has get me stumped! I have a DataGrid bound to 'WireList' table in a database. One of the columns in the DataGrid is set as a ComboBox bound to 'Terminal' table in the database. The idea being that the user can select an item from the ComboBox by the DisplayMember while the ValueMember is stored in 'WireList'. This works fine when adding a new record to the DataGrid. However, if I just edit an existing record then I get an error when ...Show All

• Software Development for Windows Vista The Rating and Keyword function.

  when i try this function and "Add a title" in the bottom of the window, i receive an error message an unexpected error is preventing the operation. make a note of this errore code, which might be useful if you get affitional help to resolve this problem: error 0x88982F04: no error description available someone have the same problem sorry for my english. Adding ratings and keywords to pictures in Explorer doesn't work right now. That's a known bug in the beta. In the future, you can report beta bugs by clicking the "How to report a bug" link on the desktop. These forums are for developer issues, not bug reporting. ...Show All

• Visual Studio Team System All my unit tests pass, no matter what!

  For some reason, all my unit tests pass on one machine. I've created projects at home, including tests. But no matter what I do, all tests just pass. I rebooted, I created new projects, I did Assert.Equals(0, 1) but they just keep passing. I'm running WinXP SP2, VS2005 Beta 2 Team Suite, C# Normal thing I do is create class library, create test project, set a reference to my class library. Either give them the same namespace or specifiy a using. Then I add a new Test, it's name "UnitTest1.cs" when I change nothing. I can use MyClass myClass = new MyClass(); and everything. I can debug, everything. But no matter WHAT I assert, everything pass ...Show All