Mike Stall - MSFT's Q&A profile

• Windows Forms Read datagridview value of a button colum

  Hi, i have a problem using DataGridView. My application have a DataGrigView connect to a data source, i have a DataGridViewButtonColumn and i have connected the DataPropertyName to a specific column also i have put to true the UseColumnTextForButtonValue to obtain the same name for all buttons "Erase". Now i would to take the real value of my databaseColumn when i push the button but this no happen; i receve name of button but not the real value of this. I hope to be clear also if my language is not English. ...Show All

• SQL Server [SSIS] : STDEV in Derived Columns

  Hello, Does anyone have already tried to calculate a standard deviation (STDEV) in a derived column Any help is welcome ;-) Cheers, Bertrand Haven't calculated standard deviation in a derived column, but rather in an Async script component (i.e. Synchronous Input Id = 0 on the first output). The data being passed in to this transform is DT_CY data type (currency) called TotalDue. The data passed out is a DT_R8 on the output called StdDev. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptMain Inherits UserComponent Private rowCount As Integer = ...Show All

• Microsoft ISV Community Center Forums Edit Record Error

  Bachground:I have an access data base front end, who's tables are linked to an sql server backend. In turn the tables are connected to the Forms Dinamically. For example: ME.recordSource = "SELECT * FROM tblCustomers WHERE loc = '" & location "'" Theres one main form with about 5 Subforms connected to it all placed on tabs. About 3 of the forms record sources refer to the same table. When I have the main form on the last record and I try to delete a record on one of the particiular subforms I get the following message. ***The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.*** In all other circumstances it deletes fin ...Show All

• Smart Device Development Force GPRS disconnection ?

  As part of the application I am developping I sometimes have to force the GPRS connection to be shut down. For security reasons, the GPRS gateway of our wireless carrier voluntarily stops to enrich HTTP request with device MSISDN after a given period of GPRS traffic inactivity (GPRS connection being opened). Without this enrichment, our server can't identify the client and rejects its requests. A solution we found out was to explicitly close the connection and re-opens a new one if it has not had any HTTP activity for more than 'x' minutes, thus creates a new session with the gateway. So, we call ::RasHangUp() on every opened RAS connection and let the ConnMgr try to reconnect. (I know this is a rather extreme solution). The problem is tha ...Show All

• SQL Server Full Text Search Too much Resources

  Below is my query which is taking very long to run. The column "Description" is Full-Text Cataloged. SELECT p.Type,p.Modelname,p.Modelnum,p.modelyear,p.Category,p.urlclick, p.partno,p.description,p.Condition,p.classification,p.uniqueid, p.vendornumber,p.mfg,p.price,p.picture,c.CompanyName,c.City,c.State,p.thumbnail FROM Parts_all p, Contacts c WITH (NOLOCK) WHERE (0=0) And p.vendornumber = c.ID AND CONTAINS(p.Description, '"Helmet*"') This is horribly taking more time to run and its driving me nuts. How can I optimize this. ...Show All

• Windows Forms ComboBox SelectedIndex Crashes my program

  Hi. ComboBox1 items = collection ... 1=IBM Flt32 2=Sign Int32 3=Sign Int16 4=Sign Int32 withGain 5=IEEE Flt32 6=Sign Int8 I am using the following code on formload. Running through debugger it crashes when I click "step into" on the following line of code. //Binary Header Settings this ->comboBox1->SelectedIndex = this ->SegyContainer->GetBINARY_Settings_no1DataType_TracesPerRec(); The return type for GetBINARY ... is int.Getting desperate I added //Binary Header Settings this ->comboBox1->BeginUpdate(); this ->comboBox1->SelectedIndex = this ->SegyContainer->GetBINARY_Settings_no1DataType_TracesPerRec(); this -& ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problems obtaining the GraphicsDevice in a component

  Everytime I try to write something I get hung up on the same problem. I can't get access to my GraphicsDevice so that I'd be able to draw things through components. I've tried several methods listed, such as these: graphics = Game.GameServices.GetService<IGraphicsDeviceService>(); (Where graphics is of type IGraphicsDeviceService) I then call a graphics.GraphicsDevice, but with no success. Another way I've tried to do things is getting to the GraphicsDevice directly through a public property in my component. The obvious thing to do would be to pass the default "graphics" GraphicsComponent into the component, and then use the GraphicsDevice property to draw things in my code. No luck. IntelliSense and the IDE wasn't able to ...Show All

• Visual Basic What Installer to Use to Distribute VB Application

  I'm new to programming and have just completed an application I'd now like to distribute to folks for testing. Can someone please recommend an installer application (either free or payware) I can download to package the application for installing on someone elses computer Thanks for your time! Doug Just out of curiosity, why do you want the application to be located under the Program Files folder (Yes, I know there are plenty of valid reasons for this, but I the most common reply that I've gotten so far is "because...because... I don't know" ) Best regards, Johan Stenberg ...Show All

• Visual C# How to Create a URL syntax checker in C#

  I would like to create a URL syntax checker so that can verify a cerrtain URL not a phish site. But I am also aware that some URL have valid syntax but is still a phish site. To answer this, I am looking for some measures on how to verify a URL and its correct DNS equivalent. I am doing a project of mine as one of our requirements and I have decided to create a web browser (already done) and I have included there 3 anti-phish tools. One of the tools is to check for URL syntax error. i have searched for such but has given me no good results that can be of any help to my project. I was hoping that some of the bright minds here could help me or enlighten me in my search. Thanks. yeah something like that. But I won't be using th ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Pressing F5 JUST after installing C# Express and XNA Game Studio Express

  I have just installed C# Express and XNA G.S.E. and I know that if I open a new Windows Game project and press F5 right after creating a new project, it should create an empty 800*600 window. It isn't: Microsoft.Xna.Framework.NoSuitableGraphicsDeviceException was unhandled Message="The device creation parameters contain invalid configuration options." Source="Microsoft.Xna.Framework.Game" StackTrace: at Microsoft.Xna.Framework.GraphicsDeviceManager.CreateDevice(GraphicsDeviceInformation newInfo) at Microsoft.Xna.Framework.GraphicsDeviceManager.ChangeDevice(Boolean forceCreate) at Microsoft.Xna.Framework.GraphicsDeviceManager.Microsoft.Xna.Framework.IGraphicsDeviceManager.CreateDevice() at Microsoft.Xna.Fr ...Show All

• Visual C++ WaitForMultipleObjects doesn't work

  Hello Everyone! Function WaitForMultipleObjects Requirements: Requires Windows Vista, Windows XP, Windows 2000 Professional, Windows NT Workstation, Windows Me, Windows 98, or Windows 95. But this function doesn't work in WinNT. Why Thanks in advance Vladimir   Viorel. wrote: Maybe you should replace this: LARGE_INTEGER check_elapse = {10000}; with this: LARGE_INTEGER check_elapse = {-10000};  Otherwise the second argument of SetWaitableTimer  is treated as an absolute time value, which is never reached, since it is in the past (1/1/1601).   I hope this helps. LARGE_INTEGER check_elapse = {-1 ...Show All

• Visual Studio Express Editions using visual basic to read until the last row of data in excel and display all into chart

  i need to use a command where it is able to read until the last row of all my data and display them all into a line chart as i constantly need to insert new rows of data in and i do not wish to keep changing the row number of the chart... i have only managed to read and display the data until a specific row into the chart and so i hope to be able to find a easier way to do that by a click of a button...hope someone will be able to help me out... thanks this is the code i am using ActiveSheet.ChartObjects("Chart 12").Activate ActiveChart.SeriesCollection(1).XValues = "=one!R2C1:R650C1" ActiveChart.SeriesCollection(1).Values = "=one!R2C3:R650C3" but this code only allo ...Show All

• Software Development for Windows Vista Problem with TreeScope in Automation.AddAutomationEventHandler

  Hi! I would like to handle automation events, such as InvokePattern.InvokedEvent. I use the Automation.AddAutomationEventHandler method with different tree scopes (always with the same handler function called MyAutomationEventHandler). Automation.AddAutomationEventHandler(event, element, scope, new AutomationEventHandler(MyAutomationEventHandler)); The arguments are the AutomationEvent, the AutomationElement, the TreeScope, and the AutoamtionEventHandler delegate. My problem is the following: - if I use TreeScope.Element: the handler works perfectly - if I use TreeScope.Children: nothing happens, the handler method is never called for any children - if I use TreeScope.Subtree: nothing happens, the handler method is ...Show All

• Visual C# Debugger access error

  I am working on a machine running MS Visual Studio 2003. After I create and code a project, when it comes to compile&run I get the following message: Error while trying to run project: Unable to start debugging. Access is denied. Verify that you are an administrator or a member of the 'Debuger Users' group on the machine you are trying to debug. After being added to the 'Debuger Users' group, you must log off and log back on for the settings to apply Today, I got the same error.. I tried everything, registry editing, adding ASPNET user to debugger users group, etc... I think somehow my windows users corrupted or something.. By the way, my C: drive is FAT32 and all the others NTFS. I moved my inetpub directory to ...Show All

• Smart Device Development Sending SMS / EMAIL with MAPI

  Hi Folks, I am having a problem with sending Messages (SMS / Email) using MAPI. I have followed the sample applications in the SDK well. But I am still not close to a reliable and robust solution. My problem is categorically identifying the entries in the MessageStoresTable as corressponding to SMS / Text Messages and POP3 or others. What if the user has configured multiple email accounts on the device My application currently works fine, because I know how many accounts are configured and which entry or index in the MessageStoresTable corressponds to which account. So, my SMS and EMail messages get created in the Drafts_Folder of the corressponding account and things work fine. But this fix immediatly breaks down if I try thi ...Show All