raveesh's Q&A profile

• SQL Server Need to find which stored proc deleted data from a table

  Hi, I have a application in which there are a couple of stored procs . I need to identify which stored proc deleted data from the table A . I tried to find out this from the transaction log by running DBCC Log & :: fn_dblog function. But i was not able to findout the object_id for the stored proc. Is there a way to fnd this out I don't want to use any auditing mechanism. I mean, i should be able to identify the stored proc which deleted data from the data provided by the SQL server. TIA Thanks David. I agree with you. I told my client that the we can't track which Stored Proc has performed the delete unless there is auditing in place as transaction log w ...Show All

• Windows Forms How to sort a datagridview by two columns

  Most of you are probably familiar with Windows interface. I need help with sorting my datagridview which has the same idea with what Windows Explorer does. When you choose to "View -> Details" then if you sort by "Type" Windows will sort by type and also it will for each type sort by name Example :   Filename                                   Type         (Sorted By FileName) aFile.mp3                       &nb ...Show All

• .NET Development Timeout expired. the timeout expired prior to getting the connection from the pool.

  Hi, I have developed a web application which works fine but sometimes the web applications hangs with the following message Timeout expired. the timeout expired prior to getting the connection from the pool. The application is developed in .net framework 1.1 and is running on IIS 6.0 . The database is oracle 9i. We are using Enterprise library application blocks for maintaining the database connections. So ideally connection leaks should not occur. This error occurs when a new user tries to log in to the application. I am not able to find any solution regarding this problem. Help regarding the same will be greatly appreciated. Thanks, Anzrul Thanks Chitrsen, But we are using Microsoft ...Show All

• Visual Studio Express Editions relays...

  Could someone point me towards some material on programing with the serial port or if someone saw a post on a site like hackaday that uses serial port programming. I am trying to be able to control 4 relays (or i can start with 1) over the serial port. or usb, you decide what the best thing would be to use. Thanks to all the people who post on msdn forums.. Average Joe how do you set the state of the pin what is the line of code you must place in a event . thanks alot for a reply Averagejoe ...Show All

• Visual C++ C4448

  Visual C++ v8.0 (Visual Studio 2005) Warning C4428 The compiler issues warning C4428 when compiling the following program: #include <windows.h> #include <stdio.h> #include <tchar.h> int _tmain( int , _TCHAR*[]) { // The statement below raises warning C4428 in VC 8.0 but not VC 7.1. // There is nothing wrong with this code. // See sections 2.13.4 and 2.2 of C++ Std (ISO/IEC 14882:1998). // A universal-character-name is a valid s-char. wprintf (L "\u00a1Hello!\n" ); return 0; } This seems to be a compiler bug. The help text for the C4428 warning is: The compiler issues C4428 when it detects at least one universal character name in a source co ...Show All

• Visual Studio Express Editions problem:update datagridviews in master details application

  I've created a master/details application by vb2005 and access: choosing un item in listbox, relative data are displayed in datagridview. Problem:a cell loses the value inside and replace it with last put value. example: in listbox I've 2 item: A,B (id_padre) datagridview has 4 columns:id_figlio,id_padre,nome_figlio,cognome_figlio where first and second are readonly. I select A in listbox, I put some data in datagridview and so I have: id_figlio| id_padre| nome_figlio| cognome_figlio| 0 0 0 0 1 0 1 1 2 0 2 2 I select B in listbox, I put some data in datagridview and so I have: id_figlio| id_padre| nome_figlio| cognome_figlio| 3 1 5 5 4 1 6 6 5 1 7 7 If I select A now , datagridvie ...Show All

• Visual Studio Team System Team Suite Software Developers & Database Professional

  Our 10 developers are all using Visual Team Suite for Software Developers. We are also using Team Foundation Server for source control. All 10 developers are responsible for maintaining various pieces of our database schema. Once Database Professional is released, will we have to purchase 10 copies of it if we want all 10 developers to use it Thanks Amos. There seems to be a pattern forming here! I understand that MS want to release this as a separate team system edition (which is fine, considering the extra tools it provides), but I don't think it's the same as e.g. Team Architect, as the architect will do their own diagrams etc without any other intervention, but the suggestion that one person will be ...Show All

• Visual Studio Express Editions VB vs VBA Performance

  Hi, I am new to VB, trying to learn my ways through VB Express. I have an application like this: 1. open an Excel file - the file contains about 6000 rows/25 columns, mostly text - it's a dump of a requirements database. 2. Go through each row and do something with 1 or 2 cells - like add strings, remove blank lines, etc.. 3. save the file and exit. I work mostly in VBA macros and the performance has been acceptable. But when I switched to VB Express I noticed it takes a lot longer - minutes as compared to seconds. Here's an approximate execution time comparison: 1. VBA macro running from Excel = 5 seconds 2. VB Express = 2.5 minutes Without giving out too much detail, is this kind of performance hit expected when work ...Show All

• Visual Basic Change the Description Field

  I was looking at a program I made and I see that the program's name appears twice when sitting in icon view. But then I figured out that it is a part of the description so I'm trying to change that part of the file. I did find the Application Pane and the assembly info but that description doesn't change what is shown in view folder. Anyone who knows how to edit that field please let me know. Thanks, Jeff ...Show All

• Visual C# Copying a content of ArrayList to another ArrayList

  Hi I have an ArrayList. I want to copy the members of the ArrayList to another ArrayList in the Ctr of a certain class. The thing is, when I copy the content of the first ArrayList to the second one, every change that I make in a member from the second ArrayList also changes in the first ArrayList. How can copy the content of the ArrayList to a different ArrayList so each of them will be independent Or is there a better way to do that Ok I understand your answer exept from the "implement the ICloneable interface" part. Inside the first ArrayList I have objects from a class that I created - the base class of all the classes inside of the ArrayList are from an abstract class. I implemented the interfac ...Show All

• Internet Explorer Development Res://ieframe.dll/dnserror.htm#

  I am having a problem with the following website:-  www.hi5.com  . While trying to visit this website I get the following error Res://ieframe.dll/dnserror.htm#   I am running IE7, I have been able to visit this website since installing IE7, the problem seems to have just occured recently.   Can anyone help   I started notcing this error after I upgraded to IE 7. I do not think it is a network issue, because while the problem occurs, I can ping external sites. Yet I cannot even open up my DLS Modem's admin page. I also cannot use Netscape when this problem occurs. And the solution is always to re-boot my computer. I think the upgrade ...Show All

• Visual Studio 2008 (Pre-release) sample service doesn't work on Windows XP 64

  Hello, I tried to make a windows service that hosts a WCF service. Naturally, I've tried the sample first. It crushes raising an error: System.ServiceModel:Incorrect function at System.ServiceModel.Channels.SharedHttpTransportManager.OnOpen() at System.ServiceModel.Channels.TransportManager.Open(TransportChannelListener channelListener) at System.ServiceModel.Channels.TransportManagerContainer.Open(SelectTransportManagersCallback selectTransportManagerCallback) at System.ServiceModel.Channels.HttpChannelListener.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.DatagramChannelDemuxer`2.OnOuterListenerOpen(ChannelDemuxerFilter filter, IChannelLi ...Show All

• SQL Server If WCF can communicate with ServiceBroker?

  hi, I want tomake wcf and service broker communicate with each other,Are there some resources about that thanks in advance I did exactly this; created a set of channels and bindings for Service Broker. The reason for it was because we wanted to use WCF (obvious reasons) and needed a decent queuing mechanism (msmq didn't really make the grade). As it turned out, the story for creating a binding and channel for Service Broker was quite straightforward - at least addressing the very simple stories I had for it. ...Show All

• Smart Device Development "GetThumbnailImage" In Pocket PC Developement ?!!

  hello .. i want to use the method getthumbnailimage , but the problems is , it is not available in pocket pc developement , so what is the solution for this problem i really need an answer for that .. and for information , i am using VB .. with my best regard ,, Some cameras and/or applications create separate file with ready to use thumbnails, it might be what Resco is using instead of opening actual files. ...Show All

• Visual Studio Component and Serializable attribute

  In the MSDN documentation shipped with VS2005 the class System.ComponentModel.Component is not marked as having the SerializableAttribute. Can I assume this is an error in the documentation, as it seems impossible that components are not serializable Thanks for explaining this to me. You woke me up about run-time serialization, and have made it clear to me why design-time components themselves can not be serialized. It is appreciated. ...Show All