Steve Hempen's Q&A profile

• SQL Server Aborting a thread CRASHES Sql Server 2000!

  Hi, I'm creating a new thread and executing a database import operation using a transaction. I have had several problems that I cannot explain, the most serious of them being that aborting this thread sometimes crashes the instance of Sql Server to which I was connected! The application is a Windows Forms app, and when I launch the import operation I display a form that allows me to abort the import while it is in progress. If the user decides to abort the import in the middle of things, I call the Abort() method of the thread executing the import. I'm catching any exceptions in the method on the bottom of the call stack (the ThreadStart delegate) and logging the information, and from the stack trace I can see that the ThreadAbort ...Show All

• SQL Server in which language the SQL is implemented?

  i need to know in which language the standard SQL is implemented.. and that from where can i get the code.. i need the code for the "logical operators" of SQL. Plz help.. as far as the relevace is concerned to the SQL Server integration Services, there isn't any.. i m just lookin for help wherever i find it.. my project is to implement a few Operators in the original SQL implementation.. just like the "logical operators" found in sql.. for that i need to know how the operators are implemented in SQL.. got it ...Show All

• Windows Forms How to edit a row in a DataGridView

  Normally I do web applications and this is why I'm lost. I have a winform that has a datagrid view which is bound to a BoundDataSource control who's source is a class that comes as part of a intra-department web service. When I want to edit a row, I don't want to continually hit the web service for each cell as it's updated, I want to do something like: OnRowEnter() { gvData.CurrentRow.BeginEdit(); } OnRowExit() { if(gvData.IsCurrentRowDirty) { //Save row to data store through web service } gvData.CurrentRow.EndEdit(); } Unfortunately it doesn't appear to be so easy. How would you accomplish this is a winform using DataGridView and BoundDataSource. This updating on every cell stuff is for the birds...talk about wa ...Show All

• SQL Server Is SQL Server CE really the solution?

  Hi,   So far, with other programming platforms, I used to have the facility, embedded within application .exe, to:        1- Interface with already existing "multi-user" database (ex: Oracle, Access, etc.)        2- Create/access "local"/"Single-User" files for processing purposes.  (try to minimize network trafic...)   So far, I've read a lot about SQL Server products (SQL Server, Sql Server Express, SQL Server CE), at least all articles I could find, and would like to have your opinion on what would be the best approach        1- What SQL version to use for "multi-user" databases &n ...Show All

• Windows Live Developer Forums Live Messenger Problem - User is allowed to bypass block.

  Someone keeps trying to add me to their contact list in MSN Messenger. Every morning I get a prompt to either allow or block him. I block him and even check the Privacy options to make sure he is, but every morning when I sign in I get prompted again. Is there any way around this annoyance Thanks, Tynman Just found this tip on http://forum.mess.be/lofiversion/index.php/t19824.html Seemed to have worked for me at least. -h --- First make a backup of your contactlist by going to Contact > Save instant messaging contacts in main WLM menu (just incase). Next try the following: Close down Messenger if it's running. Click Start > Run, and type: %userprofile%\contacts <enter> If nothi ...Show All

• Visual Studio Unable to debug unmanaged C code

  Hi, I have a solution in VS2005 that comprises of a main vb.net project and an unmanaged C DLL, the linkage being via dllimport. I have my vb.net project set to allow debugging of unmanaged code and my C project set as mixed, but no matter what try I cannot get the source displayed when I step into the C DLL. Any ideas You are a hero Sir!!! I had missed out turning on debug at the link level, I'd only done it at the compiler level, I now have source level debugging of my code. ...Show All

• Windows Forms ClickOnce updating problem

  Hi, I have a ClickOnce application that creates a new instance in a new directory everytime it updates instead of updating the same instance, therefore the data saved is lost everytime it downloads a new version. Any Ideas why im getting behaviour Thanks OK I've done some more testing. I publish 2 different versions to my hard drive and then upload files onto a web server. If I install from my hard drive and update from my hard drive, data files are NOT copied. If I install from my hard drive and update from the Web, data files are NOT copied. If I install from the Web, change the online version and update from the Web, then... 1) it upgrades without prompting whether to install or not 2) Data fil ...Show All

• Internet Explorer Development How to get image or picture data?

  I wanted to know if there's any way to retrieve the actual "image" as such in a BHO. I want to add functionality such as "Save to folder" or "send by email" for images through my BHO. However, after quite a bit of searching, I don't seem to get the actual image "data" as such. I either need the image's file saved in IE's cache or some sort of binary blob which I should be able to save. I tried the RetrieveUrlCacheEntryFile from wininet.dll but either I'm not getting it right in managed code through the pinvoke thingy, or I'm using it wrong, but it's returning the file-not-found error code for each call. Any suggesstions Hi Archis, Can you please pos ...Show All

• Windows Forms BindingList.Add behaviour (Extremley slow!)

  I am trying to improve a bindable class that supports filtering. I use a class I found on a blog somewhere. After some fidling I get it to work, and I have replaced the Filter functionality with my own RegEx filter that works nicely. My problem, however, is that the BindingList.Add method is so extremly slow! The functionality is like this: I have a textbox where the user inputs his filter. On the Change event I update the BindingSource.Filter property, and run my own filtering code. When the user removes his filter, the original values should be shown again. This is when the problem arises. I have to clear the bound collection, and copy the values from the original collection back. This should be extremely fast, since it is an in-memory l ...Show All

• SQL Server AS2005 Member Properties - MDX Query

  Hi, I am having a bit of a problem with retreiving member properties from our AS2005 cube. I'm using MDX query's in a VBA Excel app via ADO (not ADOMD). I've been prototyping the queries in the SQL Server Management Studio. I currently have the following query: WITH MEMBER [Measures].[Portfolio] AS '[Trade].[Trade By Source System].CurrentMember.Properties("Portfolio")' SELECT NON EMPTY { [Measures].[Portfolio], [Measures].[CR 01 Net Skw Adj USD], [Measures].[JTD 01 USD] } ON COLUMNS , NonEmpty ( Exists ({[Trade].[Trade By Source System].[Trade Id]. MEMBERS },[Trade].[Trade By Source System].[Source System].&[Calypso])) ON ROWS FROM [GCD] WHERE ([Close Date].[Close Date].[D ...Show All

• Visual Studio 2008 (Pre-release) Get Child components on a seaprate thread?

  Hi all, I'm trying to create a utility method to disable all the children of a component, be it a page or stack panel or dock panel etc. This method must be capable of running from a non-ui thread. I realise the actual updates to the UI need to be done on the UI thread however. I cant call PageFunction.LogicalChildren from a separate thread and i cant call the method from a different clas because its protected. So can you guys help This is what i need: 1. Method to take a PageFunction or StackPanel etc and disable all child components. 2. Must be callable from a non-ui thread. public void DisableChildren(PageFunction<String> f) { //get children //iterate through and disable them on the UI thread. } ...Show All

• Visual C++ Help with making a AntiCrash Program

  HI, I am a new VC++ user and im now taking on my first project. I am working on making a Anticrash Applications. I have a form that has a start program, stop program button to launch and start the application. The application is a cmd prompt server app. I need to be able to start the app monitor it in case it crashed and restarts it if it has crashed. Otherwise I can use the stop button to shutdown the app. I have tinkered with System::Diagnostics::Process methods but havn't had much luck nor found a detail resource on how to use it or if its even the correct one to use. If anyone can point me in the right directions to find what im looking for or even a very simple example would be great. All I have found so far by searching was abou ...Show All

• SQL Server Delete All Tables from MS Access Database

  HI I want to delete all tables from an MS Access database. i cannot use the designer . i have to do it thru an sql statement a bunch of statements will also do . . any body has a solution P.s: All replies will be appreacited Hi, this is the SQL Server forum, perhaps you might try a Access forum, which might give you a wider variety of answers and experiences. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C++ Adding objects to ArrayList?

  Hi, I want to use an ArrayList to store objects (see below) ArrayList *arrylst = new ArrayList(); MyClass1 *class1 = new MyClass1(); arrylst->Add(class1); However, it gives me an error saying it can’t convert class1 to type object. My question is how can I get it to work Thanks for your help! Try ref class MyClass1 { }; ArrayList^ arraylst = gcnew ArrayList(); MyClass1^ class1 = gcnew MyClass1(); arraylst->Add(class1); Consider reading up on a text such as http://www.codeproject.com/managedcpp/cppcliintro01.asp . ...Show All

• Visual Basic Need help waiting for event

  Hello, I need some help learning how to wait for an event to fire. Events are fairly new to me, so bear with me! I have successfully created an event handler, however, I need my program to wait for this event to fire before continuing. I've looked at the EventWaitHandle class, but I am not completely clear on what I need to do. A little bit more about the situation: I'm using a class/application written in VB6. I call a method in this class and it has the possibility of doing a LOT of calculations, however I have no clue how long it may take. As such, "sleeping" for a period of time is not possible. But because any further action in my program requires the results of those calculations, I cannot continue excecution. ...Show All