Steve at Eglin's Q&A profile

• SQL Server Sorting Column Names in a Matrix Report, RS 2005?

  Hello, Is there a way to sort columns in a logical order as opposed to alphabetical order For instance: I have two columns Gender and Ethnicity. Gender column includes following values: F, M. Ethnicity column contains: Asian, Black, Hispanic, Native-American, Unknown. When I create a report in RS 2005 in a Matrix format, column headings are sorted alphabetically such as: Asian, Black, F, Hispanic, Native-American, M, Unknown. Is it possible to sort those values as columns headings in a logical order such as: F, M, Asian, Black, Hispanic, Native-American, Unknown. I know I could use tricks by let say adding a space in front of ' F', or ...Show All

• Visual Studio Tools for Office Trust Warning

  I had already posted this in my Trust Load Customization post. I've tried so many things my head is spinning. I need more help and wasn't sure exactly where to post this follow up in my original post. I'm getting a warning that says "The assembly must be granted full trust before the solution will run. For more information see Help." It seems that the trust issue relates to the spreadsheet and not to my vb.net code (I think). The application runs in debug mode from within VS. It also runs if I run the Excel file that lives in the Debug folder. Since I've barely started it, I haven't tried to make a deployable application. ...Show All

• Visual Studio 2008 (Pre-release) Modify Window Chrome via templates?

  I've been playing around with Avalon for quite some time. I love it and am really looking forward to what people can create with it. My only gripe is the fact that the Avalon application resides inside a regular window chrome. Now, I understand why this was done, but does anyone else see a need to allow for customization of the window chrome Could anyone explain to me how Microsoft Max accomplished this Finally, I've opened up a suggestion on MSDN Product Feedback. If you think that customization of the window chrome should be allowed without Win32 calls, vote on it! http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbacki ...Show All

• Visual Studio Express Editions Printing Multi-page ListBox

  Hello. If someone can help me I would be most pleased. I have a ListBox with many lines but when I want to print, I can only get 1 page although there are many more lines to print. I have desperately been trying all combinations of code with the right logic. I think Please help. Thankyou. Ali. I assume you use the PrintDocument class to do the printing. In the PrintPage handler, set e.HasMorePages = true to get more than one page. ...Show All

• Visual C# how can i get a substring in a string and then change its color?

  for example if I type /* in the textfield all preceding characters should change to color green and when I type */ the change should stop. You have two options. 1 - use a rich text box, and parse the text so that you change the color 2- write your own control derived from the textbox to do this. ...Show All

• Windows Forms ObjectDataSource .NET 2.0

  Hi, I have a simple class called contact - This has the usual stuff - Name, address, phone etc and also SubscriberToken . When I generate a form using the DetailsView control with the objectdatasource and select the appropriate business layer method, I get the desired result. No problem so far. How ever the SubscriberToken is an internal hidden field that is stored in the users profile. I need this to be stamped onto every new contact record. (Insert Method) So, without having to read every field off the page and re-assign it to a new instance of the contact class and then pass it to InputParameters, How can I just add the SubscriberTok ...Show All

• .NET Development SQLDataSource/ObjectDataSource and Transaction for multi db operations

  Is there anybody who can talk about how to achieve the db transaction using sqldatasource and object datasource I tried and researched enough but no luck. If there is really no support for transaction by these objects then they are really useless. And not only that we lost out best friend dataset/sqldatadapter/component designer for such stupid objects.... I wish them to back in VS2005 upgrade.... thanks It seems this thread is dead...nobody is interested...i was hoping there might be people who have experienced the same problem as i did... ...Show All

• Windows Forms Sorry simple newbie question - saving data

  Hi there, sorry to appear dim but i've not done a lot of programing and i am basically teaching myself from books. I have a form in which i'm displaying the text property of the controls on the form in a list box. You can then select one of these from the list box and display it in a text box. You can then modify the controls t ...Show All

• Smart Device Development Passing value to exe

  Hi,  How to read exe file header using compact framework Hi,      I also have the same problem. Is there is any method  to prevent the opening of the exe file other than the owner(who creates it.). I have no idea. if any idea please..... Regards, Bala. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Setting up Visual C++.net 2003 for DirectX Games

  Hello! How do I Set up Visual C++.net 2003 for DirectX Games programming. I have  just up graded from Visual C++ 6, I know how to do this in Visual C++ 6, with linker and # includes,  is it the same with Visual C++.net 2003 standard. If so a step by step would be helpful. Thanks. I mean the installer should do both, but you should check both to be sure.  I think you need to not have the IDE open for this to work. ...Show All

• SQL Server drop user

  Hi, I have a user in my SQL server 2005 database sys.sysusers table with following values. I am unable to delete this user and unable to create a user with this same user name. Please tell some one what is status=16 and issqluser=0 status     16 ame       \CMSXXCMSTESTER roles     NULL altuid     5    hasdbaccess      0   islogin              1 isntname            0 isntgroup    ...Show All

• SQL Server Password Protected Excel File

  Hi I'm in need of a bit of assitance here.  Basically I am currently creating a SSIS package which works in principle with the exception of my data flow.   On my data flow I am reading an excel file using the excel source, this works fine for a number of my examples but one of the excel files is password protected.  This is throwing an error when I try to run the package. Does anyone know how to read a password protected excel file Thanks Kismet123 Thanks for that information Doug.  Could you possibly tell me what the Password property is referring to when you create an Excel Co ...Show All

• .NET Development saving text to a file

  i want to save to text from a textbox in another form into a file i created a property in the child form to raed or write text to the textbox i used the following code to save the file child Child = new child ( "untiteled1" + i ); SaveFileDialog save = new SaveFileDialog (); if ( save . ShowDialog () == DialogResult . OK ) { streamwriter writer = File . CreateText ( save . FileName ); writer . WriteLine (Child.readtext ); writer . Close () } but it creates an empty file and also when i write writer . WriteLine("any string " ); it works well so i need to ...Show All

• Smart Device Development Showing console window

  How to show up the console window in Smartphone emulator when debugging some console app Thx in advance Although you can write to the console (i.e. the file "CON1:"), Smartphone and Pocket PC don't ship with an console implementation to display this text. A search for "Pocket PC console.dll" will yield more information on this. However, you could always use the OutputDebugString(LPCTSTR) function if all you want to do is see some output while debugging. Your text will then be written to the "Output" window in Visual Studio 2005. If you don't see this window, select the menu option "View > Outp ...Show All

• Visual Studio Express Editions Adding print summary

  I want to be able to print a summary for 4-5 forms in my program. how do I add a print summary button and then be able to print a summary. The forms have information on them that use typed in. Please help Scott I would like to print a summary for the 4-5 forms that are part of my program. I would like to put a button on the main page that will allow to print a summary of the data on the forms. Can you help please. Scott ...Show All