Jehan Badshah's Q&A profile

• Windows Forms Confirming row deletions on datagridview

  Hi -- I'm trying to figure out a way to ask my users (via a message box) if they want the selected datagridview rows deleted. It's very simple if only one row is selected. But if many rows are selected, I don't know how to stop the message box from displaying just before each row deletion. Any ideas Bill I think I figured out a way to perform the deletion without getting multiple confirmations.... First, in your UserDeletingRow event handler, add the MessageBox.Show function that asks the user to confirm the deletion. Regardless of which button they press, set the Cancel property of the "e" object to False. Then if the user confirmed that they want the deletion to proceed, delete the selec ...Show All

• Visual Studio 2008 (Pre-release) [Serious BUG] WPF doesn't paint anymore (lost DirectX ?)

  I was upgrading my application to the latest bits (June CTP) when I encountered a very strange bug. My application first loads a NavigationWindow, and let the user toy around with some menus. Then, the window gets closed and a "regular" Window shows up. When the "regular" Windows gets closed, my application creates a new NavigationWindow and shows the same menus as before to the user (who has an option to quit). There's a huge bug in WPF with the third step (which was working in the previous build - beta 2 I think). The NavigationWindow shows up, but its contents don't paint. (more precisely: I get the "hall of mirror" effect, which you get when you forget to write your WM_PAINT handler in a non-WPF applicatio ...Show All

• SQL Server SQL Syntax Error

  Thanks in advance Below is basic sql script. I don't know why it has syntax error. Please explain why and advise correct answers. DECLARE @Date_Range VARCHAR (200); DECLARE @RowCount int ; SET @Date_Range = '(Date BETWEEN CONVERT(DATETIME, ''2006-11-1 00:00:00'', 102) AND CONVERT(DATETIME, ''2006-11-30 00:00:00'', 102))' ; SELECT @RowCount = Count (*) FROM MyTable WHERE (EmployeeID = 1111) And + @Date_Range; Line 9: Incorrect syntax near ';'. Snow: You need to change this to something like this: DECLARE @loDate datetime set @loDate = '2006-11-1' DECLARE @hiDate datetime set @hiDate = '2006-11-30' DECLARE @RowCount int; SELECT ...Show All

• Visual C++ Database and C++

  Hi Folks; Could someone point me in the right direction for resources on database interaction through C++ that is not .NET Currently I'm trying SQLAPI++ (my COM experience is limited to none until last week) but the examples I've seen are for a local database. Mine is across a network so I was wondering if anyone knows if it can connect to a database that is across a network. ...Show All

• SQL Server login and web admin tool

  I've been trying to get my website back up and running, I lost the db and will have to reconstruct that but in the meantime I would like to get the website back in operation right now I have the following problems. I receive an error message when trying to create a new user in the web admin tool. see 1A or I receive another error message  saying that the administrator is not authorized to sign onto the db and I seem to have the authorization settings incorrect for the hashed password settings I had... Ive looked back through my notes and the last time this happened I created a new database with the web admin tool but my settings are such that this still doesn't eliminate the error messages.  Right now the web ...Show All

• Visual Studio Building huge solution

  Hi, We have +- 85 projects as part of one huge solution. Making changes way down in the dependancy chain spawns a build process that takes forever, even with super fast machines. My question, if the changes made to the code does not affect any public interface, why does everything above this project in the dependancy chain get rebuild Surely this is not needed or am I missing something or even better is there a way to instruct the build engine to not recompile everything above thx adrian I think there exist one solution. You can make special target SpecialTouch called before you run building project (in DependsOnTargets="SpecialTouch;..." it comes first). If some files is newer than existing one and we know that ...Show All

• Visual Studio Tools for Office MAPI - Proper use of IMessage SaveChanges() flags?

  I've read the MSDN docs for IMessage SaveChanges() method: http://msdn.microsoft.com/library/default.asp url=/library/en-us/mapi... and it says you use KEEP_OPEN_READWRITE to keep the item open after saving changes, and if that fails with MAPI_E_OBJECT_CHANGED you should retry with FORCE_SAVE. And it appears if you call SaveChanges with KEEP_OPEN_READWRITE followed later by another identical call, then you get the MAPI_E_OBJECT_CHANGED error. But in the real world of coding, if you have some complex logic it's quite likely you'll refactor code into several methods which could be setting properties and custom properties and you cannot necessarily guarantee the order of each method or whether they are called at all. In this ...Show All

• SQL Server Save and load data with schema in MSDE

  Hi, How can I save and load data with schema in MSDE in the quickly way I need to do this in 5-10 second for 5 millions of rows. Thank's Alexei Please take a look at the link below for some tips onhow to optimize bulk load: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx You also realize that the bulk insert will only be as fast as your disk system. It is mostly an I/O bound operation. ...Show All

• Visual Studio 2008 (Pre-release) Trusted Subsystem Implementation

  We are building an application that has multiple WCF services hosted in IIS on multiple machines within a customer's topography. The services need the ability to access network resources (hops to other WCF services, database, file system, and active directory). We have been treating public services as trusted subsytems: access to the public service is authenticated and authorized using the user's identity, but access to other resources within the service are executed under a trusted identity. Here is my question. What is the best way to access the other resources under the trusted identity Run the App Pool as Network Service and Impersonate when access to the resource is required. Seems kind of messy having to store the truste ...Show All

• Visual Studio Batching and meta data

  Hi guys, i used to think batching was stupid, but now i think it is rather useful :) I have a bunch of WiX project files that need to be built into MSIs, and i am trying to achieve this with batching. My problem is how to access the custom metadata of each item. Here is an example: <ItemGroup> <WiXProjectFile Include="MyProduct.wxs" > <TargetObjectFile>MyProduct.wixobj</TargetObjectFile> <LinkableObjectFile>wixui_mondo.wixlib</LinkableObjectFile> <LinkableObjectFile>another_lib.wixlib</LinkableObjectFile> <LanguageFile>WixUI_en-us.wxl</LanguageFile> <MsiName>MyProduct.msi</MsiName> </WiXProjectFile> </ItemGr ...Show All

• SQL Server alfanumeric counters?

  Hi there, T-sql 2005 is offering the possibility to define alfaphanumeric counters I mean, stuff like this: a,b,c...z, a1, b1...zn...a2.. Is it possible or it must be built for yourself I'm awared of IDENTITY function when I ran Sql2k but it doesn't target my goal. Thanks for your time, You'll have to build that yourself. The question you need to ask yourself is why do you NEED an alpha-numeric identity. If you plan to process a field differently based on the format of the field then you're getting into the "database within a database" scenario which is bad. ...Show All

• Visual Studio Express Editions error when start with debugging

  Hi, I need some help on why each time when I click start debugging (VCE2005) i will get the same errors on all apps before I had no problems. I have already re-installed VCE 2005, same problem. The program will not get any errors if I choose start without debugging. Any help will be greatful. Thanks! heres the codes: #include <iostream> using std::cout; using std::cin; using std::endl; int main() { int num; cout << "Enter a number from 1-5\n" ; cin >> num; switch ( num ){ case 1: cout << "You entered the number one.\n" << endl; break ; case 2: cout << "You entered the number two.\n" << endl; ...Show All

• Visual Studio 2008 (Pre-release) WCF Performance hit when connecting through proxy server

  I have been struggling with Performance of my WCF Web Service. The problem is whenever we make our Web Service call go through a proxy server in place of direct connection to the server, it takes a lot of time to connect and complete call. Since Server and Client machines are both on same network, we have made the call go through proxy by having the 'Bypass Proxy server for Local addresses' check box unchecked in Internet Explorer on Client machine so that connection is made through Proxy server. In this case the connection is really slow. If we have 'Bypass Proxy server for Local addresses' check box checked than Client makes the direct connection to server which is really fast (15ms compared to 359ms for the same call). I am getting ...Show All

• SQL Server "dangerous MSI" Microsoft SQL Server 2000 DTS Designer Components

  Microsoft SQL Server 2000 DTS Designer Components has cause a total destruction of my Enterprise Manager. In my workstation I've got Sql Server 2000 client and Sql Server 2005 client. Everything goes fine up to here. But when I've installed that MSI I have not been able to open my Enterprise Manager. From MMC appears: Error initializing component CLSID: {xxx.xxx} My goal was be able to open 2000 stuff from Sql Management Studio. By the moment, I'm forget of that. Does anyone have ever faced this issue QA is working. Thanks in advance for any suggestion First, if you had 2000 client tools and 2005 client tools installed you did not need to install the "DTS designer tools&quo ...Show All

• Visual Basic passing of form

  isRouteValid( Me ) the above code calls the following procedure. I am attempting to pass the form but it won't allow me to. is there a way to solve this Public Function isRouteValid( ByVal inForm As frmRouteTemplate, Optional ByVal inAllowALLRoutes As Boolean = True ) As Boolean ' System.Windows.Forms.Form Dim localRouteName As String Dim localComboRouteText As String localComboRouteText = UCase(Trim(inForm.cmbRoute.Text)) If Len(localComboRouteText) > 0 Then If localComboRouteText = xALL_ROUTES And inAllowALLRoutes Then localRouteName = xALL_ROUTES inForm.lblRoute.Text = "" isRouteValid = True Else localRouteName = GetRouteName(localCom ...Show All