-
Replied To a Post in using IsNull to get sum() in vb.net
You could convert nulls to 0. In MS SQL it is the COALESCE function. When you specify a column, instead of SELECT column use SELECT COALESCE(column,0) -
Replied To a Post in The future!
I'd be happy just being able to jump from Winnipeg to New York (I wouldn't miss the 3 hour layover in Toronto, which is where I am currently passing the … -
Replied To a Post in Things I hate about TV shows
>If you add that song time to the ridiculouse blank screen time between some scenes of the show, it totals about -5 minutes of actual relevant content. Yeah, but it's … -
Replied To a Post in Random Facts
Because the cost of cocoa has increased so much in the last few years, many chocolate manufacturers have switched from cocoa butter to vegetable oil which is why when you … -
Replied To a Post in Things I hate about TV shows
**Not** watching Fox News **will** make you smarter. -
Replied To a Post in Extract Groups of numbers from a string
You can use regular expressions. Here's your example Imports System.Text.RegularExpressions Public Class Form1 Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Dim rx As New Regex("\d+") Dim s … -
Replied To a Post in wojciech discussion
@diafol - Superlatively awesome work. -
Replied To a Post in ComboBox Help
As far as I know, auto-complete only matches from the beginning of the string. If you want to match any string at any position you'll have to roll your own. … -
Replied To a Post in Can someone help me with my logic for a bill program?
Try If radResidential.Checked Then totalDue = 4.5 + 30 + 5 * premiumChannels Else totalDue = 16.50 + 80 + 4 * Math.Max(premiumChannels - 10, 0) End If Math.Max returns … -
Replied To a Post in Retrieving and saving data to Mysql Database using Visual Basic 2010
After you create the query but before you execute it add the following line Debug.WriteLine(query) then post the output here. You also might want to have a look at [using … -
Replied To a Post in How to display tag to a label for a list of textbox and combobox
That's not vb.net then. It's vba. You are in the wrong forum. -
Replied To a Post in Jokes
The problem with git jokes is everyone has their own version. -
Replied To a Post in How to display tag to a label for a list of textbox and combobox
Try Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load For Each tbx As TextBox In Me.Controls.OfType(Of TextBox)() AddHandler tbx.Enter, AddressOf TextBox_Enter Next End Sub Private Sub TextBox_Enter(sender As … -
Edited How to display tag to a label for a list of textbox and combobox
Hi, There are 50+ textboxes and comboboxes on my form and I created a label to store the tag of each textbox or combobox as it is focused. This is … -
Replied To a Post in Lazy Questions
> I guess most native English speaking people will notice that English is not my main language. Nothing that couldn't be attributed to fumbly keyboarding. Trust me, your English is … -
Replied To a Post in Random Facts
In March of 2015, [111 people died](http://thinkprogress.org/justice/2015/04/01/3641143/use-of-force-incidents-march/) during encounters with the police in the United States. In contrast, in the entire United Kingdom, [52 people](http://en.wikipedia.org/wiki/List_of_killings_by_law_enforcement_officers_in_the_United_Kingdom) have been killed by the … -
Replied To a Post in If statements in VB
You'll want to get the value from the input box as a string as in Dim a As String = InputBox("Enter the snowfall totals month by month: ") Then you … -
Replied To a Post in Why does Windows XP refuse to die?
>The spreadsheets were in the Lotus 123 .wks format. It's not Microsoft's fault that Lotus 123 used a non-portable format. It's certainly not up to Microsoft to continue supporting an … -
Replied To a Post in CVs on DANIWEB
>but most of whats powering this webapp is community. And I suppose that when you are driving around in your car you think it is powered by your own sense … -
Replied To a Post in CVs on DANIWEB
As you said, he's trolling. I suppose he'll just keep being a dick until he is banned and then he can go onto other forums and cry about how Daniweb … -
Replied To a Post in Disable TAB Key in an EXE File
There is a setting named `Make Single Instance Application` which should prevent multiple copies from running. -
Replied To a Post in EXPORT DATA FROM SQL TO NOTEPAD USING VB.NET
You could do For Each row As DataRow In dt.Rows Dim line As String = "" For Each column As DataColumn In dt.Columns 'Add the Data rows. line += "|" … -
Replied To a Post in EXPORT DATA FROM SQL TO NOTEPAD USING VB.NET
What have you tried so far? -
Gave Reputation to Wojciech_1 in Cannot cash out reward points
Yes one idea - its unfinished subsystem. Should be turned off. -
Replied To a Post in CVs on DANIWEB
>Its blind loyalty to its fullest. I believe it's called standing up for an extremely talented person who has put her heart into Daniweb to provide a forum for the … -
Gave Reputation to Wojciech_1 in Donation part. Servers are expensive.....
Bandwitch is also cheap. The key here is choose wisely (with cost-effectiveness in mind). Bear in mind that cost-effectiveness does not have to be equal with resource-less/poor. BTW what about … -
Replied To a Post in CVs on DANIWEB
>We (within Polish webdeveloping society) call person like Dani script-newbie (also script-kiddie) - she is knowledgeable how to code (=write code), but dont understand what many directives do on their … -
Replied To a Post in fill DataGridView without form load event
When would you like it to load? It can be done on the click of a button, after a given time interval, at a specific time of day, when a … -
Marked Solved Status for Import Text without Header into a DataGridView
Hello, first of all I am new to vb.net so sorry if my question is stupid... :( I have text files that are something like this: "#...... "#...... 1.2 2.5 … -
Marked Solved Status for from textboxes to listview
Hi guys, I have a form called frmSales, with two textboxes and a list box. what I want to do is to fill the listview with product description from txtDescription … -
Replied To a Post in Disable TAB Key in an EXE File
Why not just use [kiosk mode](http://www.howtogeek.com/173562/how-to-easily-put-a-windows-pc-into-kiosk-mode-with-assigned-access/)? -
Edited Help Pseudocode to Java
Help, I have a good pseudocode written that is supposed to get the title of a person and how many boxes in an order and print labels. Here is the … -
Gave Reputation to Wojciech_1 in CVs on DANIWEB
Im not hell**-**bent on anything, Im just trying to persuade Dani (and others) what **I** think can be improved and how it may be done. Its just Dani who have … -
Replied To a Post in Search in SQL server
How about DV.RowFilter = "ID = " & TextBox1.Text -
Replied To a Post in Import Text without Header into a DataGridView
How about For Each line As String In lines if not line.StartsWith("#") then Dim columns() As String = line.Split(" ") Dim index = Me.DataGridView1.Rows.Add() Me.DataGridView1.Rows(index).SetValues(columns) end if Next -
Replied To a Post in No deletion of post/articles/reviews whatever
>For me - its not rude; its just expressing what one thinks..... 1. That does not appear to be the case. 1. You are a God Damned liar. Both of … -
Gave Reputation to diafol in CVs on DANIWEB
@wojciech Please keep it civil. You seem hellbent on annoying people. Your attitude is not helping. Things you say do not have to be "good" but there is absolutely no … -
Replied To a Post in PC Issue
Have you tried to do a repair/install or `sfc /scannow`? -
Replied To a Post in Why does Windows XP refuse to die?
>I can't find any new printers that work with XP, and Lexmark just discontinued the ink for my printer. That's not the fault of Microsoft. It's up to the manufacturer … -
Replied To a Post in Blue Pill or Red Pill
I *did* see phrases like "stop wasting your time" and "go get a life". -
Replied To a Post in Database
"The best database" depends on many factors such as 1. your level of expertise 1. the amount of the data to be managed 1. the type of data to be … -
Replied To a Post in Blue Pill or Red Pill
The last animated gif is cool. The vertical bars look like they are moving from left to right.  -
Replied To a Post in Blue Pill or Red Pill
I like this one the best. It's an animated pinwheel. Try to open it in another tab, make the browser full screen and zoom in to make the image as … -
Replied To a Post in Blue Pill or Red Pill
This one's an animated gif. At first when you stare at the centre you will see the blue dots disappear and reappear in sequence. Then you will see a yellow … -
Replied To a Post in Blue Pill or Red Pill
This one flip flops between front and side views.  -
Replied To a Post in Blue Pill or Red Pill
I'm going to post a few more of my favourites. Some are animated gifs so you may have to download and view for them to work. The first two are … -
Replied To a Post in Things I hate about TV shows
Guilty pleasure - Scorpion At least until last night's episode, "Crossroads". The team is on the road transporting a protected witness as they are being tailed by the big bad … -
Replied To a Post in Bootable Pen Drive
@helenspencer - that is certainly not the case unless by **flashing** you mean copying anything to the drive. [Here](http://blogs.technet.com/b/danstolts/archive/2012/07/26/create-bootable-usb-thumb-drive-key-using-diskpart-with-windows-8-media-to-install-windows-8-release-preview-or-other-operating-system.aspx) is a method using no third party software. -
Replied To a Post in Blue Pill or Red Pill
You'll have to open this picture in another tab to get the effect because it is an animated gif. It's a false colour illusion.  -
Liked / Shared DaniWeb license
As Dani is on hiatus from DaniWeb and does not make changes within its source code/implement new things, when (if ever) will sources of DaniWeb be made pubicly available on …
The End.