A.Russell's Q&A profile

• .NET Development Insert items in table from database?

  How can one insert items in database tables in oracle from vb.net Hi, Here is an example: http://aspalliance.com/621 You can use the System.Data namespaces which ship with .NET or use the optimized classes which need to be downloaded from Oracle. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• .NET Development provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

  This is my first application I'm building with Visual Studio 2005. I have a very simple piece of code: string dbSource = "Data Source=WMCCWKTBSWZ90EZ;Initial Catalog=Aptment;Integrated Security=True" ; SqlConnection con = new SqlConnection (dbSource); con.Open(); and it fails with the error: Error reading list of names. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) WMCCWKTBSWZ90E is my local SQL Server. I've used it thousands of times. I ha ...Show All

• .NET Development Excel and OleDB

  When you get a column schema in Sql, in the Data_Type column you get a verbal depiction of the sql data type that you are dealing with. However, when you get a column schema in OleDb for an excel spreadsheet, you get a numeric value for the data_type. Some of the correlations are pretty obvious, some are not. The issue that I am dealing with is that I am downloading Sql Data into spreadsheets. I am reading the sql schema to determine the data types to use to generate the create table statement for the spreadsheet. I have not been able to find any way of determining what the corresponding datatype definitions should be in excel for the sql data types. I would like to not just cast everything as char(), since char() seems to have a ...Show All

• Visual Studio Express Editions serial port Problem

  Hi there.. I am new in using C#. I want to make an application which opens a serial port and sends data to a device. I tried out many techiques, but nothing seems to happen and this drives me crazy because I am in a great hurry. The serial device is working properly, I've tested it with the HyperTerminal. I am using the simple following code: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.IO.Ports; namespace SerialPort_test { public partial class Form1 : Form { public Form1() { InitializeComponent(); ...Show All

• Internet Explorer Development How to retrieve active IE7 tab window's IWebBrowser2 object?

  Hi All, In IE6, when I got an instance of IWebBrowser2, I could judge whether it was active by comparing its hwnd with GetActiveWindow(). But in IE7, I couldn't do it, because IWebBrowser2.get_Hwnd returned handle of its container. Who can help me That events fires for many reasons including minimizing and or restoring. How can you tell if those from tab switching and where is the active tab's ... id ... stored. I have a bho that outputs an analysis of the webpage, and as the analysis takes some time, I keep the results, so if the user switches from one tab to another, I just quickly load the analysis results and display them. The problem is that I need some kind of tab ID to be able to tell which ...Show All

• Software Development for Windows Vista Video playback with brightness/contrast ?

  Hi guys. I am writing a C# app ( but C++ answers are fine, I have a C# DShow wrapper, and I can code C++ fine ), and the client has sprung an extra requirement on me, namely video playback ( which is trivial ) on what was before a still image viewer. They want the same controls on video, however, which means they want to rotate the video, and they want to set brightness and contrast on the video during playback. I've googled, and the WMP seems to have an interface, but it doesn't work ( just exposed for skinning ) and I can't see how to do this with DX either. Any help appreciated. There are two ways, both have good and bad points. Using the Video Overlay2 Filter: Overlay is the older way of rendering but it is also the most w ...Show All

• Visual Basic TableAdapter.Update command issue

  Hi, I'm pretty new to VS 2005 but I have a strange problem with the TableAdapter.Update command as it runs successfully but will not update my unlined bound database table. Any suggestions on how I should identify what's going wrong or to fix it. The command I run at the moment is: me.tableadapter.update(me.dataset.datatable) Thanks, John To elaborate a little further on what renee has said, how are you determining it hasnt updated the database, are you stopping you application and restarting it in debug. If so then the likelyhood of the database being overwritten each time you start restart the application in debug is pretty common and presents and illusion that the update may not h ...Show All

• SQL Server Using MDX query in Report Designer?

  I have a fact table in a cube which consist of a field with number records ( 10,20,14,69 etc).... Now I wanted to separate those records with range values. In other words, if there are 5 of the records with number 10, 5 records with number 69. So together there are 15 record count in that fact table. And I want to create a report from the report designer ( matrix table) such that there is a 'row' with static values say <20 and >30. Under these two group, the first 5 records stored under < 20. and the other 5 stored in >30. Now the cube is used for slicing by the dimensions. First solution : restructure the cube so that there is a separation of the critieria before hand( separate into two tables in data view source when cr ...Show All

• Visual Studio Team System [HELP!!!] Testing ASP.NET application UI using VSTS

  Hello all, I have been using Visual Studio Team System to evaluate whether form fields exist or not on my pages. Things were going fine until I added a master page to all the pages which had forms. Now, my tests for whether the form fields exist or not fail because the form fields are contained within the content area (the <asp:content> tag) of the master page. The test fails because the id of the form fields change dynamically when the page is rendered. For example, if I have a text box named "name" in one of my forms and I place it within the content area, the id changes to something like "xxx_contentplaceholder1_name" (not sure of the exact ID). How do I test for my form fields when they are placed wi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Good Budget XNA Compatible Video Card???

  Can anybody suggest a decent / cheap video card that meets the dx9c and Shader 2.0 requirements ...Show All

• Windows Forms Custom title bar of the Form

  Hello, I want to customize look of the title bar. In a matter of fact i need to add bitmap images to the left and right ends of the title which heights are not equal. What are the "good"/correct/efficient way to do it I have a title image (defined by art and approved by marketing ) which i must put instead of the standard Windows Form title. The problem is that the image is not rectangular but constructed from two bars: +--------------------+ | | +-----------+ | | | +--------+ like above. According to art dept. it should be placed that way that the right side cover a part of the menu bar which does not have elements. I tried the most straight forward way by putting a panel with an ...Show All

• SQL Server UDM and Data Mart

  I'm very new to SSAS. I'm reading the book "Delivering Business Intelligence with Microsoft SQL Server 2005". In page 53 (if you got a copy), it mentions that "UDM is a structure that sits over the top of a data mart ... one of the major advantages of a UDM, however, is that it does not require a data mart. You can also build a UDM over one or more OLTP systems." This really confuse me. It claims this is possible but I can't find any further works on this. Afterwards, data mart is created for demonstration. So, is a data mart really needed I want to skip creating data mart because I hope to keep thing simple. I don't want to use the Integrated service to ETL my OLTP database into data mart structure if it's not so impor ...Show All

• Visual C++ Problem including afxtempl.h in WinForms app

  I've created a WinForms app in VC++ 2005, set the project to "Use MFC in a Shared DLL" and "Use CLR support". I then added a "#include <afxtempl.h> in the Form class, as below: #pragma once #include <afxtempl.h> namespace test_afx public ref class Form1 : public System::Windows::Forms::Form When I run it in debug, I'm getting a Debug Assertion Failed error, as below. Program: test_afx.exe File: dbgheap.c Line: 1394 Expression: pUserData!=NULL How should I fix it, so that, the class Form1 can use MFC classes such as CArray My call stack is blank, however, the last outputs are as below when I selected to debug the ru ...Show All

• Audio and Video Development HD-DVD DONE!

  32 Hours and Im ready to burn!!! Thanx a million Jeff you were the primer! Do I just burn my 2 folders to a DVD-9 as Data or is there a trick to get the Toshiba HD-XA1 to play that way I wouldn't put Nero on the same machine as Advanced Content. For some reason it interferes with AVC importing. Sonic is trying to fix this issue, but it's been a problem for some time now. If you already did install it and need to use AVC, try it out and see if it works. If not, uninstall Nero and you should be good. ...Show All

• Visual Studio Express Editions ...

  How do I check if a URL is valid indeed I have and given a response to it - the PING class only pings the webserver, not the webpage but now also see from your last post after reading mine, you edited your post to include a URI checker but the user wants to know how to check if the webPAGE exists ...Show All