rwbogosian's Q&A profile

• Visual Studio Tools for Office How to export data to Excel file effectively

  I need to export a set of data , which may be stored in a DataTable object, to an Excel file as a report. Taking advantage of "Excel 11.0 object library", it is quite simple to do the job. But the interop between the managed code and the unmanaged COM component turns out to be too ineffective. I have to handle Excel.Range to insert data to the Excel cells. In order to improve the performance, I convert the data into an array, which can be inserted as a whole. The problem is: the display of the table gridlines should change according to the data, so I can not get rid of handling a large amount of Excel.Range objects. For instance, string[,] dataArray = LoadData(); Excel.Range range = _worksheet.get_range(" ...Show All

• SQL Server Inserted and Deleted tables

  Hi: Can any of the experts please confirm the fact that Inserted and deleted tables in SQL Server 2005 are stored in tempdb . If so, how can I query them in tempdb ( A code snippet would be useful). Thanks AK I am curious why you would want to do this in the first place. Are you simply trying to access the data before and after the record is created. In a trigger you can access the date using inserted and deleted as a table name. select * from inserted Also, it is interesting to point out that an update consists of both an insert and a delete. ...Show All

• .NET Development NetworkStream.Length Property

  Hi All, I want to use this property but in MSDN it says "This property is not currently supported and always throws a NotSupportedException.". When will it be supported Can you suggest any other method or property Try out this article: http://www.yoda.arachsys.com/csharp/readbinary.html ...Show All

• Gadgets Author/View Mode Resizing issue.

  When I'm in author mode (Editing my spaces site) the gadget doesn't resize properly. When I switch to view mode then back to edit mode it works fine.. It also always works fine in view mode. I'm starting to think it's a glitch in the framework, it's driving me nuts. I didn't publish it live.. I registered it using the testing API's published on the spacecraft. // register your Gadget's namespace registerNamespace( "abc.Live.Gadget" ); // define the constructor for your Gadget (this must match the name in the manifest XML) abc.Live.Gadget.xyz = function (p_elSource, p_args, p_namespace) { // always call initializeBase before anything else! abc.Live.Gadget.xyz.initializeBase( this , arguments); var ...Show All

• .NET Development Wha are the windows services required to run a web service?

  Hi, I have a windows service written in c# under win 2003 server sp1 with IIS6.0. The windows service make use of several web services. My problem is that after I restart the machine, when my service starts automatically it fails to call the web service and I get an error message. I thought I should add a dependency for the IIS Admin service but it didnt help me. What I currently do is wait a few minutes before i start my service and then everything works fine. What are the services required to start before I can call a web service Thanks in advance, Kruv. Kruv, Try adding a dependency with the "World Wide Web Publishing" service.... this should work. Rgds Rodrigo ...Show All

• Windows Forms How do i access BindingSource current row ?

  How do i access BindingSource current row and change value of specific field I have client table with 4 elements client_guid code name surname My form is binded through BindingSource to all fields except client_guid I want to create new client. So i enter values in all fields and hit save. But i get error that client_guid should be supplied. I use BindingSource.AddNew() and then i use BindingSource.EndEdit() to save new clients - this works fine and new row is created, but it works only if i also bind client_guid to some textbox... sure it is not what i want. I wan to assign client_guid value in code not from UI textbox I can't get it how do i access this client_guid field to set it's value. I would do it before callin ...Show All

• Visual C++ Linking problem while building appln. developed in Visual studio 8 using visual studio6 version

  hi all I tried building a DLL developed in Visual studio 8 (VC++) using Visual Studio 6.While building the DLL some header files say iphlpapi.h is missing.Is there any possibility to get Windows sdk for intel processor from internet or what is the solution for this Awaiting for responses... Regards Geetha iphlpapi.h should be in your \Program Files\Microsoft Visual Studio 8\VC\PlatformSDK\Include folder (it is there in Visual C++ 2005 Professional Edition) ...Show All

• Smart Device Development Windows Mobile5 and Visual Studio 2003

  I wanna know if is possible to develop an application with Visual Studio 2003 (NetCF 1.0) and run this on a device with Windows Mobile 5 (HP iPAQ hx2795 Pocket PC). There is any problem running or debugging my application on this scenario Thanks. VS 2003 knows nothing about WM 5.0, so it’s not officially supported. In most cases it would work, however VS 2003 probably would attempt to deploy about 20 MB of flat framework DLLs since platform is not recognized. Also you won’t be able to install and use WM 5.0 SDKs. Debugging is likely to work, but no guarantee. ...Show All

• .NET Development Sounds and Beep

  Hi everyone, using C#....... How can I make Beeps in different ferquncis and generally how to run sound file from my pc please answer any one of two or the both thanks I found some C code for a tone generator that maybe can be useful to get started on a c#/.NET implementation. http://www.thescripts.com/forum/thread250818.html ...Show All

• Visual Studio Team System MERGE, ROLLBACK and then Re-MERGE is painfull

  Hi All, I have a situation where I am stuck and need some help. I have a Team Project. This team project has 3 code line i.e. Dev Line, QA Line and Prod Line. Developers will do their coding for a release and when they will be done, we will do the staging build and once it's ready for testing, we will merge the work done by the changesets (i.e Merge by selective changesets). I am experiencing some problem in MERGING,ROLLBACKING and then RE-MERGING. For example, I merge 20 changesets in QA Code Line. Testers test the QA Line and some things donot pass and we make a cut, say 5 changests and release the rest. Now, we decided to release 15 of those changesets or say we need to take 5 changesets out of that QA code line. Now, the only thing I ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XACT and Music

  Xact cant import .mp3 .wma or .mid...what do i use to play music then i just read those links and something should be done..i want my game 360 compatible so that means i must use what is given i know i could use direct sound for the windows version but converting a music file to .wav to have a whopping 50 megs is just..no ...Show All

• .NET Development sharing of textfile (FileShare method not working)

  Hi guys, I'm working on application with multiple instances running in the same machine. In this application I'm accessing file "test.txt" and the other instances also needs this file. But the first application who will get to open the "test.txt" will have the write access and the other instances will only have read access. Below is my code snippet: if (singleInstance) {FileStream fs = File .Open( @"C:\test.txt" , FileMode .Open, FileAccess .ReadWrite, FileShare .Read);} else {FileStream fs = File .Open( @"C:\test.txt" , FileMode .Open, FileAccess .Read ) } When I tried running my application, I open the test.txt in the notepad and I can open it but can't do any mo ...Show All

• Windows Forms how to add n number of controls at runtime?

  how to add n number of controls (say textbox or treeview, or tablelayoutpanel) at runtime i am using vs 2005, c#. thnx. now, if i want to do something (like write) in the 3rd or some random number textbox tht i added, how woudl i do that (pardon me, if it's obvious) [ofcourse, at a later time...in the same loop tht can be done]....it seems to me all have the same object name. ...Show All

• Visual Studio Team System Project Portfolio Server 2006

  Hi, I recently downloaded the Project Portfolio Server 2006 application from MSDN and followed the installation instructions. However, when I tried to run the application, I get the following error message pointing to an obvious syntax error. Also, when I tried to access the login.aspx page rather than the default.aspx page, it does not let me go past the login page and I am pretty sure its not processing my request. Here is the error message and the Compiler output...Any help would be greatly appreciated. Line 1: <% Response.Redirect("~/"+((Microsoft.Office.Project.PortfolioServer.BusinessLayer.ApplicationSecurity.StratFramesIdentity).Context.User.Identity).AccountID+"/Project.aspx"); %> c:\windows\sy ...Show All

• SQL Server How To View Time Series Chart In C#

  Hi! When I using SQL Server 2005 to buide a Time Series mining model, in the Charts tab, it show the chart about somthing to predict in the future. How to view that Time Series Chart in C# . ( Or using a third component) This previous thread presents a few options for displaying a Time Series chart on the web. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=437059&SiteID=1 Hope this helps ...Show All