tronix's Q&A profile

• SQL Server Updating a table from a text file

  Hello, I am not sure if this is doable using Transact SQL. I need to update a table from a text file. That is, for each line in the text file, I need to see if the data already exists in the table. If not, I need to add a row to the table for that line. Can this be accomplished through Transact SQL If so how can I do this Any help would be appreciated. Thanks, Dots Hi, get the data transferred in to a a temp table using either BCP or DTS then run the query for record exist , if yes put them in to another table and rest insert in the table you wanted. ...Show All

• Windows Forms How Form's location is decided?

  Hi All, Can anyone please tell me how form's position decided When Form.Show() callled................how does .net decide at which position form should be Thanks AndrewVos for reply./... Can you please look at my another thread regarding StartPosition of the Form......................I am not understanding why it behaves like that Thread was like this Hi All, I have one problem in Windows Forms. I have one form Win1. in that i have set startposition = centerscreen. Now I am calling it in another application. let's that application name is app1. app1 is called by app2 at runtime. and app2 is in another application app3.a ...Show All

• Windows Forms Events issue

  Hi, i have a shared WithEvents button on a form. now several forms have a reference to that button. mybutton = mainform.mainbutton and then each form has a mybutton_click method. so now all instances that are live are causing their mybutton event to occur if it occurs for any one of the form. how do i get it to only occur for the respective form. should i manually do it or my declaration shared is wrong. what i basically need is that the shared withevents hold only 1 forms ref .. whichever has focus. like static, declared once and instantiated multiple times, hold 1 value at a time. so how do i go about that Sorry for the unclarity because of the highlighting! child is not anything special and should not be in blue, i ...Show All

• .NET Development Connection Timeout

  I have a problem with Connection Pool running out of connections. I have a site which can get upwords of 1000 conncurrent hits at once. We never had problems with the connections when using classic ASP. But now we are running into the issue with timing out before getting an available connection. We are closing all of the connections. We have bumped up the max pool size to 700 but i don't feel this is really the right solution. Should we not use ADO.NET and go back to using ODBC as stated before we don't have this problem with our classic ASP which uses ODBC connections. Thanks for any help! Do you only close connection or call Dispose method as well Calling dispose could release connections fas ...Show All

• Smart Device Development regarding the issues in smartphone development

  hi , i have been involved in smartphone game development . i had found out the following issues , for which i couldnt able to find the solution ., since i am new to Windows mobile . 1. regarding the usage of threads in application : i didnt find any methods to stop the thread .. since suspend is not supported in .Net Comppact Framework2 ... 2 . my application is running properly in the emulator i had even tried with WM5.0 emulator . it s working . but when i open the .EXE file inside the bin folder ., its showing OUT of memory Exception .. i have used 14 images , its total capacity is 14.5kb , and its size on disk is 72 kb . help me in reolving the above issues . these are very critical one , without solving dis i cannot proceed . thanxs ...Show All

• SQL Server x64 Management Studio

  Hello, I have a Win2003 x64 Server with a SQL 2005 x64. My client is not x64, and I can't install the x64 Management Studio. I understand that I need a 32bit-version - but where can I get it Do I have to buy a complete 32bit SQL 2005 just to get the Management Studio Best regards, /Mikael S I've got the same setup and use the developer edition that comes with Visual studio. You can buy the dev version for ￡25 as a standalone item. Dave ...Show All

• Software Development for Windows Vista XPS not working correctly...

  I thought the whole purpose of XPS was the perfect preservation of the printed paper... Can someone explain to me why my XPS does not print the same as my docx file. I have a DOCX file that I converted to XPS using the Office plug-in. The XPS appears correct in the XPS viewer, but when I print the file it does NOT keep the margin correct. Can anyone explain to me wy XPS is not working as described My docx and xps file can be downloaded here Do you have any other ways to convert docx file to XPS without installing the Microsoft Office 2007 or Microsoft Office instead of using XSLT Is there any office plug-in library can be used by us without installing the Microsoft office 2007 or Microsoft o ...Show All

• SQL Server MSSQL 2005 Linked servers, Oraoledb on 64 bit Windows 2003 Server (AMD)

  I have installed SQL 2005 (X64) on 64-bit Windows 2003 server (AMD). One of my databases need to connect several Oracle databases on 32 bit servers. I managed to install Oracle 32 bit Client (was unsuccessful with 64 bit installation) and could set up the odbc (32). But I coul'nt find Oracle under linked servers! Does anyone know what I need to do ...Show All

• Smart Device Development using my .h files in C# project

  I would like to give a C# application access to constants/Structures and interfaces defined in C/C++ header files . They are use d by many other applications, and I do not want to redefine them in my C# code. How can i use my existing .h files in C# project.. I'm afraid that you will have to re-declare the types in C#... C++ and C# can be so different, that it's impossible to use C++ declarations directly in C#. You should look for P/Invoke tutorials to see, how data structures can be translated from C++ types to C# types. Here's couple: Here's introduction to Compact Framework P/Invoke, and some examples what C++ types maps directly to C# types (blittable types) http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnne ...Show All

• Smart Device Development Can someone kindly help?

  Ok I sorta got my previous problem solved. But now...when I run the mobile application, I get an error.." Unable to start debugging". Doing some research I found a solution to that error..which was to install the loopback adapter...but now...sometimes the error still persists. It would be working fine...and then, as i said the error would come back. Each time it reoccurs I basically add a loopback adapter again and delete the previous one. Can SOMEONE please help me with this error Also I get a message saying "limited or no connectivity" and that I guess has something to do with the sychronisation of the loopback adapter. Please help... Hi Barry, The only thing I am looking f ...Show All

• Smart Device Development Dimming the background Form

  Hi all, In a part of my application I have a parent form which opens up a smaller child form. I have overriden the OnPaint of the child Form so that its appearance is small (doesn't take up the whole screen). The code I have used for this is as Follows... protected override void OnPaint(PaintEventArgs e) { Graphics g = e.Graphics; base.OnPaint (e); Rectangle r = this.ClientRectangle; r.Height -= 1; r.Width -= 1; g.DrawRectangle(new Pen(Color.Black), r); } But what I want is when the Child Form has loaded I want the Parent Form to be dimmed as parts of the Parent Form will still be visible due to the size of the Child Form. One way I was thinking of this was to apply a semi transparent rectangle the size ...Show All

• Internet Explorer Development Java applets writing to local drive with IE7/Vista

    Does anyone know where a java applet that loads in IE7 running on Vista is allowed to write to on the local file system I have a java applet that works in every version of IE, 4 and higher. The applet is also written that it runs with the old MS Java VM and all versions of Sun's java. It works with other popular browsers too and even IE7 on XP. It does not work on IE7 .  I have read that IE7 on Vista has another layer of security that sandboxes applets (and other scripting languages) to a special area of the drive. Where is this area   I have been for years saving to and executing from the c:\documents and settings\{username}\  folder. The user didn' ...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

• Windows Forms Controls appear attractive in design but not runtime

  Hello, I have recently upgraded a number of VS projects into 2005 and I have noticed that for each of these applications the user controls appear different at runtime. When using the designer in 2005 the buttons appear rounded, and more user-friendly (like the buttons in IE) however at runtime (or during debug) all controls appear a ugly, grey, windows 2000 style appearance. If I create an Windows Forms application from scratch in 2005 I get the attractive controls in all cases - It just seems to be the upgrade. Any ideas Regards, Luc Pettett Hi again, just tried the conversion and noticed, that VS2003 application doesn't enable visual styles by default. Try inserting those lines in your startup code ...Show All

• Visual Studio Team System Transaction timings for non webrequest transactions

  Hey, I have a webtest that I'm running in a loadtest and am gathering timing details using the BeginTransaction and EndTransaction. In the webtest I have both WebRequests and a SOAP client making requests. I have surrounded both my webrequests and SOAP requests with Begin and End Transaction and have found that the SOAP transactions always return 0 for the elapsed time. First off, why would this be In my webtest I need to know exactly where the time was spent, even if the time was not spend with a WebRequest. And secondly, can I just use the Stopwatch class and somehow get it to show up in the transaction table Thanks for your help! -Cliff Hey i tried out your sample In the unit test i have the foll ...Show All