Mukesh Joshi's Q&A profile

• Visual Basic Insert into db

  My problem is this. I have an insert statement and I create a sqlcommand object and executeScalar() to run the statement. Now I have to take the identity of that inserted row and put it into another table. How can I get back the identity off the newly inserted row   Thanks I think what you may be looking for is the @@identity http://www.sqlteam.com/item.asp ItemID=8003 So when you insert a record into the database - you can get the newly created Identity to use in another SQL statement. You can use this and wrap it up in a SQL stored procedure which enables you to execute a number of ...Show All

• Architecture Designing web apps in the enterprise

  Hi all, In my organization we have multiple web apps, each of them serving a different part of the organization. Because the vision is that all apps will be using the same infrastructure and might share information (pages and services), the original design of the web site was to declare a single web site (single virtual directory), and each of the apps will just be a folder in the site (meaning all apps will use the same iis application). Of course there is another option in which the infrastructure is built into usable assemblies (cache management, security utils ...) and each of the applications will have it's own virtual director ...Show All

• Visual Studio VS 2005 Final. Document Explorer crash.

  Every time I change the "Filtered by" combobox the document explorer crashes: "Microsoft Document Explorer has encountered a problem and needs to close". What is a problem Is there any suggestions I've already tried to install on several different computers, but the result is the same always - crash after changing a filter category or after search performing. ...Show All

• Windows Forms Another DataGridView Background Row Color question ....

  I'm writing a simple app which goes through a folder, takes each file thats in that folder, and sees if it's in a database. If the file is found in the db, then I do a DataGridView1. Rows.Add( False , file.Name.ToString, folder.Name.ToString, "kb" ) , which adds the file name and folder name to the new row and keeps it unchecked. If the file can't be found in the db, then I do a DataGridView1.Rows.Add( True , file.Name.ToString, folder.Name.ToString, "kb" ) , which is the same as above, except that the checkbox is column 1 is checked. Now, what I'm wondering about, is how to set the background color of the newly added row I've tried ...Show All

• Audio and Video Development Is the media foundation the suitable starting point for my app?

  Hi, I am trying to write an app that does the following: 1. Displays fullscreen the input to a composite video/audio input of a video capture device. 2. Realtime overlays audio peak data in a VU meter style. 3. Is able to play only left-channel and/or right channel information from the stereo audio feed. 4. Is able to show realtime some equalisation information of the audio stream. e.g. a variety of eq ranges from some FFT on the audio data. I am new to Vista programming, and have little C++ experience, though am happy programming c# and windows forms. I had to give up trying to do this with DirectShow in XP since I was una ...Show All

• SQL Server Deleting Database contents - Microsoft SQL Server Management Studio Express

  Hi I create a database in SQL Express using the Microsoft SQL Server Management Studio Express, with tables etc. I connect to it from my VB Express .NET application. Any changes I make, like adding a new table from VB .NET Express causes all the tables to 'vanish' when viewing the Database in the Microsoft SQL Server Management Studio Express, the database is still listed there. Does anyone know why Also it cannot be edited there again it gives an error Also if I create a DB in VB .NET Express the database does not appear in the Microsoft SQL Server Management Studio Express, which makes backups etc not available. It is saved to a dr ...Show All

• SQL Server temporary table and multi-part identifier

  Hi, I want to join a temporary table with a table in my stored procedure : CREATE PROCEDURE sp_DeltaabgleichDarlehen AS BEGIN SELECT Grundeinstellungen.Dat_Initialisierung, Grundeinstellungen.Dat_Jahresbeginn INTO #temp_IniDatum FROM Grundeinstellungen INSERT INTO DeltaDarlStammdaten (Datum, Vertragsnummer) SELECT ImpDarlStammdaten.Datum, ImpDarlStammdaten.Vertragsnummer FROM ImpDarlStammdaten WHERE ImpDarlStammdaten.Datum=#temp_IniDatum.Dat_Jahresbeginn END      i get the error : The multi-part identifier "#temp_IniDatum.Dat_Jahresbeginn" could not be boundfor example What is the problem and ...Show All

• SQL Server ReportViewer control

  trying to build a test page with a single ReportViewer control < rsweb : ReportViewer ID ="ReportViewer1" ProcessingMode ="remote" runat ="server"> < ServerReport DisplayName ="VSTestReport" ReportPath ="MyReports/VSTestReport" ReportServerUrl ="http: //pugrs/reportserver"/> </ rsweb : ReportViewer >   build fails with 401: Unauthorized. Not even sure where to begin troubleshooting this one. Any ideas Thanks! Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it ...Show All

• Visual J# Unable to load the J# Browser Control

  I've created an html page with ONLY the following code.... <OBJECT WIDTH="1024" HEIGHT="768" CLASSID="clsid:a399591c-0fd0-41f8-9d25-bd76f632415f" VJSCODEBASE="myfile.dll#_0" ID="Object1" > </OBJECT> where the dll file is named "myfile.dll" and the first class file is _0.jsl and each time I load the file into internet explorer the statusbar shows: "Unable to load the J# Browser Control in file file:///C:/temp/projects/myfile/myfile/bin/debug/myfile.dll " Hi, You need to specify the JBC class name along with the ...Show All

• Visual Studio Express Editions Default Comments Missing From Templates

  hi when i create a new console app, the default code is created, but not the default comments, such as /// <summary> unless i'm incorrect about this, how can i enable this thx There are no default comments for the Console application, however, you can simply add your own by typing /// at the top of the class/method/member you want to comment. ...Show All

• SQL Server Restored Database/Diagrams Support/SQL-Server 2005

  Hello, I have restored a database from SQL-server 2000 into SQL-server 2005 and when I try to install diagram support, I receive this error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. ------------------------------ Section 5.8.1 of the SQL 2005 Readme file says: The installation of these support objects ...Show All

• Visual C++ Reference dll

  I'am learning VB.NET and VC++. I created a dll in VC++, but VB.NET didn't recognize it as a reference dll. So my question is how do I make my VC++ dll, a reference dll try looking at: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconconsumingunmanageddllfunctions.asp     ...Show All

• Visual Studio Tools for Office Excel Data Binding Performance

  I just updated my Excel VSTO code to use data binding (via ListObject) to a DataSet. Prior to this, I was putting data into a 2-dimensional array and setting it to a range. Now the screen update is significantly slower. We often times will have large DataSets. In one example, I had a DataSet with 10,000 rows, and 20 columns (with floating point data). With data binding, it took close to 1.5 minutes (90 seconds) for the screen to refresh. When I set the range directly with a 2-dimensional array, it took less than 5 seconds. While I fully expect it to take longer with data binding, I really didn't expect it to be that much worse. Am I force ...Show All

• Windows Forms Mixing bound and unbound columns

  My DataGridView has a mix of bound and unbound columns.  I'd like the unbound columns to be calculated from the bound columns (like an Excel formula). What's the best event to handle for this   Right now, I've got it working by handling CellFormatting, but I have to special case the "New" row so it won't crash.  I'm thinking one of  ...Show All

• Visual Studio Team System No luck in installing TFS in a more or less single server installation. Different Error 32000's...

  Hi, I've been trying to get VSTF Beta 2 running for last 3 days with no luck. Always ending with different Error 32000's example: Error 32000.The Commandline '"C:\Program Files\Microsoft Visual Studio Enterprise Server\widbloc.exe" -s hostname -d CurrituckDB' returned non-zero value: 1. I have a Lab domain, consisting of 2 DC's running smoothly (and have been for well over a year now). No errors whatever if I use Netdiag or DCDIAG. Now I have a virtual server where I'm trying to install a "single server installation" while using the present lab AD. The virtual installation consist of the following: W2003withSP1 (Slipstreamed) IIS6 with AS ...Show All