manidas's Q&A profile

• .NET Development Just first access, SerializationException: Unable to find assembly

  Hello, I have seen different flavour of this problem in different places, but as far as I concern none of them has a solution for it. I am using Remoting, .Net2.0, and C#. The server components are running as Windows Service. Whenever the service gets started (restart or install) Only the first access to the service throws the following exception. SerializationException: Unable to find assembly The subsequents access are working fine. Any idea why this happens Many thanks, Does anyone know why is this happening I have delete all the obj, and bin directories in entire solution, but no luck. For some reason after this problem appeared I am not able to debug the server side either. ...Show All

• SQL Server SQL express database + IIS

  hi all, i have implemented a program, that is divided into two parts, a window form and a website.  they both use the same database(SQL express). (the website is not meant to be published online, but on a local host) Everything works great, when i am in the VS enviroments. but when i publish the website the following happens: if i use the website first and login, thus accessing the database, even if i close my explorer , i can not use the window form (crash when trying to access the database). And if i try it the other way arround, use the window form first, and then try to use the website (while window form is still open only, and has already accessed the database) it crashes also.  In both cases ...Show All

• Visual Studio Tools for Office Is there a different in VSTO 2007 and VSTO 2005?

  Hi, I just want to ask whether there is a different between VSTO 2005 and VSTO 2005 second edition, such as some objects are available in VSTO 2005 and not in VSTO 2005 second edition. I was writing code in VSTO 2005 second edition and some objects or methods cannot be called and used. Thanks. Cindy Meister, your response was very helpful for me as I am trying to choose btwn VSTO 2005 and VSTO 2005 SE! An additional questions, if you don't mind. Can I create a complete dll from VSTO 2005 ...Show All

• SQL Server Remote update having a linked server takes forever to execute

  UPDATE CD SET col1 = SR . col1 , col2 = SR . col2 , col3 = SR . col3 , col4 = SR . col4 , col5 = SR . col5 , col6 = SR . col6 , col7 = SR . col7 , col8 = SR . col8 , col9 = SR . col9 , col10 = SR . col10 FROM LNKSQL1 . db1 . DBO . Table1 CD join Table2 USRI on USRI . col00 = CD . col00 join table3 SR on USRI . col00 = SR . col00 Here, I'm trying to tun this from an instance and do a remote update. col00 is a primary key and there is a clustered index that exists on this column. When I run this query, it does a 'select * from tabl1' on the remote server and that table has about 60 million rows. I don't understand why it would do a select *... Also, we migrated to SQL 2005 a week or so back but before that ...Show All

• Visual C# The correct way to Windows service

  Hi all, This is some kind of philosophy question. What is the correct way to build windows service And what exactly do I mean My WS (windows service) have timer and every 1 minute it execute method that need to do something. the method need to run on different thread, and it can be stopped during executing. So, Whet is the correct way using timer thread timer timespan and wait and how can I stop executing Hi, Why don't you go for a System.Timer You could provide the method that you want to be executed at regular intervals as the handler for the 'Elapsed' event of the timer object. You could set the 'Interval' property to 60000. The 'Elapsed' event will be raised for every expiry of the 'Inter ...Show All

• Visual Studio Toolwindow toolbar buttons enabling issue

  Hi, I have created a managed toolwindow with a toolbar having several buttons. I am handling the enable/disable and visible/hide of these buttons in my toolwindow code. All this works well when the focus is inside my toolwindow. As soon as I click outside (say on solution explorer window) all buttons become visible and enabled. Once the focus is outside of my window the status handlers for my buttons don't get called. Please let me know what could be the issue here, I will be happy to provide any further information. Thanks, Sandeep I found the issue here. I have to get the IMenuCommandService service from package instead of my window pane to add my commands. When the focus is not on my window ...Show All

• Windows Forms URGENT HELP - PRINT

  C# - Windows Application (VS 2005) - OLEDB --------- Hi, I have a network printer IP: 1.2.3.4 shared name \\ns\admin_print$ I want to use a button within a form to print out the details of the form (data is from database). When I clicked the button, it will print straight to the designated printer. I do not want to have a print dialog to select printer. I do not know how to start with the code. Can someone advise private void PrintReport() { } Hi David, thanks but that is not what I required. What I need is to define the printer source, i.e either by IP address or network share name. In a network, there might be a few numbers of network printers but I want this form or report to prin ...Show All

• SQL Server Custom Task and Reading Package Configuration

  Hello All, I have searched on this forum for a similar question but couldn't find it so I apologize if this has been asked. If so, I'd greatly appreciate a link to the question. I have created a custom task and am trying to read an xml package configuration file within my custom task. To be more specific, I have added an ADO.Net Connection to my database onto the package and have generated the appropriate tags within my package's configuration xml file. I'm not seeing the classes I should use to access the configuration file of the package I've created. Does anybody have any ideas how I can accomplish this or a link to a document that might cover the material Thanks! Jay_G Hello Kirk, Th ...Show All

• Visual Studio Team System Unit test results not getting copied to output directory (RTM)

  I have some unit tests that are aborting in the build. At the end of testing Team Build is attemtpting to copy the results to the output directory and it is unable to do so because another process has locked the file its trying to copy. This also has the affect that nothing for this group of tests shows up in the dashboard. Thoughts anyone Aborted (AutoBuild/)Sales.Symphony.Config.Tests.Models.SNPModelTest.GetLineItemsIntoBasketTest Aborted (AutoBuild/)Dell.Sales.Symphony.Config.Tests.Views.Systems.ModuleNodeTest.TestPropertyErrorAcknowledged 0/657 test(s) Passed, 157 Passed (run aborted), 17 Failed, 483 Aborted Summary ------- MSBUILD : warning : Test Run Error. The previous error was converted to a warning be ...Show All

• SQL Server Processing AS2000 Cubes from SSIS

  Hi All, I have a scenario where I want to execute AS 2000 Cubes from a SSIS package. In my Prod environment I have two servers one with the SQL 2000 database and the AS2000 cubes on it and the other with SSIS installed on it. What I am doing here is I have a DTS package with a process cube task in it, this DTS package is saved as a structured file and then I call this DTS package from SSIS using the Execurte 2000 package task. Just FYI the process cubes task is using local as the server reference. I want to know how this will work when I execute this DTS package from within an SSIS package running on a different server Appreciate all help. Thanks I've been thinking about this some more. A ...Show All

• .NET Development Which version is appropriate

  I'm an old Access Client/Server guy (for 10 years) getting into .NET and Web Development. I currrently have NO significant experience in either. Heck - I can't even spell WWW I'm getting ready to get tooled up and trained. I would appreciate a little info to make sure I make the right investment. The general forum referred me to this form for the Client Server question. Question 1 : I'm a little confused with the product name. I'm going to omit abbreviations to be clear. Is there a Visual Studio 2005 and a seperate product name Visual Studio .NET 2005 or is this two names for the same product If they are not the same - I ASSUME I need to get Visual Studio .NET 2005. Question 2 : If I want to create a Client Server applicat ...Show All

• Visual C++ 64-bit Portability issue

  conversion from 'INT_PTR' to 'BOOL', possible loss of data.....what is the best way to resolve this ...Show All

• SQL Server replace missing data

  I am working with a database containing time series data. In many, cases there is missing data. For example, while there might be a value for 2001-01-01T23:00:00, there is none for 2001-01-01T23:0100 (one minute later). I would like to replace the missing data with data from the previous record (if the previous record is the same date). Is that possible with T-SQL Missing means there is no record for a specific datetime value. There is no null because the record does not exist. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. game time

  hi all, in my main draw function of my game i call a function splash.Draw(gameTime); in the splash.Draw() function i have a line of code Console .WriteLine(( float )gt.ElapsedRealTime.Seconds); this along with every other member of gt just returns zero, i cant figure n e reason this should happen, if i call the same function in the main Update or draw functions of the game it still returns zero, is there a reason it should do this many thanks Hi, Do you have the Float elapsed =0; in the public What this is doing is creating a flot for the seconds total to be stored. When you are reporting you need do have a global variable to increment wverytime it goes into the update as it wil ...Show All

• Visual Studio Tools for Office VBA to SQL Server database

  Hi Appologies up front if the terminology in this question is not correct - I am very much a VB beginner - with grandious ideas. I am floundering around trying to figure out how to run a parameter query using VBA. I have already defined the query in Excel - Data > Import External Data > New Database Query) from Excel VBA The query accesses a SQL Server database It is working up to that point and uses a parameter from the workbook, and 2 parameters that it needs to ask the user for - I have this in the macro (VBA) I need to run the query from a macro attached to a button in Excel as I have some other work to do before it runs. Is there anyway that I can run this query from VBA or do I have to define the SQL et ...Show All