Matthew Yeh's Q&A profile

• Visual Basic VB.Net help - Various Issues

  In our point of sale system, we can export various reports as a csv file.  The problem is that when we open them in Excel, some of the fields (which contain a number 20 digits long) show incorrectly as Excel can only recognize 15 unique digits and changes the last 5 to zero's. I have written a VB program that will allow the user to open teh csv file in a datagrid, adn the numbers show up correct.  Now I am having a problem figuring out how to do the rest of the program.  These are the issues I have remaining: 1.  The worksheet is 82 columns wide.  I need to be able to only import specific columns into the datag ...Show All

• Visual Basic Configuration system failed to initialize ---- Help Please

  When i try to run my app I get this exception "Configuration system failed to initialize" I recently added a datascource to the app and am assuming that something has gone wrong there but it was all working ok and then this error just started. I assume it's a problem with my appconfig file which i'll post here I cant see anything wrong with it but.!! I've tried deleting the ConnectionString Section but nothing helps and i cant run my app at all! Heeeeeelp!! < xml version="1.0" encoding="utf-8" > <configuration>   <configSections>   </configSections>   <connectionStrings>     <add ...Show All

• Visual C++ Memory Leak and New

  I'm a bit confused about the utility of crtdbg.h if I use the new function. If I use malloc I get a nice report saying that line x of file y leaked z amount of memory. Nice. If I use new, I get a pretty useless report that line 691 of crtdbg.h leaked z amount of memory. Well gee, thanks. I KNEW that new is being redirected to that inline function in crtdbg.h, I was kinda hoping maybe you could tell me where I came from, not where I went. Here is the source: #define _CRTDBG_MAP_ALLOC #include <stdlib.h> #include <crtdbg.h> int main(int argc, char* argv[]) { _CrtSetDbgFlag ( _CRTDBG_ALLOC_MEM_DF | _CRTDBG_LEAK_CHECK_DF ); int* lea ...Show All

• SQL Server how do i get date into dd-mm-yy format??

  i have the following in an insert stored proc CONVERT(CHAR(8),GETDATE(),10) but this inserts 03-06-06. how do i get it to 06-03-06 Cheers, Craig my sp is as follows:- IF (@blnConsent = 1 AND @dteActualConsentDate <> NULL) --This is PC insert for YES consent where a ConsentDate is supplied BEGIN INSERT INTO tblStudyServices (SurveyID, PatientID, FourRegularDrugs, FourRegularDrugsNo, HRD, ReadmissSixMonths, Consent, ConsentDate, CreationDate) VALUES (@intSurveyID, @intPatientID, @blnFourRegularDrugs, @intFourRegularDrugsNo, @blnHRD, @blnReadmissSixMonths, @blnConsent, @dteActualCons ...Show All

• SQL Server Some users cannot view report in IE 6.0

  Some users get the error The page cannot be displayed The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings. when they click on one of the reports in report manager. It does not seem to matter what user logs in. Thanks in advance for your help. It looks like a 401 error. Are you seeing this when you click a link to a report in report manager Does this happen for all reports or just a specific report ...Show All

• Visual Studio Team System Compact Framework Rules

  Hi, My team is currently developing an application that we would like to be able to run on the compact framework at some stage with minimal effort. It occurred to me that perhaps there are some FxCop rules that could tell us when we are using types that are not supported on WinCE. Can anyone confirm this Is this approach a bad idea Thanks, Kent VS actually ships with this functionality, if you're using it. We provided some helper code to help out with that (it wasn't written as a literal FxCop rule). If you were to acquire a list of APi available on your target platform, this would be a fairly s ...Show All

• SQL Server 'DataGridView1_CellContentClick' Doesn't Work For All Cells.

  SQL 2005 Express (Visual Basic 2005 Professional): I have a DataGridView with 'ReadOnly' set to true in the Properties Window. I would like to have it perform an operation when any cell is clicked. In .vb [Design], I double-clicked each cell, and, it jumped to  'DataGridView1_CellContentClick' where I entered the instruction to perform. But, it only works for some of the cells in the middle of the DataGridView.  The rest of the cells do nothing when they are double-clicked.   Hi furjaw, This forum is for problems with using SQL Express - this seems like a problem you' ...Show All

• Visual Studio BrokenToolboxItem objects: where do they come from?

  Is there any way to figure out where a BrokenToolboxItem comes from I have one that keeps getting created. When I drop it on a Form I get an error message. When I catch the exception thrown, by attaching to the devenv.exe process with a debugger, I am able to examine the ToolboxItem that causes the problem -- but it gives no clues. It says its type is simply "Component" and its namespace is System, as if it were a toolbox item just for the System.ComponentModel.Component class. Is there a way to determine the culprit creating this item This problem is now in the product feedback center. I submitted to support as well but don' ...Show All

• Windows Forms Viewing web pages in a Windows application

  I'm trying to put together a smart client app and need to display some web pages (html files).  I can't seem to find a windows control that will allow me to easily accomplish this.  Does anyone know of such a control (preferably free) or what the best apporach would be Thanks looks to be what I was searching for.  I'll&nbs ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. VB.NET/Direct X 3D object selection using the mouse click.

  I realize that I'm in the wrong forum, but there dosn't seem to be one for non-game applications that use Direct X. I'm not a C++ programmer. I've used Visual Basic and VB.NET to write applications that display objects in 3D. I want to able to allow the user to select one of several 3D objects via the mouse. Can someone supply some sample code in VB or VB.NET that does this. Thanks in advance. The Pick sample in the SDK does this. To expand it to multiple meshes, just repeat the ray intersection determination for each mesh that you want to check. ...Show All

• Visual Studio new vspackage wizard

  I created a new package using the Visual Studio Integration Package template and selected that I wanted a menu command.  Below is the generated .ctc file that was produced.  I get the following error when trying to build this project: XgenPackage(1): error CTC3028: Unknown section header   // // This is the file that defines the actual layout and type of the commands. // It is divided in different sections (e.g. command definition, command // placement, ...), with each defining a specific set of properties. // See the comment before each section for more details about how to // use it. // // The CTC compiler (the to ...Show All

• Windows Forms Custom control in a column of a Listview

  Hi, I want to have some customized controls in a column of a Listview control (of course when the view is set to deyails). The custome control might be a comboBox or some images or a textbox. Thanks in advance. Kundan Hi all I'm interested in the same subject as I needed to add some controls to the columnHeaders of the listview. I had made some success in that but with problems. First I increased the height of the columnHeader by using the sendmessage API to retrieve the handle of the columnHeader using the ( LVM_GETHEADER) then calling the SetWindowPos to change the height. then I used the ...Show All

• SQL Server Cant insert and delete

  Hi, Can anyone help me I am using MSDE 2000 with VS.NET. I can SELECT from the database but i cant insert and delete and update. Below are my code public static int Add( string tmpSql, string connectionString) { oleConn = new OleDbConnection(connectionString); oleConn.Open(); oleTran = oleConn.BeginTransaction(); try { oleCom = new OleDbCommand(tmpSql, oleConn); oleCom.Transaction = oleTran; int a =oleCom.ExecuteNonQuery(); return (0); } catch { oleTran.Rollback(); return (1); } finally { oleConn.Close(); } } my int a give a value of 1 but when i look at the database the data is not inserted ...Show All

• Visual Basic RaiseEvent in inherited classes

  Sorry if this is a FAQ: I've read the error notice in help (VS 2005 Visual Basic Express Edition beta 2) saying that I have to "move" the declaration of an event into the class I want to use it in. Doing that means that the   Dim WithEvents myvar As ParentClass in the MainForm module causes an error because the class doesn't have any events. My problem is that I want to Dim the parent (mustinherit) class because I want to be able to choose at run time which of two inherited classes I want to use; and I want to use a common routine in the MainForm to display changes in the class. I've tried declaring this in the child classes: &n ...Show All

• SQL Server Creating Dimension Template...

  Hello, I need to create a dimension that has pre-defined multiple hierarchies, attributes, and the data source table the dimension will be based on would be different for each customer. (The structure of the data source table would be the same though, just the underlying data would be different) Thus, I thought about using the dimension template. However, the steps in the dimension template wizard is quite confusing to me. Does any know where to find a good document explanning how to create a dimension template I read through the MSDN library about creating the template, but it's not too helpful either. Please let me know if I am h ...Show All