Merge Cell in Excel
How to merge cells using Cell and not Range in vb.net I'll try this code but it doesn't work excelSheet.Cells(1, 10).Merge() Can anyone help me.. ...
vb.net
Publishing my project in Visual Basic
Hello, I developed a project using VB.Net and I used the following way to publish it: 1- Build -> Build "my project" 2- Build -> Publish "my project" then I follow the wizard and got the setup file at the end. But when I tried to install it I got an error telling me that my media files couldn't be found. ** I placed the media file...
Advantages and disadvantages of including PDB files with your release application
I've got a VB.net application. Currently the release version of the application is produced without a PDB file. This gives me error logs lacking useful details such as line numbers. I'm looking at including the PDB files with future builds but i'd like to know what the advantages and disadvantages of this are (performance wise, size wise...
How to get the value of an XML element using Linq even when empty.
Please excuse my stupidity, I tend to find the traversing XML overly complicated. I am using ASP.NET in VB. I have an XML document which contains all the details of staff in my company... <staff> <staffName>Test Staff</staffName> <staffTitle>Slave</staffTitle> <staffDepartmentName>Finance</staffDepartmentName> <staffOf...
VB.Net IO performance
Having read this page, I can't believe that VB.Net has such a terrible performance when it comes to I/O. Is this still true today? How does the .Net Framework 2.0 perform in terms of I/O (that's the version I'm targeting)? ...
Unit Testing Best Practice? / C# InternalsVisibleTo() attribute for VBNET 2.0 while testing?
I'm building an Active Directory wrapper in VBNET 2.0 (can't use later .NET) in which I have the following: IUtilisateur IGroupe IUniteOrganisation These interfaces are implemented in internal classes (Friend in VBNET), so that I want to implement a façade in order to instiate each of the interfaces with their internal classes. This ...
IsDouble check for string in Vb.net?
I will get data in DataTable. I am going to iterate data in foreach. I will have all types of data in Datatable. Now I need to find Double for each item (string) in DataTable. How to find IsDouble for string? Ex: I have "21342.2121" string. I need to covert this to Double. But sometimes the data will be "TextString". So I can't use Do...
Unit Testing using InternalsVisibleToAttribute requires compiling with /out:filename.ext?
In my most recent question: Unit Testing Best Practice? / C# InternalsVisibleTo() attribute for VBNET 2.0 while testing?, I was asking about InternalsVisibleToAttribute. I have read the documentation on how to use it, and everything is fine and understood. However, I can't instantiate my class Groupe from my Testing project. I want ...
How should I provide access to this custom DAL?
I'm writing a custom DAL (VB.NET) for an ordering system project. I'd like to explain how it is coded now, and receive some alternate ideas to make coding against the DAL easier/more readable. The DAL is part of an n-tier (not n-layer) application, where each tier is in it's own assembly/DLL. The DAL consists of several classes that h...
Importing an Excel WorkSheet into a Datatable
I have been asked to create import functionality in my application. I am getting an excel worksheet as input. The worksheet has column headers followed by data. The users want to simply select an xls file from their system, click upload and the tool deletes the table in the database and adds this new data. I thought the best way would ...
Abstract class over Interfaces in ADO.Net Environment
I am developing a web app but is not satisfied with is architecture that I am following. The architecture is plain old conventional 3 tier architecture. What i want is follow some design pattern or architecture that will be help me in decoupling my code. I have idea about MVC and MVP architectures for Web App but i need different from ...
VB.NET disable the keyboard and mouse
I am looking to create a VB.NET application. when the application is opened it will disable the keyboard and mouse so if you hit any keys it does nothing and you can not move the mouse. (even if currently selected window is not that of application). MUST WORK ON WINDOWS 7! Thanks in advance. ...
Creating a Web Service to automatically get information
I want to create some sort of method of creating a web service that will run automatically and run DB queries and some API calls which will then store data that I can use/call without taking the processing or time penalty of doing it every time a user access my web service. Is this possible? If so, point me in the right direction on how ...
VB.net Edit-And-Continue: ignore "unable to apply this change while debugging"
When using VB.Net (2008) and paused in debugging, Edit-And-Continue is a great time-saver. However if you change any module/class-level information (variable, sub/function signature, etc), you get the error message like this: "unable to apply this change while debugging" While I can understand the technical challenge to making this wo...
Get Visual Studio to produce the same DLL for the same C# source
I noticed that when I build a given C# or VB.NET source to produce a DLL, the binary output is different each time. It would be helpful for our build / deployment process if this was not the case. Can I control this? ...
With cacheduration set, is it possible to have the function still trigger
If I have my cacheduration set to some value for my Web Service, is it possible to force the function to trigger? Thanks. ...
How to break this string and sort on version number
I have an ASP app that has a string array as such (there are much more than this): 7.5.0.17 Date: 05_03_10 7.5.0.18 Date: 05_03_10 7.5.0.19 Date: 05_04_10 7.5.0.2 Date: 02_19_10 7.5.0.20 Date: 05_06_10 7.5.0.3 Date: 02_26_10 7.5.0.4 Date: 03_02_10 7.5.0.5 Date: 03_08_10 7.5.0.6 Date: 03_12_10 7.5....
"Subforms" associated with tree view in VB
I am using VB Express 2008 to demonstrate my ideas for an improved UI for an existing product for my colleagues at work. The current UI has a certain page with ten tabs, allowing the user to define up to ten "things". The available choices for each of the ten "things" are all the same. On each of the ten tabs, there is a checkbox to ena...
How do you Bind to a ComboBox in a DataTemplate?
I have a listbox that is bound to an observable collection of Audio (custom class). The Audio class has two properties, DisplayText (string) and a property called TarpIds (Observable Collection of Integer). I need to allow the user to change the TarpID in the combo box for each list item displayed and catch the selection change. I cre...
How to overwrite an excel application without prompting the users..
Can anyone help me on how can I overwrite the excel file without prompting the users in VB.Net.. I have try this code but It doesn't work.. Dim xlsApp As New Excel.Application Dim xlsBook As Excel.Workbook Dim xlsSheet As Excel.Worksheet Dim dir As String = Application.StartupPath & "\Template\SampleTemplate.xls" xlsBook = GetObject(di...