debdeep.guharoy's Q&A profile

• .NET Development SqlRowsCopied event in SqlBulkCopy + .NET 2.0

  Hi All, I'm using SqlBulkCopy class to copy the records from One table to another table. I want to count the no. of records copied during the bulkcopy. I tried with using SqlRowsCopied event, but it seems like the event will get trigger only based on NotifyAfter property i.e by setting a value for NotifyAfter. I dont want this to happen using NotifyAfter property, instead the event should get fired after all the records copied to the destination table. please share your ideas on this... Regards, Prabhu You are correct that the current functionality of SqlRowsCopied event does not allow you to recieve a notification only at the end without knowing the total number of rows that will be processed ...Show All

• SQL Server SQL Server Express 2005 Edition SP2 and Vb express 2005

  This is a question about the movie collection starter So here it is: I am running Vista RC1 (Build 5600) and vb express 2005 I downloaded and install SQL Server Express 2005 Edition SP2 - Since SQL Server Express 2005 Edition SP1 does not work with Vista But when I try to run the collection app or if I try to download and install the Amazon version I get the following error message: There was a problem loading data: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be cause by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Inst ...Show All

• Windows Forms UserControl custom property and UndoEngine

  Hello, I have a user control that has a custom property added to it. To make it simple the property is a bool. I have a basic implementation of UndoEngine that works fine. When I delete a control from the design surface, and then "Undo" that, the Control comes back just fine, but the custom property is back to its default state. I've done quite a bit of research on things but haven't come up with anything helpful yet, so I'm here for more assistance from the experts. I've played with the Localizable attribute for the property, but that doesn't work either. Thanks again for the help. Ken Hi, Without knowing your engine in detail, it is a bit tricky to say what's happening. Ma ...Show All

• Visual Studio Express Editions How would I go about putting my class libraries into a specific namespace?

  I know that in C#, we can enclose our code inside a namespace: namespace <namespace name> { class Customer { ... } } Let's say I want to have a top level namespace that indicates our department. Dept And then I want to have lower level namespaces to group our common library code. For example: Dept.TimeUtilities Dept.MathUtilities Is it possible to have two developers working on some code to add to the TimeUtilities namespace -- each working with different source code files For example, developer #1 works with: namespace TimeUtilities { class Time1 { ... } } And developer #2 is working on another source file with: namespace TimeUtilities { class Time2 { ... } } Does the definition and implementati ...Show All

• SQL Server Changing Service Broker Attributes of Device before restore using SMO

  Experts, I have the need to programatically create multiple databases from a single template database across multiple database servers. I currently do this by restoring a backup of the template database using SMO. Prior to the restore I relocate the database files and change the name. Recently Service Broker has been added to the databases and after the restore it fails with a duplicate service broker id. To make the database usable we need to execute ALTER DATABASE SET NEW_BROKER. Is it possible to do this programatically using SMO prior to the restore Thanks in advance for your assistance! This option is only available for the Database Attach option (see Server object). It should be a ...Show All

• SQL Server Incremental updates query not working for proactive chaching

  Hi all, I'm trying to set up Proactive caching on a large dimension with incremental updates. I have read all the info on MSDN and followed what seems like a straight forward process but am still having difficulties. I've enabled proactive caching on the dimension with the following settings... Update the cache when data changes: Silence Interval - 10 secs Silence Override - 10 mins Scheduled Polling: Polling Interval - 10 secs Enabled Incremental Updates - TRUE Polling Query; Select Max (DocumentKey) As MaxDocumentKey From DIMENSION_Documents Processing Query; Select DocumentKey, DocumentBaseTypeName, DocumentTypeNa ...Show All

• SQL Server Problem with distribution agent

  Can anyone help me on this I have a transactional replication going on from Server A to server B (Sql Server 2005) The replication was working well till yesterday.. But now, the replicated transactions are not getting applied at the subscriber. When I see the Log reader agent, its working fine...delivering the transactions to the distributor. When I see the replication monitor status ..it says 'delivering replicated transactions'...however the number of undistriuted transactions is very high..its getting bigger and bigger..not decreasing...I dont see any errors..So my guess is the distribution agent is not working eventhough its says 'delivering replicated transactions'..Other thing is if i see the replication monitor it says sta ...Show All

• Visual Studio Express Editions showing a table field value as a messagebox

  I just want to know how can I show a field value on a table as a messagebox Hi. Sorry, are you able to expand your question a bit more please for us to help out :-) Are you saying that if you have a datatable filled with data from some datasource, you wish to get a specific column/row value and display it to the user in a messagebox ...Show All

• Visual Studio Express Editions z-wheel events

  Hello, I am developing with Visual C++ 2005 Express Edition and I would like to know how to see z-wheel events of the mouse in order to change the focus of a component on my visual interface. That is to say, I have the focus on Textbox1 and when an z-wheel event come, the focus will pass at the Textbox2. Thank you for help. Best Regards. I assume you mean the scroll wheel. It generates WM_MOUSEWHEEL messages. ...Show All

• Software Development for Windows Vista DLLs in Windows Vista RC 1

  I am trying to maintain my Visual Basic 6.0 application in Windows Vista RC 1. In order to have all needed components available within the vbp References, I previously installed the application using its MSI package. Now I can see all components in the References window, Intellisense "feels" their properties and methods, but when I try to run my project any of these component can be created. Any suggestion Thanks in advance. ...Show All

• Windows Forms DataTable sorting

  I have a DataTable binded with DataGridView. I may provide my own sorting for DataGridView (via ICompare), but I can`t when DataSource property is used (and it is in my project). I would like to sort rows, when user clicks in the header of a specific column, but I don`t want the default sorting. Default sorting is like that: 0,1,11,12,2,3,4I want a numeric sorting: 0, 1, 2, 3, 4, 11, 12how to achive this Seems correct, thank you very much, but the problem now is, that I have the first column of type int , and the rest of the columns of type A. Klass A has method ToString() overriden to meet my personal expectations, that in specific situations returns empty string ( "" ). I also set datatype for ...Show All

• Visual C# Saving User Settings

  I'm writing an app where I need to save some inputs from the user. I cannot use the app.config method because the users will not have admin access on their machines. I've tried doing this through the Visual Studio IDE, but its still outputting the settings to app.config (I cannot even get it to read the settings back in). Does anyone know if there is a way in .NET to do this. My alternative is to write the code to do it and I was trying to avoid that. Thanks for your help! Mark, Thanks for your help so far. I did as you said, but it is still outputting the settings to app.config in the same directory that the executable is in. That's not going to work for my users because they won't have admin privileges plus this method only allows ...Show All

• .NET Development How to unregister a COM wrapped .NET assembly?

  Hi All, I created a COM exposed .NET 2.0 dll and registered with my Windows 2000 operating system using 'regasm' and 'gacutil' Then I tried to call this component from my classic ASP page. It worked fine. But, I need to change the functionality of my assembly. I unregistered it again using  'regasm' and 'gacutil'  utilities and copied my new .NET DLL and registered again.  But for some reason, i still have a pointer to my old assembly and new calls to the DLL from ASP page are not working. Any Ideas   I appreciate any help. Thanks     A common issue is that people don't explicitly assemblyversion. Then what happens is that every build produces a differ ...Show All

• Windows Forms Register your own file types, but how to set the default Icon?

  EDIT:  I figured it out myself...   YAY!!!   Here is how you register your own custom file type, and set your own custom Icon for it...  Woo hoo! You will need to have access to the registry, (user permission).  We will be writing 3 registry keys, and modifying some values.        Registry Keys:           [1]  Class name.  ( .yourextension )           [2]  DefaultIcon            [3]  Content Type  ( what kind of content is it   plain/text ) The first registry key is the actual name of your extension, including the dot.  This key will go u ...Show All

• SQL Server Database diagram support objects cannot... Attaching sql 2000 db to sql server 2005

  Hello, I've seen threads concerning this problem. I have followed the prescribed steps to fix the problem. I've set the db owner to sa, I've set compatibility to 2005. Still I can't get the diagram to function. Can anyone out there help me Thanks, Bill Hello Bill - Can you describe your problem a little more Are you saying that you have a 2K database that you've attached/restored/transported to 2K5 and you can't create a database diagram on it Thanks - Buck Woody ...Show All