enric vives's Q&A profile

• Visual Basic Updating a dataset (Syntax error (missing operator) in query expression)

  Hi all I keep getting a syntax error when I try updating my dataset. I can add and delete no problem it is just when I try to edit existing records. I have attached my update code below. Private Sub UpdateDataSet() 'Procedure to update the dataset if new record is to be added 'or existing one edited. Try Cursor.Current = Cursors.WaitCursor '------------------------------------------------------------------ Dim updateCommandBuilder As OleDbCommandBuilder = New OleDbCommandBuilder(daComplaints) '------------------------------------------------------------------ If CurrProcess = "ADDING" Then 'Create a new row and add to table. Dim newRowValues As DataRow newRowVa ...Show All

• .NET Development Update error IN sql DB

  sairam, I am getting error Enter Update statement on Modified rows of Dataset in sql datbase on save buuton using datagridview in Visual studio on windows application in .net. I have just dragged the table on form and insert and delete were working but update gives an exception on update statment using wizard. If u could guide me in this direction. Thanks, Darshan Gera ...Show All

• Visual C++ Again an "error LNK2019"

  Well, I've seen many posts related to this linker error, but I haven't been able to solve my problem with them. I'm building a DirectX 8.0 game with Visual Studio 2005. The errors I got are (I guess the one that matters is the first one) : LIBCMT.lib(crt0.obj) : error LNK2019: unresolved external symbol _main referenced in function ___tmainCRTStartup C:\Documents and Settings\Admin\My Documents\Visual Studio 2005\Projects\GameCore\Debug\GameCore.exe : fatal error LNK1120: 1 unresolved externals Thanks for any help with this problem. Freezer wrote: I tried but it didn't work. Instead, I got some other errors : Core_Input.obj : error LNK2005: _WinMain@16 already defined in Cor ...Show All

• Visual C++ Event Confusion!!

  Hi all, I'm pretty new to the world of VC++ programming and I'm trying to implement a mousemove event on a picture box on a dialog. I can get the MouseMove event to fire if I add a message map etc to the dialog cpp file and header, but when I add a picture box, there doesn't appear to be a class file to add any code to for the MouseMove event. I'm a little confused, if the code goes in the Dialog cpp and header how do I tell it that it's the picture box I want the event to fire on and not the dialog box Please someone help, I'm totally confused. Cheers Pete Hope you are aware about adding controls variables. If you add a new resource like dialog, you've to attach it to a class. Most probably by creating a ...Show All

• .NET Development Marshalling to an ActiveX Control with VARIANT* argument on Vista

  I have an ActiveX control with a function like this: long CoolFunction(BSTR* arg1, long arg2, VARIANT* pUnusedArg3) If you add a reference to this ocx from a C# project, you get a function like this: int CoolFunction(ref string arg1, int arg2, ref object pUnusedArg3) On Windows XP, I can call this function like so: object unused = null; string myArg1 = "blag"; int myArg2 = 0; CoolFunction(ref myArg1, myArg2, ref unused); On Vista, when I do this, I get a null reference exception: System.NullReferenceException: Object reference not set to an instance of an object. at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgDa ...Show All

• SQL Server change the background color in table in report

  I have a table that i need to display data for each row I want the background color to be diff anybody knowhow to do it color blank color blank Try using RowNumber instead of RowCount. The code is placed in the background color property. Choose the color dropdown and look for the <Expression> option. Select that, and add your code there. ...Show All

• SQL Server Dynamic goal for a KPI?

  Hi! I'm new in SSAS and I'm stuck. Here's my problem : The goal of my KPI has to change (every month or every year). I could enter these different values with an MDX expression such as CASE WHEN <date condition> THEN goal-1-value ... END but i'd like it (different values of the goal) to be stored in a database. So my question is : Is it possible to get back these values from an MDX expression If not is there another way to get these values from database in SSAS Thanks in advance, Philippe Assuming that you do store the goal values in a table, you coud add a measure group, with a measure for the goal value, to the cube. Then this "goal" measure can be directly accessed in MDX. ...Show All

• Visual Studio Express Editions Overrides BackColor in a Custom Control

  Hi, I'm creating a custom control that uses DrawPolygon and FillPolygon in the control's Paint event handler to create the visual control in the user's window. I'd like to Override the BackColor routine so that instead of coloring the rectangle in which the polygon is located it just uses the color in the FillPolygon routine. This is the code I am using: Public Overrides Property BackColor() As System.Drawing.Color Get Return _FillColor End Get Set ( ByVal value As System.Drawing.Color) _FillColor = value Me .Refresh() End Set End Property I have created the variable _FillColor which is used by the Paint event handler when it calls FillPolygon. The result is that the entire rectangle is ...Show All

• SQL Server CommandText on Report Server

  When a report runs is it possible to retrieve the command text and modify it in order to append some additional "where" conditions, before the sql is processed to return data to the report You can write code like this declare sSQL varchar(500) declare sWhere varchar(200) set sSQL = "Select * from mytable" if lenght(@Parameter1) > 0 begin sWhere = " Where mycolume = '" + @Parameter2 + "'" end sSQL = sSQL + sWhere EXEC (sSQL) ...Show All

• Software Development for Windows Vista Where to get July CTP of .NET Framework 3.0 and Windows Workflow Foundation (WF) RC4

  The relevant links for the July CTP of .NET Framework 3.0 and the associated VS Extensions for Window Workflow Foundation (WF) RC4 are below: .NET Framework 3.0 July CTP from here . VS Extensions for WF RC4 from here . Windows SDK for July CTP from here . If you are just starting with WF you should install this build. There are no new features or API changes between RC2 and RC4, only some bug fixes. Before you ask, I don’t have a list. i have a problem... i installed everything in this post... but i still can't find the extension visual studio... i dont know how to create a new workflow is there something i did wrong i first installed .net 3.0, then the sdk then i tried installing the extension b ...Show All

• Windows Forms Serialization

  Execuse me for this silly question Wht are the benefits of using serialization before classes or structure or ... Thank you Some links that may be helpful: http://www.codeguru.com/columns/DotNet/article.php/c6595/ http://msdn.microsoft.com/msdnmag/issues/04/10/AdvancedSerialization/ There are some pieces of code there. Hope this helps. ...Show All

• Visual C++ fatal error C1083 in VS C++ 2005 express

  Hi, I have previously created new windows console application with a precompiled header. At this point, I do not change any of the default settings in the project. I insert the following set of header files in stdafx.h #include <cmath> #include <fstream> #include <string> #include <conio.h> #include <iostream> #include <iomanip> using namespace std; However, I am now getting the following error message when I try to compile: c:\program files\microsoft visual studio 8\vc\include\cstdlib(13) : fatal error C1083: Cannot open include file: 'stdlib.h': No such file or directory I have looked in the directory and verified that the file exists and is located in the "..\include\" folder.I have alos che ...Show All

• Windows Forms DataGridViewCheckBoxColumn Check Changed

  Is there away to catch a check changed event Itzik You can use the CellClick event of the DataGridView, and then check if the value of the column with the CheckBox is true, like this: foreach ( DataGridViewRow row in dgvDetails.Rows) { if (row.Cells[ "RowWithCheckBox" ].Value != null && ( bool )row.Cells[ "RowWithCheckBox" ].Value) { //do something } } ...Show All

• Visual Studio 2008 (Pre-release) How to put 2 ListBoxItem on same row?

  Since everything is possible in WPF (well almost) this should be a pieece of cake. when you have a number of ListBoxItems in a ListBox, they’re listed one item per row. But what if my ListBox.Width = 300 and my ListBoxItem.Width = 100 then there’s some waste of space. Before I dig in to it I just want to know if the way to do it (if doable) is by overriding some methods that’s placing the itmes out so I can manually place them out, animate them etc.. Well, why don’t I use like a Stackpanel I need to use a control that inherits from ItemsControl so I can use ItemsSource to databind my object in xaml. Would be grateful for some hints in the right direction Have a nice day /erik You ...Show All

• SQL Server Help with installation of SQL Server 2000 SP4

  Hi, I was wondering if anyone might be able to help me here. To be honest, this is my first time i have encountered SQL Server 2000 SP4. I need some guidance as to how to install and set up the SQL Server 2000 SP4. I have done it with SQL Server 2005 Express Edition and it's (I think) a lot easier to install and get it going. My computer runs on windows XP Pro (windows 32bit). I got confused when i got to the following microsoft webpage - http://www.microsoft.com/downloads/details.aspx FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en . I downloaded SQL2000-KB884525-SP4-x86-ENU.EXE. And when running the setup.bat, the message came up saying "SQL Server 2000 is not installed on this machine. setup will now exit&quo ...Show All