Your question is quite vague, from the top of my head, select distinct from where ever you are reading from.

A space is a recognised character (Chr 32) so your application is searching for a string that starts with a SPACE. To counter the problem you need remove the leading and or trailing white space by using the String.Trim() method. It removes all the spaces that are not between other Characters. So " this and that " will be changed to "this and that"

In your .Net IDE, goto the Exceptions Screen (somewhere under Debug and Exceptions... I think in 2003) and select the option to break on all Thrown and Unhandled errors, the application will break into the IDE everytime an error happens. That will actually help you to see the actual error that is happening and where it happens. I used to encounter that problem a lot in VB6 though not in .Net. Hope you get it right.

Hi there, I have a requirement to add a custom signing object to a Microsft Word Document using .Net. The object should always manifest itself as a picture, i.e. wen u open or print the document, u see a picture in this case a signature. If an add-in that I have to develop is installed on the same machine, right clicking on the object should also show my custom menus in the popup menu. So my challenges are, how to create the custom object in .net (how can i extend the Image/Bitmap Class and add my own methods properties and evends) and how do I add this custom object and menu to Word? I appreciate any pointers in any direction that myt be helpful. Regards

Thanks for your reply. Ok, or maybe how do I cancel the download completely wen it is about to happen and initiate another process. Note I jus wanna cancel the download if it is going to make that download diolog box pop up otherwise if the browser can embed the document, i want it to continue.

I am using a webbrowser control to load and show supported documents within it. for file types that it cannot embed, i want to automatically launch the application that is associated with that file and open it there. How can I solve the following problems 1. When I enter the following code line myWebBrowser.Navigate("C:\myFile.xls") How do i avoid the download dialog from popping up? 2. How can i tell if my webbrowser will not be able to embed this application but will be able to embed that one? 3. In which event of the WebBrowser control do i need to do this? Thanks for your assistance.

I have a VB.net 2005 solution called MySolution.sln, with a windows project, a windows service, a class libriary, a merge module project and a windows setup project. wen i run the building command in command prompt, devenv.exe /build release MySolution.sln nothing is happening and no messages are returned or anything, the prompt simply goes to the next line and prompts for a new command. Has anyone ever encountered this problem, how is it solved? thanks for looking at least.

I have a VB.net 2005 solution called MySolution.sln, with a windows project, a windows service, a class libriary, a merge module project and a windows setup project. wen i run the building command in command prompt, devenv.exe /build release MySolution.sln nothing is happening and no messages are returned or anything, the prompt simply goes to the next line and prompts for a new command. Has anyone ever encountered this problem, how is it solved? thanks for looking at least.

I would like to compile my vb.net 2005 solution using MSBuild. I am running the command on the solution (.sln) file and it runs without errors, unfortunately it doesn't seem to be compiling the setup/deployment projects which are part of the solution, one is a merge module whilst the other is a windows deployment project. What can i do to make msbuild work for me? Your assistance is greatly appreciated.

I would like to compile my vb.net 2005 solution using MSBuild. I am running the command on the solution (.sln) file and it runs without errors, unfortunately it doesn't seem to be compiling the setup/deployment projects which are part of the solution, one is a merge module whilst the other is a windows deployment project. What can i do to make msbuild work for me? Your assistance is greatly appreciated.

I created a separate project, form and controls then put the code in. After it worked well, i created a new form in my application, copied and pasted the controls and also the code. The code I used is basically the same as this one. http://www.codeguru.com/vb/gen/vb_misc/icons/article.php/c5597/[^]

The shots were taken on same machine, running at the same time, i simply dragged the 2 windows side by side. I load the imagelist from the windows shell which has icons of size 32,32. the treeview is set to show a 16,16 icon size. the color depth is 32bits. (code and settings in both shots is exactly the same, the only difference is that the one in the right is wat my application is outputting and i desire wat's on the left.)

Hi Dave, thanks for your efforts. The icons are standard windows shell32 icons, i actually get them from the system files. a weird thing happened yesterday, I duplicated the troublesome part of the system outside the application and it works well (icons are rendered well) but the moment i took the form back into the project, it behaved as before. Here are the 2 outputs side by side, the left one is the correct one running independently, on the right one after i add it to my windows project, with nothing changed. http://www.4shared.com/file/35005243/44721ad3/Distorted.html[^]

I have a treeview and each node has an icon. At runtime, the icons are appearing with a blue border which makes result very ugly. I use the same imagelist for a listview on the same form and the icons are being rendered perfectly without the blue boarder. Is there something in the system settings or whatever settings that i need to change or be aware of to get rid of this problem? The Icon size is 16X16 (same for the original icon, imagelist setting and treeview icon size) and the color depth is 32bit (highest for my machine) Thanks for assisting.

Hi guys, I added icons to an imagelist which i then associated with a treeview control. The original icons have a transparent background and are of relatively good quality pictures, however when i run my system, they look very grainy at the edges and have a blue border around them when they appear in the treeview at runtime. i used the original icon size (16X16) and a color depth of 32bits. Is there something else about this control and icons or maybe is it haunted? Thanks a lot for your assistance. Regards

Hi guys, how do I install an added merge module in my setup project (vb 2005)? I have 2 merge modules the other one is a windows service, how can i register (installutil service.exe) and start the automatic service soon after installation without the user having to do the manual DOS staff(i mean going to the command prompt and typing ....\installutil ...\service.exe and restarting the machine or having to go to the services list and starting it there)? thanks in advance

if u need to pass parameters to a web address u say www.theWebAddress.com?parameter1=value...

Your question is too broad and ambiguous. The answer will depend on wat you are trying to achieve and your level of understanding of the programming language and technology to be used. As a starting point, use ADO.Net, SQL Connection, SQL Command and depending on wat you are trying to do exactly, u can also use SQL Adapter, datasets, dataset tables etcs. You can search the net for basics and notes on how to use them.

Hi guys, I am developing using .net 2005. The label text on some of my controls (labels, radio buttons and checkboxes) on a single particular form in my project is not showing the last character. e.g. one checkbox control is supposed to show the following text: "Separate source files from XML" its being shown as "Separate source files from XM" another radiobutton control is supposed to show: "Absolute Path" instead the output is "Absolute Pat" This is happening on different controls in different positions on the form. I tested it on a client machine and the problem also came up there. how can i teach my application to spell correctly? Thanks for your assistance... Regards :mad::mad:

public function getTimeWorked(ByVal StartTime as date, ByVal Duration as TimeSpan, _
ByVal EndTime as date, ByVal LunchStartTime as date, ByVal LunchDuration as TimeSpan) as TimeSpan

dim ActualTimeWorked as TimeSpan
dim TimeWorked as TimeDuration = StartTime - EndTime
if (StartTime < LunchStartTime) and (EndTime > (LunchStartTime + LunchDuration)) then
ActualTimeWorked = TimeWorked - LunchDuration
endif
return ActualTimeWorked
end if

Within the same if statement, u can modify the code to get if the guy finished work DURING lunch period and do the necessary calculations or if he started DURING the lunch period and calculate accordingly.