sharc's Q&A profile

• Windows Forms How to simulate a particular button when Enter key is hit?

  I have a small dialog for calculating numbers and my problem is that when I hit enter key through keyboard,whatever button currently has input focus, that will be simulated again. ie if Button "1" was clicked earlier,then hitting enter will stimulate "1" itself many times. I need a paticular button (EQUAL TO)to get simulated when I hit enter.I believe I can transfer the focus somehow....However I am uanble to do that.How can use mnemonicKeys inorder to get the index Do I need to write a method to handle the KeyDownEvent Some override for ProcessDialogKey Any help on this is welcome... ...Show All

• SQL Server is it possible to have variant condition clause in procedure?

  i want to use OLEDB to build a COM for my app in the case, i want to execute a select statement which the where-clause is variant. ex, select * from db1 where code='abc' select * from db1 where name='mike' As it's very difficult to change sql-command in oledb, i want to build a procedure like this, create procedure viewDB @filter CHAR(20) as select * from db1 where @filter go but failed! i tried EXEC( select ), but i cant get the variants when building a oledb consumer No, you cannot pass the whole WHERE clause as a parameter. You could pass only values. In your case if this is predefined set of the t ...Show All

• SQL Server for loop container to process all Excel files

     I'm having a problem getting the for loop container to process all excel files in a folder.  I set the collection folder to where my .xls files are, and i set a variable in the for loop container to the FileName.  I then changed my source connection and added expressions for ConnectionString: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @[User::FileName] + ";Extended Properties=" +  @[User::ExtProperties] (the ExtProperties was necessary to get the double quotes in.  ) ServerName: @[User::FileName] It cannot connect.  I used a similar process to loop thru Access .mdb files, but did not set th ...Show All

• Visual Studio Express Editions Same or Different? Visual Basic 2005 and Visual Studio 2005

  Still being relatively new to the whole VB world I am confused by something. Is Visual Basic 2005 and Visual Studio 2005 the same thing or different animals all together The reason I ask is, I have checked out some books from the library, I'm trying to teach myself this stuff. One of the books I got was Mastering Visual Basic 2005, where I thought I was getting something for Visual Studio 2005. If the two programs are different, then I don't want to waste my time reading/using the book to learn VS 2005 (actually I'm using VS 2005 Exp Ed). So, what’s the answer Thanks, IF hi, i didn't see ...Show All

• Windows Forms convert object[] to ArrayList? (C#)

  Is there way to convert  object[] coll  to ArrayList Maybe somebody knows <i>> as far as I know the array doesn't implment System.Collections.ICollection ... </i> Yes, it does. So you can just use: object[] o = ... ArrayList a = new ArrayList(o); ...Show All

• SQL Server Error Output for a Destination Transformation

  I am developing a custom destination component and I have encountered a few areas where there seems to be a lack of helpful documentation and examples. 1. I have not been able to find any information on or examples of creating custom destinations with an error output. The OLE DB Destination has an error output so I investigated the input and error output properties in the advanced editor and found that the OLE DB Destination error output is synchronous with the input (its SynchronousInputID matches the input's ID) and has its ExclusionGroup value set to 1. Using this information, I modeled my error output after the OLE DB Destination. Pr ...Show All

• SQL Server problem with ICommandText, a single ' becomes double

  in my case, i use GetCommandText to get the default command text, then add a 'where' clause, like follow. TCHAR buff1[100]; TCHAR buff2[500];// what is the max length of a string   is ther any MAX macro pCommandText->GetCommandText( &guid, buff ); _tcscat_s( buff2, L" where id='" ); // i add a single '  just after '=' _tcscat_s( buff2, buff1 ); //initial before and trimed, no ' in it _tcscat_s( buff2, "'" );//use a ' to close the string in sql mydb.Open();// it returns S_OK...but !!! i traced the command executed in sql server2000, and the actual command it excuted was: select * from mydb where id=''01'' one ' become two ...Show All

• SQL Server Encryption and recovery on standby machine

  Hi there, to follow on my question in the other forum, I have a database with triple des encrypted columns Master key created, certificate and symmetric key using certificate. Values inserted into table (encrypted) Can select etc, all works fine. Back up and restore database on another server, decrypting the data results in NULLs being returned. Backed up and restore the master key, cerficate, etc but either it completes successfully or SQL states that the old and the new keys are the same and wont be changed. Master key opens (using password), cert opens (is viewable in sys.openkeys) but then closes automatically after trying to ...Show All

• Visual Studio Express Editions Exception error on all programs I build now...

  I'm getting the following exception error on Windows 2000 machines now. I wasn't before, and I don't know what I changed. See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at System.Windows.Forms.Control.WaitForWaitHandle(WaitHandle waitHandle) at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous) at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args) at System.Wind ...Show All

• Visual Studio Team System Deleting Team Project

  Hello, I have created a Team Project and later i deleted using TFSDeleteProject.exe . It showed "deleted successfully" from command prompt but it did not remove from the Source Control explorer. When i connect to Team Foundation server , in the project list it does not apear but in source control explorer it does. Can anyone tell me what may be the problem Thanks in advance. Do you have "Show deleted items" turned on in "Tools" -> "Options" -> "Source Control" -> "Visual Studio Team Foundation Server" If so, this is expected. There is no permanent &qu ...Show All

• Windows Forms Verisign Certificate unavailable in Store

  Greetings: I've purchased a Verisign Class 3 certificate for code signing. We've used it for deploying Win32 applications. If you right click on the installed certificate is states the following: Ensures software came from software publisher Protects software from alteration after publication 2.16.840.1.113733.1.7.23.3 I would like to use this certificate for deploying a VS2005 C# project. I understand that what I have is a PKCS7 and VS2005 requires a PKCS12 (a .pfx file). If you check out this thread ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=81494&SiteID=1 ) you can see he had the exact problem and us ...Show All

• SQL Server how to copy a table from one database to another

  Using ado & VB, how does one programatically copy a table from one database to another cnn1.open 'source database cnn2.open 'destination database cnn .execute sqlstatement 'use which connection I would rather do that on the server than on the client, doing something like a statement -If the table exists: INSERT INTO Database.Owner.TableName ( col1, col2 ) SELECT col1, col2 FROM TableName -If the table does not exsist: -If the table does not exist: SELECT col1, col2 INTO Database.Owner.TableName FROM TableName HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Inspecting the DataBindings property

  I am trying to discover the properties of the components on a Form using automation, and all goes well until I get to the DataBindings property. It displays as a System.Windows.Forms.ControlBindingCollection. I can get ahold of this object and get its BindingSource, but I cannot figure out how to get ahold of the BindingSource.DataSource. I know it's bound to an object and I can see the correct object in the debugger, but when I call BindingSource.DataSource.getType(), I just get a System.RuntimeType object. So, is there an easier way to introspect the properties of DataBindings, and if not, how can I discover the type of the object boun ...Show All

• SQL Server Force IS to use column headings

  Hi, I've got an IS package which reads a lot of records from a text file and loads that into the database. The text file has column such as Firstname, Lastname, phone number etc and same as the database table. The problem: IS works fine if I have the text file columns in the same order as the database columns but for example if have phone number in the place of firstname (in the text file) IS puts the phone numbers as firstname in the database and moves all the columns dow the order. Is there anyway I could force IS to use the heading names in the text file and put it in the appropriate database columns Thanks guys... ...Show All

• SQL Server Looking for Vedio Training

  Any online vedio training for SQL Server 2005/2005 Express available It's just a faster way to learn new features. Thanks I'm not aware of specific training videos.  There are, however, many on-demand web casts available for SQL Server 2005.  Have you looked at any of these For a listing of web casts, see   http://www.microsoft.com/events/AdvSearch.mspx EventsAndWebcastsControlName=As1%3AAdvSrc&As1%3AAdvSrc%3AAudienceID=0&As1%3AAdvSrc%3AProductID=9f07f9cc-c308-4ebf-a4e9-2b8530ab1ea8&As1%3AAdvSrc%3AEventType=OnDemandWebcast&As1%3AAdvSrc%3ACountryRegionID=en%7CUS%7CUnit ...Show All