Jerry Povse - MSFT's Q&A profile

• .NET Development How do I get back the identity column value genarated by SQL server in my .NET code

  How do I get the value of the identity column genarated by SQL server in my .NET code. Here is my code: str = "insert into TblAccount(Name) values(@Name)" pm = cm.Parameters.Add(New SqlParameter("Name", SqlDbType.Char)) pm.Value = "whatever" cm.sqlcommand=str cm.ExecuteNonQuery() In the database, my identity column is "AccountNumber", but I don t know how I can get it back from SQL sever (I hope I m coding in a good practice) Thanks folks I would suggest using the SqlCommand.ExecuteScalar method. Such as: SqlConnection conn = new SqlConnection("Server=(local);DataBase=nort ...Show All

• Visual Studio Express Editions Retrieve data from Excel and store it in Access through VB

  Hi, I am using VB express 2005 to create an interface to retrieve data from Excel spreadsheet then store it into my Access database. I am able to retrieve data and store it in a dataset then display it in a dataGridView. But I am not sure how can i store the data into an Access database. I tried to connect VB to Access by opening a connection and then create a table in Access. I created a DataGridView and bind it to this table. I can do normal insertion, deletion to the table. But when i change the content of the dataGridView to my spreadsheet by writing some code then do the normal save as usual, the content in the ...Show All

• Windows Forms Change component icon

  Hi all. I hope this question is in the right forum. I've been playing around with developing .net components in c# and would like to know how to set the component icon that's displayed in the toolbox (instead of the default little gear). Thanks. Paul Sorry for the late reply, but I've been away. Anyway, thanks for the feedback Joe. Paul ...Show All

• Visual Studio Tools for Office VSTO download for students, beginners

  I searched a lot in MSDN to find an VSTO acadamic or express version. But the price range $799 is too much for students or beginners trying to be an office developer. Can Microsoft provide a version to the students, or lobbiyst so that they can use different features in VSTO. Is it possible to use the features like Excel object model, smart tages,action page, smart documents, xml usuage, COM, and deployment using any other less expensive tools. I myself, like lot of new learners, are really interested using new features of VSTO but pricing range is too high for students and new developers. I Mrus, The ...Show All

• Visual C# How to find a System Tray Process

  Hi, I'm trying to retrieve a process from the System Tray programmatically. My program starts the process and then saves the Process object. Later, the program tries to locate the process and bring it to the front (in focus). For all processes that do not reside in the system tray, I can do this with no problems. When I call AppActivate on a process that is in the SystemTray, the ArgumentException is raised. Does anyone know how to retrieve a process from the system tray Here is the code that brings the process in focus. The Process.Id is non-zero, but the Process.MainWindowTitle and Process.MainWindowHandle are undefined. ...Show All

• SQL Server SqlServer & Visual Studio

  For a new programmer, we set up the SqlServer Desktop engine on a PC and installed Visual Studio. The DB uses Windows Authenication for access control. The database was populated using backup/restore from a the desktop engine on a different PC. The programmer logs into the network using his own ID & password. In the Server Explorer window of VS, he can not create new objects (e.g. when right clicking on Views, the "add new view" option does not appear). However, if he opens the Enterprise Manager, he can create new views and functions, but these additions do not become visible in the VS Server Explorer. (It IS the same database; we ...Show All

• Visual Studio Express Editions Is The OOP Microsoft.VisualBasic.IIf Equivalent To the Procedural If Then?

  so I guess the thread was locked due to thinskinned vb'ers, unfortunately bronco has a fantastic question in his last post and it certainly warrants discussion. . . This Particular Microsoft.VisualBasic.IIf Is extremely important to me.... If Microsoft.VisualBasic.IIf is Equivalent to the Procedural "Classic" If then.... If it is Equivalent I can Transist to Pure OOP by using Descision Tables, Boolean Algebra and other CS techniques First, iif and If/Then have nothing to do with OO. Iif is a conditional assignment function . .. necessary because VB lacks a conditional assignment operator. if / then is typical ...Show All

• Visual Studio Express Editions RSS Screen Saver

  Ok so I want to change the default RSS link and the default IMG, how do I go about this You SUGGEST I do it at the bottom of the tutorial but provide absolutely no guidance on how to do it.. Whats up with that I've tried replacing the images in the resource file with new pictures but keeping the same file name, that did not do a single thing, // The images to display in the background private List < Image > backgroundImages; private int currentImageIndex; There is that in the code, but there is no explanation on what any of the variable means, nor how you edit them. This applicatoin is near useless to a new coder b ...Show All

• Windows Forms Another App Running in debug mode but not as an executable on a network

  When I run the exe off of a network drive I get this error: An unhandled exception of type 'System.TypeInitializationException' occurred in Unknown Module. Additional information: The type initializer for "Project_Track.Start_up" threw an exception. This is the startup module: Public Module Start_up Public FmainForm As frmMain Public frmSales As frmSRWO Public frmSearch As frmAddress Public Conn As New OleDb.OleDbConnection Public SConn As New OleDb.OleDbConnection Public AConn As New OleDb.OleDbConnection Public PjVars As New ProjVars Sub main() Dim ConnDb As String Dim ...Show All

• .NET Development AppDomain.AppendPrivatePath Depricated

  I get a CS0618 that AppDomain.AppendPrivatePath is obsolete. The suggestion is to use AppDomainSetup.PrivateBinPath instead, but no matter how I set it, PrivateBinPath remains null. I am trying to update AppDomain.CurrentDomain after the domain is started. Is AppDomainSetup the correct way to go It seems this would only apply at creation of the domain, and I need to make this modification after the AppDomain has started. Thanks P.S. I don't know if I should post these questions here, or to the newsgroup or both. Please clarify. ...Show All

• Visual Studio 2008 (Pre-release) Where are those FAQs, etc?

  The following is from the read-first post: you should look at the Cider Wiki on Channel9 and/or search before posting. The Wiki has FAQs of all kinds (errors & issues, How Tos, walkthroughs, CTP release notes, etc), as well as hopefully some technical reference material. ---------------------------------------------------------------------------------------------------------- I'm not finding any How Tos, walkthroughs, etc, just the world's smallest FAQ (six issues). Am I looking in the wrong place Nick Yes the FAQ is small right now. The release notes contain a good list of limitations, ...Show All

• Windows Forms Can anyone provid any sample code to detect changes of datasource data

  As everyone knows that the dot net DataSet is disconnected  dataSet. I have to detect any changes of data source data in DB server. Can anyone provid the sample code to show how to detect the changes ？ I believe SQL Server 2005 supports this, otherwise, I don't believe it's possible to find out that the data has changed without asking for it.  The best you could do is probably a trigger that writes a 1 to a table to let you do an inexpensive query to find out if the data has changed before asking for it. Well, that's my opinion anyhow, it's possible there are better methods that I don't know about. ...Show All

• Visual Studio SUPPRESS DUPLICATE NAMES

  I have a Crystal report with 700,000 records. I grouped this by fields "PROCESS"  and "OPERATION". Under the Grouped Operation field there are many duplicate numbers such as 10 or 20. I want to suppress the duplicate numbers and only show each distinct number once for each Grouped Process & Operation. Example: Process     Operation LEFC710     10 LEFC710     10 Process     Operation LEFC730     10 LEFC730     10 LEFC730     20 LEFC730     20 LEFC730     ...Show All

• SQL Server Version Control for Stored Procs, Views, etc.

  Does VS SourceSafe provide version control / tracking for stored procs and the like If not what can I use besides a manual log Database Hi, Of course it does. Source Safe can handle any files. But you have to handle the check outs etc manually via SourceSafe, it's not integrated with QA or other tools. Regards ...Show All

• Visual FoxPro Reindexing a free table in .NET

  I am responsible for a set of VFP Free Tables used for storing client information.  The front end for these tables has been created by a third party, however, the system is problematic and the index becomes corrupted on an almost daily basis. I am currently looking at a way of reindexing the tables on a nightly basis, as part of a scheduled application.  One slight snag, I'm a C# developer, not a VFP developer. I have downloaded the VFP Toolkit for .NET and can find no method for re-indexing.  I would be grateful for any advice anyone can give me regards libraries or functions availible to reindex the tables. Thanks, Kian R ...Show All