pire's Q&A profile

• Visual Basic Best method for exporting a DataGridView to Excel

  I have a datagridview(DGV) which contains data based on a user selections from a pre-defined dataset In point form: User starts program program builds datatable user opens file and program read all data from file into the dataset.datatable user defines the data they want to see program displays datagrid based on dataset.datatable and user choices. (basically it displays the whole dataset and removes unwanted columns\records) I want to be able to export the datagrid to excel (not sure which method yet). I have tried the excelexporter component i found somewhere on the msdn forums (it exports the data to look exactly like the datagridview) but its painfully slow. It exports something in the region of 100 records per minu ...Show All

• SQL Server Left Outer Join versus Subquery

  Hello Chaps, I have got question about the performance of subquery and left outer join My scenario is that  I have two tables Customer Mater and address book. Customer Mater and address book  tables hold the record for both carrier and customer. and i want retrieve the record for customer and related carrier as well i have two options 1.  either use left outer join (i.e. Join Customer master to Address Book 2 times, 1 for customer and 1 for carrier) by:        Address book (as customer) Left outer Join Customer Master (on related Key)       AddressBook (as carrier) Left Outer Join Customer master (on related Key) 2.or use 1 join for customer ...Show All

• SQL Server SQLDependency is very slow

  I posted this in the .Net data access forum with no replies, so I'm trying it here and apologize for the cross-post. I'm researching using SQLCacheDependency in an application to keep caches up to date between applications. I could also use SQLDependency, just haven't tried that yet. I've tried a test where I read 1000 rows from a database, cache each one, and create the cache dependency. The dependencies work fine. My problem is that it is 100 times slower to read and create a dependency than it is to just read the row. At this rate, I need a 99% cache hit ratio just to make my caches break even! Is caching even worth it at this rate Why is it so slow Thanks very much for any insight. Here is the code: for (int i = 0; i < 1000; ...Show All

• Visual Studio HELP :IMPOSSIBLE To Call Asynchrounously WEBsERVICEs in Visual studio 2005

  HELp ! HELP ! Can any expert tell me why when I create a Proxy to a Web-Service(By adding a Web-Reference ), the intellitips do not show any Begin/End (of the WebMethods) of the WebService In other Words ... There is a WebMethod called 'JOT' After I added a web-reference.....I found in the intellitips 'JOT' and 'JOTasync'(What is this ) I was expected to find 'JOT' &' BeginJOT' & 'EndJOT'. ! Have ' BeginJOT & EndJOT' become obsolete Have they been substituted by a new method: webmethodasync (JOTasync) Help! HELP! Experts help!! Thanks in advance! Hi JO, Now you do not need to use BeginJOT & EndJOT functions for making Asynchronus c ...Show All

• Visual Studio Team System When do reverse deltas take place?

  The TFS FAQ mentions that the server creates "reverse delta" of both binary and text files "asynchronously as a background task". I'm unable to find any other information on how or when this reverse delta creation happens, what factors affect how long it takes, and if it can be controlled.  Is there any documentation on this In addition to just wanting to know, I'm interested in understanding reverse delta creation as I am experimenting with using TFS as a large binary data file version control system. I'm working with a company that has to manage large binary data files  (not documents and which cannot be easily converted to relational data); most of their files are 10-60MB in size, but some reach from .5GB up to 30GB ...Show All

• Windows Forms Redirect console I/O to GUI

  Hello, First of all i whould like to apologize if it isnt the correct place to post my question (my first post on MSDN forum). I was tryig to make class based on : http://support.microsoft.com/kb/q190351/ To redirect input/output from WinAPI/MFC to console application, trouble is: I didnt wrote the console app., therefore i cannot use fflush(NULL); after every single line/output, and without it pipe example given wont work. I know it can be done other way, so i need your help pointing me in right direction here Thanks in Advance. I also have same requirement. Please help. If the solution to this has been found then please let me or publish it here.Regards,Lata ...Show All

• .NET Development Webservice without WSDL ?

  hi all, I have a very lame question but do try to answer it. How can i call a webservice without knowing or having its WSDL. U r effort in trying to solve this one shall be appreciated.... :-) Akash Lomas or without the MSXML2 component, provided that you already have prepared the body to send... // // create a request // HttpWebRequest request = (HttpWebRequest) WebRequest.Create( @" http://someurl/webservice " ); // // set the proper headers // request.Method = "POST"; request.ContentType = "text/xml"; request.Headers.Add( "SOAPAction", "somemethod" ); request.Headers.Add( "encoded", "true" ); request.Headers.Add( "encodingStyle ...Show All

• Visual Studio Express Editions How Common Are Mouse Rollers?

  I am writing an application that I plan to market to medical doctors. I would like to use the mouse roller to rotate a picture box. How common are mouse rollers Do all recent mouses have rollers The majority of new mice you find today have scroll wheels (I assume that is what you are referring to) however you may want to have your input for rotation via the scroll be just another way to rotate but still have other easy to use means available just in case a user doesn’t have one. Think of other applications you’ve got running on your PC that use the scroll wheel... how many of them allow you to do the same thing but without the mouse ...Show All

• Visual Basic The Printer object of VB6 with .NET

  Hi, Currently i am doing migration application.[VB6.0 application to VB.NET 2003 using the Convert option]. When i am trying to compile the Upgrated VB.NET application i am getting Printer problem.I am trying to add the reference of the "Microsoft.VisualBasic.PowerPacks.Printing.Printer.dll " .but it is not possible. Hope that it will work with .NET2.0. Any other option is there Regards, Prakash.K Hi Prakash, The Printer Compatibility requires the .Net Framework 2.0 and VB 2005. If you still need to use VB 2003, you will unfortunately need to convert the Printing logic to use a standard PrintDocument. Sorry I don't have a better answer for you. ...Show All

• Visual Studio Team System Weird Compare Issue

  When I click the "Check-In" button on a TFS SCC project in the source control explorer I get a list if .vspscc and .vssscc file conflicts that occur. When I click on resolve and then click the compare button I get a pop-up window that has the notification icon, 2 buttons but no text at all. Not even on the buttons. What is going on here I installed TFS about 4 days ago. Cheers, Mark I see -- so it comes from using the MSSCCI plugin. I missed that piece of info before. Have you tried the recent 1.1 release If it persists I'll alert one of the MSSCCI developers. ...Show All

• Visual C# Directory Empty --> Problem

  I have this code: string [] files = Directory .GetFiles( @"C:\Documents and Settings\" + Environment .UserName + @"\Local Settings\Temp\" , "*.*" , SearchOption .AllDirectories); foreach ( string fi in files) { try { System.IO. File .Delete(fi); FolderFileCount(); } catch ( UnauthorizedAccessException ) { FolderFileCount(); } } Where FolderFileCount() counts the files in the directory that are still left. Problem: When the exception takes place, the deletion stops. How can I skip over the file that cannot be deleted and continue to empty the directory Thanks, First of all it is not a good idea to retrieve the temp folder for the currently logged on user ...Show All

• Internet Explorer Development Still another report on this...

  Having an intermittent problem printing To: From: CC: Subject: Attachments: headers on emails. Usually happens with larger emails or emails with large attachments or emails that have been replied to or forwarded from other people. Have installed Generic/text printer and sent the email to this printer but sometimes the headers are still missing even printing this way. I have if I open the offending email and highlight just one or two words in the text of the email eg Dear John and then print the email using my HP printer (not as text on Generic printer) - the headers then print and so does the selected words. Don't suggest using Outlook as often we only print the first page of emails as we already have the rest of the email on file especial ...Show All

• Windows Live Developer Forums MSR MapCruncher v3.0 released

  We've just released v3.0 of MSR MapCruncher for Virtual Earth, which allows you to quickly & easily overlay your own custom tile-sets for Virtual Earth from PDF, JPEG, TIFF and other image files. You can find it here: http://research.microsoft.com/mapcruncher. For a list of changes, see: http://research.microsoft.com/mapcruncher/changes.html Cheers, the MSR MapCruncher Team MapCruncher uses the .NET framework's HTTP libraries, which I think should get proxy settings from your global Internet settings -- the same one you should see when you get connection properties from Internet Explorer. We don't set a user agent string. ...Show All

• Architecture User Interface Oriented Application Development

  Hi all, my name is Babak K. Farahani, who was thinking about User Interface Oriented Application Development concept for just 15 years! Three years ago after lots of different implementation I decided to develop the first application that could generate applications based on the UIOAD concept. As I never thought I must register the concept at the time, I never published anything about my dreams. Recently with help of my friends, we published a paper on UIOAD and set up the www.uioad.org to ask all other developers around the world help us in completing and developing the concept. So, I invite everybody to the site and appreciate your comments, idea and ... Regards ...Show All

• SQL Server How to write Prediction Query for TimeSeries Algorithm

  hi,I am a novice SSAS Programmer.I need a prediction Query in time series algorithm, so that it should predict for a particular date.I dont know how to use where condition in a prediction Query. Thanks Karthik Hi, Time series model does not provide prediction on future steps if the deviations of the predicted value is too large. You can verify the quality of the model by have the model predict on the historical data. In BI dev studio, you can right click the model, and choose "Set Algorithm Parameters". You can set the Historic_Model_Count to some value larger than 1 (Note: this parameter is only available on Enterprise Edition of Analysis Server). You might also try to turn some other relevant paratmers to get pre ...Show All