Hey Guys, I have the same problem. But the differences is that my empty rows are in the middle and I have over 50 columns. The user wants to see the duplicated rows, so that means I cannot use SELECT DISTINCT * FROM [excel] The empty rows could be anywhere. The largest excel I faced with so far have over 100,000 rows. Is there a m...
When investigating effective methods of documenting our VB .NET project, by experimentation I discovered that I can make a comment like 'See the file at file://path_to_file and I can then ctrl-click on this link to bring up the file in a new tab. Is this feature and perhaps other capabilities of Visual Studio comments documented anyw...
i need your help to remove null and empty values in DataTable. My Excel table 4678 rows but returning rows more than 1000000 i need to remove empty or null ... Also MY COLUMNS COUNT 60!!! :( please help me foreach (var sheet in Sheets) { dbCommand = new OleDbCommand("select * From[" + sheet + "$]", excelConn...
I know that the general tabs vs spaces thing is as old as the hills and mostly comes down to personal preference/sticking to the style of your team, I just wanted to ask a practical question about using spaces in Visual Studio. There are certain things about tabs that bug me and I wouldn't mind changing to spaces while we're a small team...
Hello, I downloaded a library(SquishIt) I want to use in a Console Application. I am working in Visual Studio 2010 so the Target framework is set to ".Net Framework 4" in the properties of the application. This causes the following error in my code: The type or namespace name 'SquishIt' could not be found (are you missing a using di...
Hi, I am looking for the best way to dynamically arrange the location of labels (or any control for that matter) during runtime in a Windows Forms application using VB.net or C# in VS2008. I have a control that displays messages created by users. This control has a panel docked at the top which holds the header information for each mess...
My Solution Built fine last Friday. Today I fired it up and I am getting this error message: Could not load file or assembly 'MyApplication, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. This is failing in my Smart Device Unit Test project. I have Googled...
Quick question, I'm using the Visual Studio's testing framework for unit testing. Just wondering what's the difference between using the constructor to do initialization work vs. having a method with [TestInitialize()] attribute? ...
I'm writing an ansi c program in vs2005. Everything compiles ok and I can run the program from command line. BUT, if I run it inside the IDE then the app finishes and closes - ignoring all break points. why? help! ...
Hi I'm currently working on some SSRS reports and the data I am getting comes in quite a range. I'm getting dates in forms of: 6/18/2010 6:00:00 AM, 6/18/2010, 2010/6/18 I was hoping to be able to come up with a formatting code to use for the row so that it would convert any of these into the MM/dd/yyyy format and anything else just lea...
How do you enable error dectection for CSS files in Visual Studio 2010? It's said to be in tools options, but I can't seem to find it. ...
I need both of them on one computer, first for educational purposes and second for work. Will there be compability problems? ...
Hi, I am trying to use the findContours function in OpenCV, but VS 2008 gives an error saying: OpenCV Error: Bad flag (parameter or structure field) (Unrecognized or unsupport ed array type) in unknown function, file ........\ocv\opencv\src\cxcore\cxarr ay.cpp, line 2476 This application has requested the Runtime to terminate it in a...
Lately I've been working on a C++ project in Visual Studio. I had to configure the project in every detail: libraries, linker options, optimization, optional compiler setting etc... Now I'm moving to another similar project and I'd like to reuse the settings of the current one without manually setting them again. ...
What are the limitations of Visual Web Developer Express 2010 when compared to the Professional and Ultimate and other non-free versions? ...
Hello, I have a TextBox & I want to accept just numbers in this TextBox when typing. Thanks. ...
I want to buy a new laptop to do .NET web development and am wondering what version of the Windows 7 OS I need to buy. The options are Windows 7 Home premium 64 bit or I pay $120 more and get the Windows 7 Professional 64 bit, which I really dont want to pay for if I dont need it. I would like to Install Visual Studio 2010, SQL Server 2...
I have a windows service project and a setup project. I can't figure out how to change the name of the actual service when it is installed (the name listed in windows services . . . services.msc). ...
We have existing VS 2008 VSTO add-ins for Word 2003 and Excel 2003. We are unable to upgrade the Office version at this time. We have just tried to upgrade our solution to VS 2010 and it converts and compiles fine, but when building and running the add-in we receive a message saying that the required version of Office is not installed. ...
This is not a biggie at all, but something that would be very helpful indeed if resolved. When I'm overloading methods etc there are times when the xml comments are exactly the same, bar 1 or 2 param names. I have to copy/paste the comments down to each overloaded method, where they are the same. Sometimes, however, this can cause m...