Guys,

I'm having problems with my MySQL query. VB keeps throwing the following exception:

Quote:The CommandText property has not been properly initialized

Hey guys,

I've built a MySQL query (below) that I'm using in my application. This is a rather long query and I can't figure out how to get it to display in multiple lines using (& _).

[code2=vbnet]dbQuery = "INSERT INTO customer (accountNumber, nameLAST, nameFIRST, nameCOMPANY, addressSTREET, addressSTREET1, addressCITY, addressSTATE, addressZIPCODE, phone, fax, email) VALUES('" & TextBoxAccount.Text & "','" & TextBoxLastName.Text & "','" & TextBoxFirstName.Text & "','" & TextBoxCompanyName.Text & "','" & TextBoxAddress1.Text & "','" & TextBoxAddress2.Text & "','" & TextBoxCity.Text & "','" & ComboBoxState.SelectedItem & "','" & MaskedTextBoxZip.Text & "','" & MaskedTextBoxPhone.Text & "','" & MaskedTextBoxFax.Text & "','" & TextBoxEmail.Text & "')"[/code2]

Your help would be greatly appreciated.

Thanks.

Hello i thought id better join the forum as ive really enjoyed watching and learning from Brandonio's Visual Basic tutorials on youtube.

Thanks

<!-- s --><img src="{SMILIES_PATH}/icon_e_biggrin.gif" alt="" title="Very Happy" /><!-- s -->

I found this interesting article online describing how various famous authors would write a Fibonacci series generator in JavaScript. It is entitled "If Hemingway Wrote Javascript" and it's a fun and clever read!

<!-- m --><a class="postlink" href="http://byfat.xxx/if-hemingway-wrote-javascript">http://byfat.xxx/if-hemingway-wrote-javascript</a><!-- m -->

So I have 3 forms inside a project:
1: Login
2: Launchpad
3: Irrelevant but: About

The first one that comes up upon start is "Login"
It has 2 text box forms, with "Username" and "Password"
and then a login button (See code Below)

My problem is, I have it set to if the login information is correct, close the "Login" window and open the "Launchpad" Form. And what happens is, when I fill it out correctly, and click login, it opens launchpad really fast and then closes everything. Please help.

Please post a reply to this thread with your YouTube username. This will earn you one extra entry in the website giveaway.

For more information, view the video here:
<!-- m --><a class="postlink" href="http://www.youtube.com/watch?v=T5_flbG8E4E&feature=youtu.be">http://www.youtube.com/watch?v=T5_flbG8 ... e=youtu.be</a><!-- m -->

This giveaway is over! The results video can be viewed here:
[youtube]pkkWEEEwFgk[/youtube]

Hey guys,

It's me again - still learning vb.net actively and getting lots of help from communities such as this - thanks!

So, I came across the following code that can be used in a vb.net application to validate a credit card number. How would I use this in my application? I was thinking of creating a module, and then calling the module in the LostFocus event of the TextBox holding the string. However, what I couldn't figure out was how to pass the string to the code in the module. In other words, how does the module know to validate the credit card number entered in the TextBox?

Here's the code.
SOURCE: http://www.robin-janssens.com/misc/luhn-...t-generic/

Quote:Function 'ValidLuhn' doesn't return a value on all code paths. Are you missing a 'Return' statement?

Hey guys,

I am building an in-house application to store all our customer credit card information in a MySQL database. What I want to do is to take user input of the Credit Card number without any formatting (eg., 1111222233334444) and format it based on the Card Type selected by the user.

TASK #1: FORMAT CREDIT CARD NUMBER
I've tried the following to do the first part, but when I debug the formatted number shows up as ####-####-####-#### instead of the number with dashes.

Hi Brandonio I have seen your videos in youtube I am amazed with your programming skill and also I want to say hi to the rest of the master coders here...

I have problem here if you guys would like to help me how to create a source code on how to add , edit, update , and search in OPAC it is used in Library

I already have my simple log in here and its working but I don't know how to make it Case sensitive on username and password I have the download link here more information about this program

donwload link :
<!-- m --><a class="postlink" href="http://rapidgator.net/file/34577580/LabExer2.pdf.html">http://rapidgator.net/file/34577580/LabExer2.pdf.html</a><!-- m -->

Thanks

Quote:Imports System.Data.OleDb
Public Class LogIn

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim form1 As New Form1
Me.Hide()
form1.Show()
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Mycon As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Ace\Documents\Admin.mdb")
Dim cmd As OleDbCommand = New OleDbCommand( _
"SELECT * FROM Admin WHERE Username = '" & _
TextBox1.Text & "' AND [Password] = '" & TextBox2.Text & "' ", Mycon)
Mycon.Open()
Dim sdr As OleDbDataReader = cmd.ExecuteReader()

If (sdr.Read() = True) Then
MsgBox("Successfully Login", MsgBoxStyle.Information, "Log In Passed")
Dim mainForm As New Book_Info
mainForm.Show()
Me.Hide()
Else
MsgBox("Invalid username or password!", MsgBoxStyle.RetryCancel, "Log In Failed")
TextBox1.Clear()
TextBox2.Clear()
End If

End Sub
End Class

I've been doing some research and I've been seeing many things about something called LINQ. It looks like a way to build complicated SQL queries but it is very hard to understand. Does anyone have any tips that would help LINQ make more sense?

I made my own query and I had this error pop up:
Cannot perform 'Like' operation on System.DateTime and System.String.

I don't understand why I get this error but this is my code.