Redshift's Q&A profile
Visual Studio Tools for Office How to Convert an Excel Sheet to XML format
Dear Friends, I have to Export the Excel Sheet into XML format. But In the Excel Sheet I saw Data->XML-> Exports....But Exports menu is always Disable to me. Really I dont know How to Create Well formed Excel Sheet to Export an XML file. AnyOne can please help me or otherwise tell me How to Create a Excel Sheet with Fields.. like... Firstname Lastname City Country Vasanth Prabu Bangalore India I doesn't use Excel ever before. Thanks in Advance. Vasanth. The Data > XML > Export command is not available unless you have first mapped your data as XML in the ...Show All
Windows Forms manual .Net memory Release
Hi , I want to release the memory used by .Net winform app manually. Is there anything equivalent to C++ delete operator in C# I dont want to force a GC collection using GC.collect. Also what is the maximum process size that a .net application can use in 32 bit windows thanks vinoth I think I mentioned .Dispose(). setting to null de-refere ...Show All
Windows Forms Adding beyond "Standard Items"
When I create a toolstrip and then "add standard items", I get a small set of the standard stuff. I want to add more 'Standard' items, but I'm stuck. For example: When I create a menustrip and add standard items, I get Print Preview as one of the standard items. But the toolstrip does not include Print Preview. Fair enough,  ...Show All
Visual C# need return values from Threads
Hi at all, I will "Ping" different Hosts to make sure that they are online. I start for each host a own thread, because some Pings need more time than other Pings and after one second, all Hosts from my list must be pinged again. But if I start a ping, I have no control about the results Here my method. for ( int i = 0; i < Hosts.lenght; i++) { t = new Thread ( new ParameterizedThreadStart ( Pinger .startPing)); PingParams pp = new PingParams (); pp.Buffer = 32; pp.Timeout = 12000; pp.URL = Hosts ; t.Start(pp); } I think I made a general error, right The ...Show All
Visual Studio Team System MSProject Fields Mapping Problem
Hi, Based on the information we found from the list of Project fields at the following url: http://msdn2.microsoft.com/en-us/library/ms181691.aspx and also how to: change how fields are mapped to Microsoft Project from the following url: http://msdn2.microsoft.com/en-us/library/ms181686(VS.80).aspx We are trying to map the "Description" field in VSTS workitems with the "pjTaskNotes" field in MS Project but when we uploaded this modified MyProjFieldsMapping.xml file in to Team Project we are getting following error: TF82024: The following fields could not be mapped because the fields could not be fo ...Show All
.NET Development SecurityAction.DemandeChoice is obsolete ?
I'm working with Beta 2 (v2.0.50215) and I'm using PrincipalPermissionAttribute. As I wished to use more than 1 attribute on a single method, I tried the new SecurityAction.DemandeChoice flag. To my surprise, the compiler said this flag is obsolete ! I've not found anything about that on the web (nothing about that on MSDN2 for example) except in a Mono mailing list. Has this new feature been removed Is there other removed features Thx Hi Nicolas, LinkDemandChoice was in earlier builds of Whidbey, but we did decide to remove it from the final shipping bits. There was some internal architecture work that we th ...Show All
Visual Studio Team System One of the team mate not able to access anything in VSTS even with exact same permissions as others
Hi there, I'm not sure why this is happening as most of the people are able to access Project just fine and open bug, query bugs etc. just fine, but one of the team mate with exact same right and permisions as other is not able to open bug, see query or even reports are not list in Under Reports section. in Team explorer for her. W hen she get to the part about trying to add a bug, it does not do anything. She is also unable to run any of the project queries.but when she clicks on Active Bugs (or any other item) it does not do anything. When she clicks on the same item the second time  ...Show All
Visual Basic COM visible DLLs: are they only legends?
Can anybody provide a direct, straightforward method of creating a DLL with properties and methods exposed to other programs I followed the instructions that I found on the MSDN websites as well as suggestions from forum participants. The DLL should be available both for COM and .NET programs. So far, nothing has worked. There are numerous variations listed on the MSDN site. No doubt there are reasons for the differing instructions. However, I have not had sufficient success with any of them. Sometimes, just building the project makes the class visible to COM compatible programs. Other times, only after running regasm. Still other times, I h ...Show All
Visual Basic Detecting External IP Address
Hi, How can I detect the External IP Address of machine which is running my Application. By External IP address means that IP Address through which PC running my Application is accessible through Internet. and not the local IP Address Thanks Hi, Thanks "plenderj" I got your point..Though I doesn't love the idea to be dependent on external resource for this. But it seems the only answer. Thanks Vikarm for your attempt...I am not making a Web Application. But I am making a network Client application that host it self on internet for client of it to join them.. Now since Client will join only on external IP of the Server and not the i ...Show All
Windows Forms Hosting a server vs. simple peer-to-peer?
Is it better to host a Terrarium server or simply have many peers connecting via peer channel I'm trying to setup Terrarium for our engineering dept within our intranet. I want our group to be able to access a private ecosystem, but hosting a server seems to present many obstacles. Thank you! If I understand it correctly, yo ...Show All
.NET Development Updates through OleDbCommand are not written to database
Hi, i am trying to update an access database with the OleDbCommand.ExecuteNonQuery function. ..... lintRows=lobjOleDbCommand.ExecuteNonQuery("UPDATE TableX SET ColumnValue=9 WHERE ColumnId=1") ..... The function returns value 1, indicating that 1 record have been updated. After closing the OleDbConnection and requerying however, it looks like the update has been rolled back or has never been written to the database. Any suggestion would be helpful. I have a similar situation. I am adding records to a database using OleDbCommand. Several adds are being performed in a For-Next loop. Once the loop is completed, I ...Show All
Smart Device Development Dell Axim's x50v/x51v hardware Direct3D driver slower than software rendering in HX4700
The (in)efficiency of the Dell Axim x51v's Intel 2700G D3DM driver is by now fairly well known, but I thought it worth posting about this, also as a brief followup to Mark Prentice's excellent piece on D3DM efficiency ( http://blogs.msdn.com/markprenticems/archive/2006/03/10/547983.aspx ). I've just updated my HP HX4700 to WM5, and so have been able to test it's efficiency in running D3DM programs that I've written and those of other authors. A medical visualization program that I've written with CF and D3DM that displays 3D organ models actually runs faster on the HP4700 than on the dell. The model has lighting, which is probably wh ...Show All
Visual Studio Team System how to check for interface implementation?
In my fxCop project, I am required to check if a particular class implements interface IDisposable and can call Close() method. How to check for an interface implementation And how to check whether a class supports the close() method Please help me out... Take a look at Type.Interfaces, you can scan these to see whether a type implements something like IDisposable. You'll need to check the entire inheritance chain (via Type.BaseType). If you have a type reference to the interface in question, you can simply us IsAssignableTo: type.IsAssignableTo(SystemTypes.IDisposable) Re: a close method, examine the Type.Members membe ...Show All
Smart Device Development OLE DB template in VS2005 VC++ project
Hi alls, Is it possible to use OLEDB template (OLEDB Consumer ) in Smart Device WTL( | ATL) project in VS2005 Beta2 Thanks Hi Josh, I found solution with headers from Pocket SDK 2003 . I used atldbcli.h with CVirtualBuffer from atlbase.h (SDK 2003 ). So I defined 2 types : typedef DWORD DBSTATUS typedef DWORD DBLENGTH Macro DEFINE_COMMAND_EX generated by ATL Wizard is replaced by DEFINE_COMMAND @+ ...Show All
.NET Development SQLCommand object doesn't want to accept my parameter
Hello all! I tried to fill a DataGridView with the data received from a SQL Query. It doesn't work. It seems as if the parameters are not used. After having passed the parameter and value to the command object the query still looks like before and the result is empy. If the placeholder would have been "replaced" by the parameter, the query would be correct and would return results. What am I doing wrong Here's a snippet from my code, expect all other variables to be correctly initialized. The whole stuff is running under VS 2005 and SQL Server 2005 Express string _str_query = "SELECT * FROM [user] WHERE lastname='@PARAM' "; strin ...Show All
