ziffy_amit's Q&A profile

• SQL Server How to copy database stucture online

  Hi! I have to add a new functionnality in our Web application but i have no idea how to do it. What i have to do is to allow user to create a copy of the BD currently use and to save it on a new name. What i need is only the structure not the data. I need to copy all table, view, function and stored proc. I have no idea where to start. I found on this forum post where it says to detach then copy and the attach the BD but i can't do to this because i don't want other users on our web application to lost the connection with the DB. So was is the best way to do this Thanks !! You can easily do that by using SMO. Loop through the objects you want to duplicate and create a script for them. Afterwards ...Show All

• .NET Development WebBrowser control Memory Leak

  I created an .NET C#application to continuously creating and closing WebBrowser control for testing.  I noticed that my application memory usage has been going up per WebBrowser control. I looked though some user group, and saw that there is apperantly a memory leak in WebBrowser control. Here are my question: 1.  I would like this confirm if this is a known issue. 2.  Is there a fix or workaround available. Many thanks, Alice Hello, I have the same problem .The memory increase when the webbrowser control is navigating in loop. (When NavigatedComplete event happened it starts loading page again.Is there a solution for this problem ...Show All

• SQL Server storing values using a custom assembly

  I have a need to save a value or set of values that can be recalled for a calculation for each cell in a MDX query. Specifically I am trying to calculate the linear regression line over multiple days where the granularity of time is 10 minute periods. Using the LinReg functions in MDX perform very slowly. This is because the linear regression line is recalculated everytime the function is called, something that isnt necessary in drawing a trend line - calculate the slope and intercept ONCE and then use the slope and intercept to calculate the next point on the linear regression line. So, I'm not sure how to accomplish this using a custom assembly. If you declare the functions as static in the assembly, then you cant recall any member varia ...Show All

• Windows Forms compiling 2 projects

  hello! i am making 2 vb projects. i compile (build) the first project and everything goes right. it even created folder on program file's shortcut. now when i compile (build) my 2nd project, it also uses the same program file folder name . where can i change this thanks sir, i use build>publish then i select my publish program to install it into the computer. after installation of both program, the start> all program, both are using the same folder, i need to use different folder on both program ...Show All

• Visual Studio Is there a way to select a block of codes and execute in debugging mode?

  Hi all, It is great the Visual Studio Debugger has a lot of good features to improve productivity. I am looking for tips/tricks to improve my productivity and make coding more fun! Could anybody give me some pointers about down-to-earth practical tips/tricks about improving coding productivity Another question, is it possible to use the Visual Debugger in the following way: When stopped in debugging mode, I can select a portion of my code(several lines of the program), and hit a button or a key, to let the debugger execute that selection of code This is particularly useful when I change some portion of the code, or change some parameter values and want to immediately see what are the new results after the change. If you h ...Show All

• .NET Development Release bin doesn't run outside VS2005

  Hi, I have a pretty big project C# under VS2005. I work on it from 2 years, and from 1 year on VS2005. Since middle f this month, the release binary is not working anymore outside VS2005. I can still run my project from VS2005 in both Debug and Release mode. If I start the project outside VS, running directly \bin\myapp.exe then I have the usual dialog box (SmartCabNet has encountered a problem and needs to close ... blabla) In the Event Viewer\Application I can see: Faulting application smartcabnet.exe, version 1.0.0.5, stamp 459285ff, faulting module kernel32.dll, version 5.1.2600.2945, stamp 44ab9a84, debug 0, fault address 0x00012a5b. If I run \debug\myapp.exe then all is working fine. Note that the crash occurs wh ...Show All

• Visual C++ need help

  i have instaled Resident Evil 4 on my pc and after some time play game gives me Microsoft Visual C++ Runtime Error plz thell me what to do Hi, probably you have an issue with drivers Could be a version of DirectX or your graphics card isn't good enough to run the game.. It could be lots of things. You should contact capcom or view other forums to see if there's some problem with your version or any known issues with some hardware. PS: These MSDN forums are about programming/Visual Studio/.Net and other related stuff so, it's not the right place for this kind of questions. ...Show All

• .NET Development NotSerializable type used within remote method causes serialization exception

  Why is it necessary to mark a type serializable, even if it's only used within a remote method. This type doesn't appear in the interface of the remote class, and I don't want do send this type via remoting. A call like in the example below causes a SerializationException. example: public void DoSomethingViaRemoting() { NotSerializableObject obj = new NotSerializableObject(); obj.DoSomething(); } Is there any workaround to use not serializable types within a remote method ...Show All

• Smart Device Development How to display an image or text on top of a running video in media player

  I am trying to write an application that will display an image or some text on top of a running video in windows media player. Initially that can be a Window Mobile 5 pocket pc device. Ultimately, it will be set top box running Windows CE. But for right now I just need to get a demo running on a pocket pc device. ( I have read that the two platforms use a different version of the media player.) What we are trying to do is very similar to the task described in this posting: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=726409&SiteID=1 However, his posting was concerning writing a dsp plugin and windows vista. We have similar code on desktop application using a DSP plugin to windows media player. But I have also read ...Show All

• Software Development for Windows Vista Creating e-mail workflow on Visual Studio for SharePoint 2007

  Hello, I have a question – maybe on the page http://wf.netfx3.com/ are some code samples. I want to add a workflow to a SharePoint form library which can send e-mails. This e-mail consists out of an e-mail template and text from the form library. Example: In InfoPath Form library are different InfoPath Forms (XML Files). I want to start a workflow now on the form which generates an e-mail with text like: “Dear Mr. < name >”. Name comes from the InfoPath form. Note: At the end I want to develop this as a feature to make sure that deployment is on different SharePoint possible. So it is not recommend using SharePoint Designer. I have to take Visual Studio. Have anybody ideas or examples If I ...Show All

• SQL Server Insert Into with Duplicate Filter Check on Destination Table

  Dear friends, I keep getting "The column prefix 'Item' does not match with a table name or alias name used in the query" when running this query. INSERT INTO item (Notes, [ExtendedDescription],[Description],ItemLookupCode) SELECT notes, [Ext Desc], [Desc],ILC FROM TEMP Where TEMP.ILC <> Item.Itemlookupcode What is wrong with using the where clause as such What is the correct way to achieve the stated result in the query I just want to use the Where clause as a means to avoid inserting duplicate records into the item.itemlookupcode field. Thank you, Jack INSERT INTO item ( Notes , [ExtendedDescription] , [Description] , ItemLookupCode ) ...Show All

• SQL Server Cross assembly or cross domain calls not supported

  If I compile a simple .NET DLL with the following function and register it as an assembly in Analysis Services: public static int MyFunction(object o) { return 99; } When I run the following query I get an error which reads " Execution of the managed stored procedure failed with the following error: Cross assembly or cross domain calls not supported!. Execution of the managed stored procedure failed with the following error: Cross assembly or cross domain calls not supported!. Execution of the managed stored procedure CSng failed with the following error: Microsoft::AnalysisServices::AdomdServer::AdomdException. " with member test as MyAssembly.MyFunction(CSng("2.5555")) select test on 0 from ...Show All

• SQL Server How to use INSERT INTO.... SELECT FROM query to export MS SQL data in FoxPro 2.6 DBF

  Hi all, This is my very first post to this forum. How to use the INSERT INTO... SELECT FROM query to export MS SQL 2000 data into FoxPro 2.6 DBF file I want to write a VB 6.0 program, and already connected to MS SQL 2000 Database by MS SQL ODBC connection. Now I want to Export this MS SQL data to FoxPro 2.6 DBF. I found ROWSET option, but don't know how to use it for FoxPro. Please help me. Thanks in Advance. Regards, Rajeev Vandakar Hi Rajeev, If you want to just copy the whole table then Satya's idea is great. If you want to select specific rows then here's one way that works: Download and install the FoxPro and Visual FoxPro OLE DB data provider from msdn.microsoft.com/vfoxpro/downloads/updates. It works for all versio ...Show All

• Windows Forms inheriting from an existing Windows Forms control

  i want to create my control on top on an existing one, let it be DataGridView for example. Is the 'Inherited User Control' template right for me I am trying to use it, but if i pick on the System.Windows.Forms.dll as a source for a control i am inheriting from the only new thing appeas on the list is "System.Windows.Forms.UserControl" is this because DataGridView is not inside the System.Windows.Forms.dll or because that's not the right way of inheriting from existing windons contsols Brendan Grant wrote: Was my previous reply helpful Did itsolve your problem Have you found your solution elsewhere your reply was the very same i did when realised i can not use the inheriting template. i h ...Show All

• Windows Forms DataGridViewTrackBarColumn

  Hello all, I want to put a trackbar in a datagridcell of datagridview. The trackbar must be visible in both editing and nonediting mode. Is possible Best Regards Sandro Peixoto see this sample: DataGridView Custom Column Sample ...Show All