Barry Kwok's Q&A profile

• SQL Server Can I retrieve a result set from a sp into a variable within a Execute SQL Task?

  Can I retrieve a result set from a sp into a variable within a Execute SQL Task I have tried this with just about every combination available with no luck. Do you need to add anything to the exec command I am passing it one variable and it now looks like this "exec sp_name '20071201'" Do I need to change it to look like this "exec sp_name '20071201', " or this "exec sp_name '20071201', OUTPUT". I also have a variable set up under result set and included it in executevariablevalue. Just to be clear the SP is not putting anything in a variable but builds a report in a fiels and at the end does a select @report to display what was built in @report. I hope this is clear. Thanks. ...Show All

• Visual Basic Logins

  Can someone point me in a right direction to learn how I can use a login form to login to SQLExpress Server using SQL Authentication I am thinking that I would like to use the login for my app instead of embedding one in my application. Is that wrong to thing like that I am thinking right by using this to gain access to my application and login to the server at the same time Davids Learning what is a good example, and where does she go I got the login to function like it should, thanks again! Is there a way to keep the form from melting away, looks kinda sick just fading out when the login completes.   Ah yea by the way do I have to call that in every form, or once your logged ...Show All

• Visual Studio 2008 (Pre-release) Debugging WCF server on Vista RC1 (x64)

  I'm having trouble debugging a WCF server on Vista. It seems that you are not allowed to bind to an adress without elevated privileges, this I fixed (when running *without* a debugger) using e.g http://mark.michaelis.net/Blog/WindowsCommunicationFoundationWithWindowsVistaAndUAC.aspx that is adding a manifest to exe requesting elevated privileges. The problem is, it seems this does not work under the Visual C# (Express) debugger (even though there is a exename.vshost.exe.manifest) with the correct content. I do not get a dialog asking to OK elevated privileges, it just behaves like the the manifest is not there ! ! How do I fix this The thing is, my account has admin privileges, I just don't have them by default. Is this really the pr ...Show All

• Visual C++ #using "AbsoluteFilePath". . .How do I. . .?

  In my application I have 5 Dynamic Link Libraries I am using. Each of these libraries holds a Windows Form. One of these libraries has a class that holds ALL varaibles that will be used accross my entire application. This is how it works: DCMPMessenger.EXE -> AcsLib.DLL OR LgnLib.DLL -> MainLib.DLL -> ExtLib.DLL Variables come from: VarLib.DLL Now in DCMPMessenger.EXE, I have a Windows Form which is used as my splash screen. In my splash screen I have a reference to both AcsLib.DLL and LgnLib.DLL. Here is how I have it coded: #using "C:\\Documents and Settings\\Dave S. Anderson\\My Documents\\Visual Studio 2005\\Projects\\DCMPMessenger\\debug\\VarLib.dll" #using "C:\\Documents and Settings\\Dave S. Anderson\\My ...Show All

• Visual Basic Create Web-like Forms as Windows App

  I have used VS 2005 to create a family-based web site ... about 100 pages/forms consisting of mostly text with some graphics thrown in for interest. I have no intention of putting this out on a publicly-accessible server but instead had anticipated burning everything onto CD's and then distributing that to family members so that they could view the site on their own machines (XP Pro SP2) using IE. In inquiring on this forum how to do that I am told that that is not feasible and that instead I should have created a windows app and simply deployed that app to the family (via CD). That's fine except for one thing ... I don't know how to create a web-like app as a windows app. For example, as I create the app I want to be able to easily highli ...Show All

• Visual Basic Custom Template

  How do I make a project template in Visual Basic Express robinjam, 1.Create a project 2.Edit the project until it is ready to be exported as a template. 3.As appropriate, edit the code files to indicate where parameter replacement should take place. For more information on parameter replacement, see How to: Substitute Parameters in a Template. 4.On the File menu, click Export Template. The Export Template wizard opens. 5.Click Project Template. 6.If you have more than one project in your current solution, select the project you want to export to a template. 7.Select the type of template that you want to create. 8.Click Next. 9.Select an icon for your template. This icon will appear in the New Project dialog ...Show All

• Smart Device Development VS2005 Pocket PC emulator fails

  When I build a release version (VS2005/C++ Pocket PC) and download it to my MDA phone (WM5) - it works. When I build a debug version the "emulation phone" application is launched and running the app in this gives INVALID HANDLE errors when WSALookupServiceNext is called ( I posted a previous thread with full details). A VS2005 win32 version (same code but a dialog app) works in debug mode. Why can't I debug a phone app without the nuisance of having to build and download a release version First of all you can debug you application on physical device also. When deploying the app through VS, choose device instead of emulator (device should be connected to pc via Active Sync) and you s ...Show All

• Visual C++ Project properties error

  I am using VS 2005 Standard version 8.0.50727.42. I have a solution that contains one VC++ project. My colleague is able to able open the project and edit the properties but in my case I get the following error when I try to edit the properties for WM PPC 5.0 sdk or WM SP 5.0 "The operation could not be completed. Unspecified error." I was using VS 8 Beta2 and now using complete (standard ) version after uninstalling beta and installing complete. I am able to edit the properties when I select the Win32 platfrom Thanks. This seems to be a installation issue. Try doing a modify installation and make sure you select the needed components (for eg x64 compiler, WMSP5.0 etc.) ...Show All

• Visual Studio Express Editions Adding Record to Database Via Windows Form

  I'm hit another problem I've got these textboxes and when I click a button, I want to add the text into a record in database ON A WEBSITE which I do have FTP access If anybody could point me in the right way or get me a lil snippet - That would would great lol sorry ahmedilyas if you answer this one again but I'm hitting lots of problems today New area of programing for me ... Normally use Asp Well its located on a remote server Database is a mdb - Access You hit the nail on the head with your 'understanding' I'll take a look at them links ...Show All

• Visual J# How to close a blocking DatagramSocket?

  Hi; I have a DatagramSocket that is waiting on a receive: DatagramPacket pkt = new DatagramPacket(new byte[100], 100); mySocket.receive(pkt); I need to close the socket when my application is ending (it is in a worker thread). I presently call mySocket.close() and that works but I get: net.windward.xmlreport.b: [formatter] ac.server WARN net.windward.xmlreport.b - direct java.net.SocketException: A blocking operation was interrupted by a call to WSACancelBlockingCall net.windward.xmlreport.b: [parser] ac.server WARN net.windward.xmlreport.b - multi java.net.SocketException: A blocking operation was interrupted by a call to WSACancelBlockingCall The thread 0x9d8 has exited with code 0 (0x0). net.windward.xmlreport.b: [p ...Show All

• Windows Forms Big data updates

  Hi All, I'm designing this student testing system. Some pages contain say 40 items: Each of which correspond to a combobox where a score of 1-5 may be entered. Each Q also has "question text". My initial plan was to just get all these params (the scores) and concatenate them into a string (the numbers only) and call a stored procedure, which would hold all of the other details in order. This way relies on the order of scores, which is fine by me. Example call (As an SQL command from C# Front, C# omitted): p_insertScoresForATest 1, 4, 3, 5, 2, 4, 3, 5, 4, 3, 2, 4, 5, 3, 2, 3 ...... In p_insertScoresForATest it knows to associate the first param with 'writing skills', the second with 'pencil co-ordination', etc. It ...Show All

• Visual Studio Express Editions After November

  After November will i have to pay for both the Express and the PSDK , or only for the express I also wanted to ask what does the .iso include. thanks in advance for your answers I cannot say with regards to the Platform SDK however I can tell you that the original 'free for a year' offer on the Express Editions was extended and the current wave of them are and will remain free. If that will be the case for the next version it is anyone's guess at this point. ...Show All

• Visual Studio 2008 (Pre-release) how to get data from listview

  How could i retrieve the data from ListView through Code Behind Use a foreach-loop foreach (ListViewItem tempItem in listBox) { // Do something } ...Show All

• Visual Basic Table/Excel

  Hi, I have a data array containing numbers (double) i need to be able to display them in a table (like Excel, how do i do this Also at the bottom of the table i would like to have a button that can send the data table to excel, how do i do this Many THansk for any help/ideas you may be able to give me, Best Regards, Andy Thanks for your help, Do you know if there is an exmple vb project around, so i can look an learn (regarding data grids or excel passing ) Again many thanks, andy ...Show All

• SQL Server Installing Data Mining Web Controls

  Hello, I have SQL 2005 and Visual Studio 2005 and I’m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I’m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does’nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ". Then, I don’t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls. Can somebody help me Dunia ...Show All