Jay_Vora_b4843e's Q&A profile

• Windows Forms Datagridview Update problem

  I have created a datagridview by dragging from a datasource "Users" in Visual Studio 2005. On it I have set a column called "password" to invisible so passwords are not shown, and I have created a button column for resetting the password. In the button click event, I use an InputBox to get a new password and write it to the gridview column. All is okay. I even experimentally set the column as visible and can see that the value is correct from my inputbox. Then I try to update to commit it to the database, and exception is thrown. Please help Exception: An unhandled exception of type 'System.InvalidOperationException' occurred in System.Data.dll Additional information: Update requires a valid UpdateCommand when ...Show All

• Windows Forms How to Stop Hiding Menu Items?

  Hi, I have a scenario wherein i need to add couple of menu items to the menu when a existing menu item is clicked.I could able to add the menu items,but the problem is the menu closes or hides because of the click event.But i dont want this to happen and i want the menu items to be visbile. Is there anything i could do to stop menu items being closed or hidden on menu item click Thanks, Suresh. You can also add a single item to your menu-item to make it a sub-menu. Then rebump the list once the menu_item dropdown event is fired. ...Show All

• Internet Explorer Development Customizing Toolbar in IE7

  I am having a small problem. I have TWO search boxes on my browser.. One for Google toolbar, and the one that was originally there on IE7... I set my default to google. I cannot find how to get rid of the original search bar (to the right of the address bar) and just keep the google toolbar search box.. There is no option that I can find to just have the top row be an address bar..Any suggestions.. I cant even tell google toolbar to take away its search box, it is automatic.. It is ridiculous to have TWO search boxes on the toolbar.. Anyone know a way I've tried everything I know.. Thx JP If you ask me, you get less options with the new, and not being able to remove stupid features (search bar)  ...Show All

• Visual Studio Tools for Office Outlook Add-in : best way to deploy minor/major updates after using setup project?

  If I initially deploy my Outlook add-in using the setup project (to test for prereqs, grant security and create registry entries), what is the easiest way to deploy minor updates Do I just need to over write the assembly and application manifest files on the target machine What if I want to use the Publish wizard Can I mix the deployment methods in this way or is there an issue with the fact that the publish wizard creates subfolders for updates For more major updates where I need to uninstall the add-in via add/remove programs, how can I code my setup project so that it uninstalls any existing versions of the add-in before trying to update the new version Thanks, Tad Hi Tad, Yes ...Show All

• Visual Basic Saving TreeView Changes to Database

  Hi all, I have a treeview control in a VB.NET 2005 form that shows item category/subcategory, so root elements are all categories and child elements are all subcategories. I pull the data off the database using code (no wizards), actually from two different tables. The user can add/change categories and subcategories. No deletions are allowed, user can only mark them inactive. To tie the categories to the subcategories I use a relationship between the two tables of the Access DB. That all works perfect. My question is on how should I save the changes back to the two tables. What would a good practice be I thought I could delete both tables (categories and subcategories) and traverse the treeview to save record by record but I do ...Show All

• Visual Studio Express Editions Totally new to programing and having problem with data tables

  Hello, please bear with me I have very little programing experience. I dowloaded visual basic 2005 express and all of its goodies, I'm following the lessons and I up to edit, deleting, saving data in tables, I followed the instructions but when i change or add data to the table in the runtime and click the auto created save button end the runtime then rerun the program nothing has changed in the table here is the code Public Class Form1 Private Sub Table1BindingNavigatorSaveItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Table1BindingNavigatorSaveItem.Click Try Me .Validate() Me .Table1BindingSource.EndEdit() Me .Table1TableAdapter.Update( Me .Database1DataSet.T ...Show All

• SQL Server Install SQL Server2005 Error

  Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Nothing on this yet I am fustrated for I am trying to follow some C# lessons that require for me to create SQL programs using SQL Express and I keep getting this error message. I ran the clean up utility they have in the SQL Express site but I still get the same error. I am running Windows 2003 Server Edition and I am up to date with all the patc ...Show All

• SQL Server How do I Transfer an updated procedure to a live site?

  Hi, Whilst not new to online database and web design I'm relatively new to ASP.NET and SQL Server. Can you guide me in this final hair tearing problem. If I have a development system on my local machine and a live system on the web how do I achieve the following:- If I make a change to a local Stored Procedure (or add a new one) after testing how do I transfer the changes to the Live Site Similarly if I add/amend a field to the database how do incorporate that change on the live site I can't find any tutorials on this on the net (probably because I don't know which terms to use in my search) Thanks in advance The SQL statements to use are alter procedure [dbo].MyProc ...Show All

• SQL Server Creating a Yes/No field in SQL Server

  hi, i need to create a yes/no field in a SQL Server database table. I know that i could previously do this in Microsoft Access and i believe that SQL Server now uses Boolean(0 or 1) for this. Does anyone have any ideas as to how to convert these 0 or 1 to yes or no with a default of yes I am taking the output from this table and displaying in Excel as yes or no not 0 or 1. Thanks Hi, via GUI you can do that by navigating to the column properties and the default constaint, per script you can do that either during creation of the table (Although you will get a automatic name assigned to the default constraint) or by altering the table: CREATE TABLE #TempTable ( SOMEColumn BIT DEF ...Show All

• SQL Server SQL Express Import Using Transact SQL Statements

  I have SQL server Express. How can you import a database, using transact sql code, onto a server from your local PC. Attach Example: The following example attaches files from AdventureWorks to the current server. Copy Code EXEC sp_attach_db @dbname = N'AdventureWorks', @filename1 = N'c:\Program Files\Microsoft SQL Server \MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server \MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf' ; Restore Example: RESTORE DATABASE MyDatabase FILE = 'MyDatabase_data_1', FILE = 'MyDatabase_data_2', FILEGROUP = 'new_customers' FROM MyDatabaseBackups WITH FILE = 9, NORECOVERY; GO ...Show All

• Visual Studio Determining if a build configuration is set up to include DEBUG info

  I have build listeners that perform some actions before a build is performed. I would liketo be able to determine if the project that is being built is going to include DEBUG information with the dll. Simply checking to see if the active configuration name == debug is not sufficient for my needs. Is there a way to access this information from the automation model I think that this information should be stored in Configuration configuration = proj.ConfigurationManager.ActiveConfiguration; configuration.Properties But I cant seem to find an enumeration of these properties... Am I looking in the right place Does anyone have any info on this THanks a lot Russ Hi Russ, What sort of project are you dealing with here ...Show All

• Smart Device Development Pocket Pc Stops

  my progam works on a win32 console. When i port the same program to smart device ,pocket pc, the program stops on main(). I think main() needs to be changed. Any ideas so close, yet so far away !!! This is my last high hurdle, i hope!!! The rest should be minor cleanup. I rebuilt this machine and nothing changed. I tried using main, wmain, and tmain and the pc locked up at main. I tried changing the entry point, in the configuration fies and the computer locked up at main. I tried resume on main, nothing happened. The problem must be simple, I guess!!! I read a lot on threads. Main is thread one and starts automatically. Threads can be stopped and started, but i can not get main to start. By the way, for ...Show All

• Software Development for Windows Vista Passing Parameters to State Workflow

  Hi all, I think this is a simple question, but have been unable to find a code snippet: I have a state workflow, I pass some parameters via the event, (from my class derived from ExternalDataEventArgs).  Now how to I use and set these values within Code, Policy and If activities I have a lot of the samples downloaded and looked through this list and the blogs, but cannot find anything that provides an example. thanks Don For those other poor saps in my position: See either of these two blogs on how to create args to pass to the state workflow http://community.bartdesmet.net/blogs/bart/archive/2006/10/17/4584.aspx http://blogs.microsoft.co.il/blogs/bursteg/archive/2006/07/08/WF-Communicat ...Show All

• Windows Search Technologies OTP Windows Desktop Search 3.0

  Any ideas as to how you would remove Windows Desktop Search 3.0 Are you currently signed in as an administrator on your computer If not, please do so and let me know if that solves your problem. Sorry I didn't specify this earlier in the thread. Paul Nystrom - MSFT ...Show All

• Visual Studio Creating a non C# project template using GAT

  Hello, I need to create a custom project type. Like the database project. No "build" option etc, different icon... Any ideas Tom Hi Tom, GAT is not the proper technology to achieve this. You would need to use the Visual Studio SDK for this. It comes with a sample for creating a custom project type. -Victor. ...Show All