Reverend Jim

You can't concatenate an array. To see how to insert binary data you can look at [this code snippet](https://www.daniweb.com/software-development/vbnet/code/461171/insert-a-file-as-binary-data-into-a-database). The example uses a PDF.

You can't use LIKE on numeric values. You can use DATEPART to extract the year portion. Your query string should be qry = "SELECT * FROM test_table" & " WHERE DATEPART(YY,myColumn) = " & myDate

I thought I'd install the newest Visual Studio (2013) but all that happens is this (see below). I have all available updates installed plus the latest C++ runtimes. Does anyone have any suggestions? Attempts to get the referenced update result in downloading Visual Studio 2013 Update 3 and when I …

Try adding ";Connection Timeout=60" to the end of your connection string.

And?

A quick check in vb.net and vbScript (sorry, do not have vb6 installed) gives the following results Math.Round(1.5) is 2.0 Math.Round(2.5) is 2.0 Math.Round(3.5) is 4.0 <edit> corrected from 3.0 </edit> Math.Round(4.5) is 4.0 <edit> corrected from 3.0 </edit> If the integer portion is odd then it rounds up. If …

You start by putting in some effort on your own. [Google](http://goo.gl/XHAvvN) it.

Mine is under my avatar. Noli mentula, which (not literally) translated into English is "don't be a dick".

For what it's worth, GOTOs are evil. Before the advent of structured programming constructs like IF-THEN-ELSE, GOTOs were a necessary evil, but used properly they could be tolerated. I, myself, have (on rare occasions) used GOTOs to escape from nested constructs, but I have never had to resort to that …

Lighten up. diafol did not out-and-out accuse you of asking us to do your homework. What he *did* do was take the time to provide information on table relationships, something which you would find useful considering that you do not seem to understand them. On a related note, having a …

I see that ALT-M has no particular signficaance on Daniweb pages. I recall that there are one or more hotleys already defined so would it be possible to link ALT-M on the forum thread pages to the MARK FORUM READ button?

Are you doing an insert or an update? Are you using SqlClient or OleDB?

What have you tried so far?

When the party in power already benefits by gerrymandering and passing voter ID laws designed to minimize opposition votes, why should we be surprised when they also benefit from electroniic voting systems that are rigged in their favour?

You could clear the textboxes whenever you do a insert or delete. This is unrelated to the question but you might simplify the query as query = "SELECT StudentNo,Fullname,Year,Term,Class " & " FROM StudentRegistration " & " WHERE StudentNo = '" & TxtStudentNo.Text & "'" & " AND class IN …

I strongly suggest you read [this](https://www.daniweb.com/software-development/vbnet/threads/424836/please-read-this-before-posting). It's titled **Please Rest This Before Posting** for a reason. Point 2 says, in part Create a meaningful title for your question. Your thread titles are yahoo mute? zip monitor fb None of these titles in any way gives any useful information on the …

Likely already answered [here](https://www.daniweb.com/software-development/vbnet/threads/494665/monitor)

If the thing you want to click is a button you can always execute it by myButton.PerformClick()

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. 

Have you tried to do a repair/install or `sfc /scannow`?

I don't know how your system is partitioned but what I have done for years is (on a single disk system) to create a C and D partition where C is 60-70 gig (depending on how many apps you have installed), and D is the rest of the available space. …

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)

@altjen - Please do not request help via Skype. Any answers provided through Skype would not be of use to anyone else on this forum.

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 file appears in a folder, etc.

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 As String = "32/355ab//3456" For Each m As Match In rx.Matches(s) MsgBox(m.Value) Next End Sub End Class The output will …

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 the maximum of the two values. If the number of channels is 10 or fewer it return 0, otherwise it …

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 System.Object, e As System.EventArgs) Dim tbx As TextBox = sender lblMessage.Caption = tbx.Tag End Sub Use the same for ComboBox.

>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 own. Im more than sure if she was to take SC exam, she would fail So now we are at …

> 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 vastly superior to my pathetic attempts at a foreign language. What I don't understand is the people who post in …

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 can test the string If IsNumeric(a) Then num = CInt(a) You may then test for positive or negative. Note that …

Google is your friend. You can find instructions [here](http://pcsupport.about.com/od/windows7/a/install-windows-7-usb.htm) on how to install Wiindows from a USB flash drive. This is for Windows 7. Should also work for XP.

Why not just use [kiosk mode](http://www.howtogeek.com/173562/how-to-easily-put-a-windows-pc-into-kiosk-mode-with-assigned-access/)?

How about DV.RowFilter = "ID = " & TextBox1.Text

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

Microsoft has made many changes from Windows 7 to Windows 10. They redesigned the start menu (and made it worse) after having removed it in Windows 8. They've, yet again, rearranged everything so I have to go looking for the new locations, etc, etc. The thing I am absolutely the …

The point of the voting is to let you know what people think of your post. If you keep getting down-votes then that should tell you something useful regardless of whether or not you know the users who down-voted. The only reason to might want to know who down-voted you …

"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 managed 1. the number of concurrent users 1. the OS hosting the database and "to host the cloud" is so …

In case you didn't know, you can edit a post within 30 minutes of submitting it.

I *worked* with a few programming jokes, but to be fair, they probably thought the same of me.

What happens when you reboot and press F8? Do you get the option to boot windows normally?

There are three easy ways. 1. Click the **Code** tool. This will open a window where you can paste your code. When you click **Insert code snippet** or press **ALT-I**, the code will be inserted into your post. 2. Paste the code directly into your post. If you do it …

Personally, I like it the way it works now.

I have learned the hard way that Restore Points are not 100% reliable. I disable the feature and rely on periodic disk images for when things go south.

At a recent conference, Microsoft said that the switch to allow Secure Boot to be turned off would be optional. "Hardware can be Designed for Windows 10 and can offer no way to opt out of the Secure Boot lock down." The presenter did not touch on whether OEMS can …

You could restore it from your most recent backup. You **do** do backups, right?

Hopefully he will realize that he is a guest in Dani's house and like all rude guests he will eventually be asked to leave.

I just posted an [article](https://www.daniweb.com/software-development/vbnet/threads/493564/windows-10-and-secure-boot) in Hardware & Software -> Microsoft Windows with the title "Windows 10 and Secure Boot". I added a few tags in the Tags field and when I submitted I was told "You do not have permission to create new tag(s): 10". I was told the …