Alastair Q's Q&A profile

• SQL Server Oracle 10g r2 - SQL Server 2005 problem

  Hi, I'm running SQL Server 2005 linked server to Oracle 10g r2. The communication between database is ok, but sometimes when i try to select data from some oracle tables the follow error happens: The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14" Description="Cannot fetch a row from OLE DB provider "MSDAORA" for linked server "INTERFACE_HL7"." HRESULT="0x80040e14" Description="The OLE DB provider "MSDAORA" for linked server "INTERFACE_HL7" reported an error. The provider did not give any information about the error." Others tables are ok and in oracle enviorment that tables continue work fine. To solve th ...Show All

• .NET Development Help with data binding

  I am working on building a data access website. The database has 12 tables (2001exp, 2001imp, 2002exp, 2002imp, 2003exp, 2003imp, 2004exp, 2004imp, 2005exp, 2005imp, 2006exp, 2006imp). All the tables have same no. of columns and names. (Commodity, Country, Month, Quantity, Value) The webpage has 4 dropdown menus (as shown in the image ) Type [Imp, Exp] Year [2001, 2002, 2003, 2004, 2005, 2006] Month [ 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12] Country [ list of 228] The inputs Type and Year combined tell me which table the data will be retrevied from i.e., if I select imp and 2003, the data will be retrevied from 2003imp . And the inputs month and year will be parameters for Where condition in the Query. I don't k ...Show All

• Visual Studio Express Editions Can't find compiled program

  I compiled the Hello World program with no erors, but i can't find the .exe file for the program Kyle Mck, Do you know where you stored the whole project If you stored the project bu default, the folder is in the following path: C:\Documents and Settings\[Your Login Name]\My Documents\Visual Studio 2005\Projects When you open it, you will find many folders which contains all the projects you have compiled. For example, if you project is called HelloWorld, the exe file is in HelloWorld\HelloWorld\bin\Debug. Use the command line of SDK Command Prompt, when you compile the project here by the cvb command line, you will also get the exe file in this folder: C:\Program Files\Microsoft Visual Studio ...Show All

• .NET Development How can i insert new value into an existing xml document

  I'm newbie in C# and i want to insert a new data into an existing xml document in ASP.Net 2.0 , looked msdn but i couldnt understand how please help me... this is my existing xml document: < xml version = " 1.0 " > < item > < title > </ title > < description > </ description > < pubDate > 27.07.2006 16:27:31 </ pubDate > </ item > in here i want to add a value into the <item> node... Probably the easiest way is to use the XmlDocument class. Example: XmlDocument doc = new XmlDocument(); doc.Load(path); //path to xml document doc.DocumentElement.AppendChild(doc.CreateElement("myNewElement")); //insert new item ...Show All

• Visual C++ Using animated GIF image in Forms

  Hi, I'm trying to use an animated gif image in a form within C++/CLI but so far without success. I looked at picturebox control but the image stay still, no animation. I browsed the NET to find any clue to my problem and got a few articles stating the fact that I have to make somekind of class that would rather display one at a time each frame found in my GIF. Any clue or easier way, any example on how to do it Thanks in advance, Stephane Hi again, It is true for a picturebox. But for a button control, the SizeMode property is not available. Any hint Stephane ...Show All

• Windows Forms Need to get the .MainWindowHandle

  I am trying to get the mainWindowHandle and store it for later; however, i can not seem to get the handle back from the new process. Before someone suggest , i will let you know that i have also tried the p.WaitForInputIdle(); however, this not only does not work it will throw and error..   private IntPtr mainHandle = IntPtr .Zero; private void button1_Click( object sender, EventArgs e) { Process p = new Process (); ProcessStartInfo ps = new ProcessStartInfo (); ps.FileName = "explorer.exe" ; ps.Arguments = "" ; p.StartInfo = ps; p.Start(); mainHandle = p.MainWindowHandle; } Can someone tell me how to get the mainWindowHandle   Erik Sorry, I guess I was focusing on y ...Show All

• Windows Forms Resizing labels and other controls

  Hi, I am having a query. I am using .Net 1.1 C#. There are a number of labels in a group box, one below the other and there are 4-5 groupboxes lying 1 below other. These labels get populated from backend so i m not sure how much amount of data could come. Actually there is no limit to it since the backend data type is Text for most of the fields. So now the problem is accomodating the text inside label and resize it according to values, at runtime. .Net does offer AutoSize property, but that only expands in width. My requirement is, it should not expand in width but rather in height. Now resizing the label can be done using Label.Height, but with this i also have to change the Y location, to accomodate it on the screen. ...Show All

• Visual Basic More than one datareader at the same time?

  How to replicate this snippet of code using Ado 2.0 I mean, you are not able to use two datareaders associated to the same connection. Let me know, how do I such thing, I'm just a newbie with ADo .Net. TIA  sql = "select..."  command.commandtext = sql  set recordset = command.execute   While Not recordset.EOF    sql2 = "select..."  command.commandtext = sql2  set recordset2 = command.execute  While Not recordset2      Wend    Wend   You can have only one reader per open connection. I would take a look at the ADO.NET VB samples here to get started learning ADO.NET 2.0 http://msdn.microsoft.com/vbasic/downloads/code/101s ...Show All

• Visual Studio Express Editions Mouse movement in C#.

  How exactly is mouse movement achieved in C# I know that in VB.net, it can be implemented using the gdi32 MouseEvent library, but what I truly need to know is how to achieve it in C# (along with simulated clicks, for macros). how do you mean mouse movement do you mean for example the mouse moving from the current position to say, the left hand side of the screen if this is what you mean, try this:   Cursor.Position = new Point(Cursor.Position.X + 10, Cursor.Position.Y + 10);     this will move the mouse from the current position, either way, and add 10 to the co-ordinates Mouse is known as a Cursor when coming to develop with it. To redraw or relocate the mouse, you simply create a new p ...Show All

• SQL Server Tell Us Your Express Story and Win $100!

  Want a chance to show off a cool way you’re using Visual Studio Express or SQL Server Express We’re looking for your stories! Tell us about something that makes your life easier or is just plain fun and if we like it enough to include in a feature article, we’ll give you a $100 gift certificate to Amazon.com! http://msdn.microsoft.com/vstudio/express/support/hero_promotion/default.aspx Andria1974, You say: No, you do not lose rights to your project at all. But if You read the terms and condtions is written: All stories and projects become the property of Microsoft and will not be acknowledged or returned . By submitting this project, you signify your acceptance of these official rules and agree to grant t ...Show All

• Visual Studio Team System Unable to assign plugin for test

  I'm tearing my hair out over this one. I've created a simple declarative web test, and I'm trying to assign a plug-in. I've followed the instructions in the MSDN article How to: Create a Web Test Plug-In. Namely, I've created a test project and added a recorded/declarative web test. Then I created a new project (type:Class Library) to hold the plugin. I created a class that inherits from Microsoft.VisualStudio.TestTools.WebTesting.WebTestPlugin, and provided implementations for PreWebTest() and PostWebTest(). In the test project, I added a project reference to the Class Library holding the plug-in. When I attempt to use the "Set Web Test Plug-In" button on the web test, I receive a message that says The project contains no refer ...Show All

• Visual Studio Microsoft(R) Uniscribe Unicode script processor

  Hi, Can someone tell me how to make VS2005 Report Viewer WinForm work with Microsoft(R) Uniscribe Unicode script processor (USP10.DLL) I develop software with VS2005 and .Net Framework 2. My application render complex script without problem but when I want to Print with Report Viewer Winform the complex script can't render correctly. Cheers, Kosona The reason your script not render properly because GDI+ is not capable to render complex script. I am not sure why they do it that way but I hope the future version of .net will support rendering complex script. ...Show All

• SQL Server Error installing SQL Server Management Studio Express

  Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express.  Today I noticed I needed to download the Management Studio seperate download.  I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:   Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..   Solved my own problem.  Once I moved the msi to C:\ the installation worked.  Apparently the path it was in was too long causing it to be unreadable. c:\xxxx\xxxx\SQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.   ...Show All

• Smart Device Development Access Database for pocket pc

  Does anyone know how to convert a .mdb file for use in a pocket pc device application Use Active Sync , but use a perior version than 4.5 beta because this feature has been removed in the last version. I suggest that you use ActiveSync 4.0 Just copy the mdb to your pocket PC using my computer the conversion will be done to a compact database file (cdb) If you need to copy the cdb file , you might rename the extension of .cdb on the pocket PC to avoid conversion to mdb then copy to your PC. Microsoft Active Sync is available at http://www.microsoft.com/windowsmobile/activesync/default.mspx Hope I could help! ...Show All

• Windows Forms Deployment of Projects using Managed DirectX

  I have been researching this question on the net a few days and have not had much luck. I have a project that uses DirectSound to play WAV files and I want to include the DirectX redistributable files in my install. Some of my users apparently do not have DirectX installed and are having issues running my application. (These users are using Windows 2000 without the latest service packs in an environment where they do not have an internet connection.) I found a Managed DirectX 9.0c bootstrapper package that was made in 2005, but it no longer works with the latest August 2006 DirectX redistributable files. The bootstrapper package interfaces with the Visual Studio 2005 bootstrapper, and enables the author to check a box for Managed Dir ...Show All