Elia Ardizzoni's Q&A profile

• SQL Server HELP! database restore using SQL Express

  I've try to do the database restore in Microsoft SQL Server 2005 Express using sql command as below: RESTORE DATABASE testJG FROM DISK = 'c:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Backup\JGsql.bak' GO But I get this error message. Msg 3102, Level 16, State 1, Line 1 RESTORE cannot process database 'testJG' because it is in use by this session. It is recommended that the master database be used when performing this operation. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Does this means that I need to restore the master database from systems database to the database testJG before I restore the backup database ...Show All

• SQL Server TOP 2 in a Cross Join (Matrix)

  Hello I have to retrieve a cross join between languages and language-skills for more person in a matrix (grid) report. E.g. i like to ritrieve the TOP 2 people in each "cell" of the grid (order by name). There are 3 people in cell "ITALIAN / very good". So i have to retrieve only the top 2. In table tEmployee i have the people names (john, anna, michael) In table tLanguage i have all language (english, italian, german) And in table tLanSkill i have the language rating (bad, good, very good) bad good very good Englisch Michael John Anna Italian John Michael Anna German Anna THX for your help. ciao, michele ...Show All

• .NET Development Windows Service and .Net Remoting

  I have a Remoting server that hosts 3 object and uses TCP channel. When the server runs as utility the TCP Clients are able to connect and access the methods of these objects BUT when the server runs as windows Service the TCP Clients do not have access to these objects however, the server is still listening on the port opened by TCP channel. Any suggestions Thanks No there is no timer in the server. Server uses TCP Server channel for hosting 3 objects: singleton,singlecall and CAO. The application name for all three of them are coming along with port number are coming in from app.config. All clients uses tcp client channel for communication. Thanks Parag ...Show All

• .NET Development Caught between a lock...and a hard place.

  Greetings .Net Gurus! I am writing a Windows service in C#. This service performs several related tasks. I have broken up the tasks into 2 different classes that I want to run in thier own threads. This is all fairly straightforward. The question I have revolves around how I update the text file that is logging various information for the service. I did a little research, and what I have come up with uses the Lock statement around the code that updates the text file. The object that I am using in the lock statement is declared as a public static object in a third class that is accessable by both the worker classes. If I have understood what I have read correctly using the object from the 3rd class will keep me from having any content ...Show All

• Visual Studio 2008 (Pre-release) Loading Image file problem

  Hi, When loading large image file( not too large), I got Debug message and program shut down. I cannot run any program that call image file. Like that <ImageDrawing Rect="0,0,100,100" ImageSource="Blue hills.jpg"></ImageDrawing> Please advice me what the problem is it. EW Please verify that the date stamp of WindowsCodecs.dll and milcore.dll (in %windir%\system32) are the same. If not, then please uninstall .NET Fx 3.0 and uninstall WIC (follow instructions here: http://blogs.msdn.com/rwlodarc/archive/2006/05/25/607131.aspx ). ...Show All

• Visual Studio 2008 (Pre-release) Grid and StackPanel Layout Mystery (bug? nuance? feature?)

  Drop this into XAMLPad and it will produce just what I would expect: · A yellow textbox of height 200 stacked on top of the white textbox taking up the bottom of the screen. · When the app (DockPanel) is resized, the yellow textbox (hosted in the grid) does not change size. The remaining space allocated to the white textbox changes size the DockPanel is set to LastChildFill. <DockPanel LastChildFill="True" Background="Red" Height="Auto" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"> <Grid Height="Auto" DockPanel.Dock="Top" Background="B ...Show All

• Windows Forms how to erase item on listbox

  Can anybody tell me how to remove the item on listbox I want to do when I select an item and click Delete button, then selected item removes. The code is something like this; private void AddButton_Click(object sender, EventArgs e) { listBox1.Items.Add(textBox1.Text); textBox1.Text = ""; } private void DeleteButton2_Click(object sender, EventArgs e) { listBox1.SelectedItems.Clear(); } When I test DeleteButton event, it seems to remove successfully, but the item still exist. I appreciate your tip. Thanks. foreach(object obj in listBox1.SelectedItems) listBox1.Items.Remove(obj); Wouldn't work as the enumerator is bound to t ...Show All

• Visual Studio Express Editions Making a textbox into an array and reading from each point in the array

  I'm trying to build a name generator, that takes a letter from one point in an array, (Which originally comes from a textbox), and changes that letter to some other character. So for instance, if i put the name "Sam" in textbox one and clicked the "Generate" button, the out put, (Which has random keyboard typings of each letter, like S as "Ess" or "$") would go to textbox 2. So basically i want to build a name generator for The "Leet" or "L33t" Language. What i need to know is: 1.How to assign the Data of Textbox1 to a String array 2. How to read from each point in this array and 3. How to set the output to go to a certain point in an array for textbox2. Any help would be greatly ...Show All

• SQL Server i think i'm in the same ball park. Database not found !

  1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file. Are these two files created here : C:\ProgramFiles\MicrosoftSQLServer\MSSQL.\MSSQL\Data\AdventureWorks_Data.mdf If so i'm missing the AdventureWorks_Data.mdf file Or am i it installs it to the corresponding instance's directory so for my machine the AW files are installed to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data . To use the files simply attach a new database pointing it to the AdventureWorks_Data.mdf file. ...Show All

• SQL Server SSIS Higher Level Edition error when run in a Sql Job

  Hi, I am receiving the following error in Sql Job agent when I try to run an SSIS package : The task "Create Excel File" cannot run on this edition of Integration Services. It requires a higher level edition. It then goes on to tell me : The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. I have tried reseting the error count to allow for the "errors" , but it stills fails. The job suceeds in Visual Studio, but not when scheduled in Sql Management Studio. Any suggestions Thanks, J. Here are my versions locally: VS2005 - 8.0.5072 ...Show All

• Visual Studio 2008 (Pre-release) enabling metadataSupport behavior via code

  I am emplementing a WCF service via c++/cli and hooking it into a legacy application. So far so good except that I can't seem to find the proper interface for enabling the metadataSupport behavior via code instead of a config file. Am I missing something obvious I am sure that you already noticed that metadata support has changed in recent bits. You can read about it e.g. here . The code listed below was written on June CTP and also works on July CTP. Ok, just C# code, but you get it... To enable HTTP GET WSDL retrieval, do this: ServiceHost sh = new ServiceHost( typeof(ITecTv), new Uri("http://localhost:7777/tectv")); ServiceMetadataBehavior smdb = new ServiceMetadataBehavior(); smdb.HttpGetEnabled ...Show All

• .NET Development How to detect if an exception has been thrown

  I need to know if in my current thread an exception has been thrown, is there any elegante way to know this I need to add that code to my RollbackTransaction method, I want to know if there is no transaction in the TLS cause something failed previously. Can't you define this by the responsibilities/conventions of you components e.g. ensure that DataComponents do not rollback only throw allowing the business component to manage the transaction I take it this isn't a .Net transaction othewise you tell from the transaction object whether its been rolled back e.g. if (transaction.TransactionInformation.Status == TransactionInformation.Aborted ) { ... } Duncan ...Show All

• Visual C++ faulted while dumping object

  Hello, I' ve added #define _CRTDBG_MAP_ALLOC #include <stdlib.h> #include <crtdbg.h> in the "stdafx.h" Header and "_CrtDumpMemoryLeaks();" in my program. If I run and stop my program, I got the following error message in the output window: "Detected memory leaks! Dumping objects -> {62} client block at 0x003B3358, subtype c0, 64 bytes long. faulted while dumping object at $003B3358, 64 bytes long Object dump complete." If I set a memory breakpoint at that memory allocation number, the program doesn't break. Has someone an advice, how I can identify the memory leaking object Is it always the exact same adress Otherwise on the next run the leak might be ...Show All

• Community Chat Secure Data Organizer - A Free Password Manager Written in .NET 2.0

  Hi all, I've been working in .NET ever since the pre-RTM 1.0 release for my Master's Thesis. I continue to code in many languages but have been working on a pet project on the side called Secure Data Organizer. This is a free program that marks the culmination of several years of design and effort .It is a Password Manager but was designed to be the best one out there. Ease of use (even at the expense of developer pain) was a driving development principle, as was native and intuitive GUI, human-readable XML file format, and public disclosure of encryption algorithms and techniques. I released it as freeware to the web back in late November. Since then, we've grown to over 1,300 registered users--a nice starting userbase! Our big b ...Show All

• Visual C# Debug Deployment taking forever

  I am deploying my app to a Windows Pocket PC 2003 Device. When I deploy its taking close to 10 minutes to deploy. The app is only 104K on my device. I noticed that it is hanging specifically on these files: System.Data.dll System.Windows.Forms.dll System.Web.dll System.Design.dll System.DataOracleClient.dll (Im not even using Oracle) Then these files are also being transfered and popping up a msg box stating that "Windows SQL Server Mobile is aready installed. Do You wish to reinstall [Yes] [Cancel]" sqlce30.ppc.wce4.armv4.cab sqlce30.repl.ppc.wce4.armv4.cab sqlce30.dev.enu.ppc.wce4.armv4.cab I don't think these files need to be transmitted everytime to my device as they are already there. Does anyone have any ideas how to speed ...Show All