Coc Patrick's Q&A profile

• Visual Basic Import data from excel

  Hello, Using VB Express 2005 It has been some time since I have played around with excel and vb... I would like to import a cell of data from excel for a motor program. I can't remember the exact syntax on how to do it...and searching for help has been convoluted. I know how to open an excel file through VB. Any help would be greatly appreciated. Thanks!! hi ah3, in importing/opening excel, your need a the connection string: 'using oledb Imports System.Data.OleDb 'defining the connection string Private xclConn As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\myexcel.xls; Extended Properties=""Excel 8.0;HDR=YES""" you also need the sql for ...Show All

• Software Development for Windows Vista QueryInformationJobObject JOBOBJECT_BASIC_AND_IO_ACCOUNTING_INFORMATION

  Hello, my question is about calling QueryInformationJobObject to get JOBOBJECT_BASIC_AND_IO_ACCOUNTING_INFORMATION (JobObjectInfoClass=8) from 32 bit application under 64 bit Windows (XP and server 2003). Function was tested with JobObjectInfoClass=1 and works normally, but with JobObjectInfoClass=8 function always return GetLastError=1 (invalid function). We have tested different parameter length for the pJobObjectInfo parameter and we never get GetLastError=24 as expected and is the case with JobObjectInfoClass=1,2,4,6,9. With JobObjectInfoClass=3 GetLastError=0 ( ) and with JobObjectInfoClass=5 GetLastError=8 in case of wrong cbJobObjectInfoLength. So only for JobObjectInfoClass=8 we get strange result and the function fa ...Show All

• .NET Development Consume Remote web service problem

  Hi all, I m new to web service. I m using VS 2005, asp.net 2.0 ,C#. I wanna consume a remote web service but got : "Unable to connect to the remote server" error. my code snippit is as follows: WebProxy proxyObject = new WebProxy("http://bluetongue.cs.rmit.edu.au:8080/", true); proxyObject.Credentials = new NetworkCredential("XX", "XX", "XX"); WebRequest req = WebRequest.Create("http://www.webservicex.net/globalweather.asmx"); net.webservicex.www.GlobalWeather gw = new net.webservicex.www.GlobalWeather(); gw.GetCitiesByCountry("Australia");//This line got :"Unable to connect to the remote server" ...Show All

• SQL Server Restored Database/Diagrams Support/SQL-Server 2005

  Hello, I have restored a database from SQL-server 2000 into SQL-server 2005 and when I try to install diagram support, I receive this error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. ------------------------------ Section 5.8.1 of the SQL 2005 Readme file says: The installation of these support objects can fail on a database that has been attached or restored from another instance of SQL Server. This ...Show All

• Windows Live Developer Forums Recording the start and end location of a route.

  I am trying to record the start and end location of a route. I see that the GetRoute method is supposed to return a VERoute object, and I know that i have to get this information from this object. The question I have is how to actually store the VERoute object that is returned. From the documentation I tried two options, but neither of them work: Option 1: var myRoute = map.GetRoute("Space Needle", "Microsoft", null, null, null; var start = myRoute.StartLocation.LatLong; var end = myRoute.EndLocation.LatLong; Option 2: ... map.GetRoute("Space Needle", "Microsoft", null, null, "onRouteReturned"); ... //later on in the code function onRouteReturned( myRoute ) { var start = myRoute.StartLoca ...Show All

• Audio and Video Development XMLParser Object

  hi Can we display an xmu file parsed using the parse() method of XMLParser Object. Thanks Correct, the answer to that specific scenario is no. But if you saved the file first and then linked to it, it should work. parse and parseString have many uses, for example loading (and then saving) config info stored in persistent storage such as user preferences, bookmarks, game scores, etc. and of course interacting with RSS feeds and web services over the network (which are all described as XML). You could also load a DOM and then clone some of the nodes over to the markup DOM and then reload it, yes, but I don't know if that's actually a scenario we have thought about :-). ...Show All

• Visual Studio Express Editions OpenGL unresolved tokens

  Hello, I'm trying to compile an old openGL project in Visual C++ Express edition, but I get a zillion unresolved token errors for opengl functions. I won't list them all because they all seem to be related, but here are a couple: error LNK2028: unresolved token (0A0000BA) "extern "C" void __cdecl glLoadIdentity(void)" error LNK2019: unresolved external symbol "extern "C" void __cdecl glViewport(int,int,int,int)" I have installed Platform SDK, following the instructions at http://msdn.microsoft.com/vstudio/express/visualc/usingpsdk/ I have installed opengl, following the instructions at http://www.css.taylor.edu/~btoll/resources/graphics/opengl/xp/visualc.html I have glu32.lib,glut32.lib,opengl32.l ...Show All

• Smart Device Development error code

  I sync my smart phone with my pc and a error came up that said activesync encountered a problem on the desk top support code 86000108 how can I fix the problem. the best place to ask would be here: http://www.microsoft.com/windowsmobile/communities/newsgroups.mspx since these forum are for software development only ...Show All

• Visual Basic Add input from textbox?

  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim TextBox1 As String = "TextBox1.Text" Dim TextBox2 As String = "TextBox2.Text" If Button1.CanSelect Then TextBox3.Text = TextBox3.Text & TextBox1 & vbCrLf TextBox3.Text = TextBox3.Text & TextBox2 & vbCrLf End If End Sub What is supposed to go into the RED parts to take the info(text) from the text boxs and add it to the TextBox3 Wow Thanks A LOT man it worked. I love this forum its about the only one that i get HELPFUL respones, Not ones with there own codes that either take forever to make it work with my own app or arent what I need. Thanks Guys for helping ...Show All

• Software Development for Windows Vista Filtering activities before insertion; ActivityValidator question

  Hi! I have 2 questions actually: I am hosting the designer in my app with a custom root activity as the root designer. This root activity can have child activities where exactly 1 child can be of the type StartActivity (also a custom activity) and several childs can be EndActivity. I overrid InsertActivities of the designer to check wheter there is already a StartActivity. If there is, I give a list of activities to the base.InsertActivities where I filtered out the new StartActivity which is about to be inserted. This works well for Drag&Drop operations from the Toolbox, I get my message as expected and the 2nd StartActivity is not inserted. However if I copy (using Copy&Paste) a 2nd StartActivity, my message pops u ...Show All

• Windows Forms UserDeletingRow event is not working in 2005

  Hi there I am trying to write an alert in while deleting the row in a data grid view. It is a new future in visual studio 2005. The event is not getting fired when I delete rows in DataGridWindow. Quick response would be greatly Appriciated Regards, Oswin You make a good point, Grant. Do a search here in the forums for DataGridView survey. One of the MS developers who works with the DGV was asking for input not too long ago. This would be a good one to add to the list that is there. ...Show All

• Visual Studio 2008 (Pre-release) Client and service see different SessionId for a duplex contract?

  Hi, I have a simple WCF app using the NetTcp binding and a duplex contract.  I'm using InstanceContextMode.PerSession and the sessioning works fine.  What I don't understand is why I get different values for "SessionId" on the client and service side when using a duplex contract.  For a non-duplex contract the client and service are seeing identical "SessionId", which is what I would expect.  So why not also for a duplex contract   Thanks, Alan Client code:     String strSessionId =         CMyService_ClientSideProxy.InnerChannel.SessionId;     These return identical strings to strSessionId above:     CMyService_ClientSidePr ...Show All

• Visual C# Connect to Database...

  I have install the Northwind sample database by entering at the DOS prompt osql -E -S (local)\sqlexpress -i instnwnd.sql which runs through lots of numbers so I assume has all gone ok. When in VS I go to "Tools/Connect to Database...", choose "Microsoft SQL Server" and ".NET Framework Data Provider for SQL Server", then in the next dialog there is one server in the combo which I select, but I cannot get any databases to appear in the "Select or enter a database name" combo. maybe you can check the sqlpress first on you PC by below methodes. 1. is there is folder C:\Program Files\Microsoft SQL Server\90\Tools\Binn 2. check the service named SQL Server ...Show All

• .NET Development .NET encourages poor coding?

  The more I look at .NET error handling, and how to deal with it, the more frustrating it gets. Take this class for example.   It has a single boolean property.   You have to know on which side of the call an error will be raised… by the caller or the callee… well here’s a prime example.    Say you have to read data from somewhere like a text file and you cannot ensure the format of the data is proper.   Well, you cannot depend on a property to check that data for you if you strongly type the property. Read the orange comment to see what I mean, and please let me know how you deal with this situation since to me it appears to require horrible program design.     Public Class ...Show All

• Smart Device Development Windows Media Player control and Compact Framework 2.0

  I am developing an app for PocketPC (Mobile 5, WMP10, VS2005, C#, CF2) that has to be able to playback wmv videos. Following Alex Feinman's directions ( MSDN , for example) I've been able to embed WMP10 control in a CF2 form and play videos. Well, till now I have just tested on emulator (device emulator 2.0 beta). My problem is that WMP control not behaves according to the changes I make on its properties. For example, If I change uimode property to none, WMP is supposed to hide playback&volume controls, but nothing happens. Fullscreen mode works but as I have not been able to catch click events, any click exits fullscreen and I didn't figure out yet how to detect that. Does anyone know if WMP10 control on PocketPC supports raising ev ...Show All