-
Replied To a Post in If record exists in MySQL Table then <<Some Code>>
See [here](http://www.daniweb.com/software-development/vbnet/code/445801/use-parameterized-queries-to-avoid-sql-injection-attacks) -
Replied To a Post in My Dell Inspiron Beeps at Random Times
So far all I can find is the beep codes at POST. I don't get any errors or beeps at POST, just randomly while running Windows. -
Replied To a Post in Data Base question.
Regardless. You are still asking for someone to do your homework for you. You haven't shown us that you have put in any effort. -
Gave Reputation to Ancient Dragon in Contrary to Popular Belief...
contrary to popular belief, the Earth is flat and the sun revolves around it. The Earth is also only 10,000 years old. -
Replied To a Post in Which laptop should I buy?
When a good brand (Toshiba) makes a bad laptop, admits to fault and still charges you to fix/replace the laptop, in my mind that brand becomes a bad brand. -
Replied To a Post in Which language now??
FORTRAN has always been the winner for number crunching because it produces the most highly optimized code. C/C++ runs a close second but is still slightly behind. The major reason … -
Replied To a Post in If record exists in MySQL Table then <<Some Code>>
Let's look at the statement Dim MySQLStatement As String = "INSERT INTO player_log (Last_Name, First_Name) VALUES (' " & TxtLastName.Text & " ' , ' " & TxtFirstName.Text & " … -
Created My Dell Inspiron Beeps at Random Times
I have a Dell Inspiron 1720 running Windows 7 Pro. At random times throughout the day it says "boop" (a short, mellow toned beep). It is not associated with any … -
Edited Is it possible to count instances of a boolean test?
Is it possible to count the instances of a for-each boolean statement. for example, say you have patients in a hospital and certain criteria must be met to discharge them. … -
Created Contrary to Popular Belief...
Cliven Bundy does not have the "ancestral rights," claimed because his family had worked the land since the 1870s, before the creation of the BLM. In fact, according to Clark … -
Marked Solved Status for Check if record exist in SQL database
I found this along my way of trying to learn how to use databases 1."SELECT usname, password FROM userinfo " & 2." WHERE usname = '" & textbox1.Text & "'" … -
Replied To a Post in Three Separate Questions
You can play mp3 (or wav) files in the background by embedding the windows media player. Add a project reference (COM tab) to Windows Media Player Add **Imports WMPLib** At … -
Replied To a Post in Three Separate Questions
Question 1 Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click Cursor.Position = MousePosition + Button2.Location - Button1.Location End Sub Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles … -
Replied To a Post in Check if record exist in SQL database
I would code it as Private Function UserExists(fname As String, lname As String) As Boolean Dim con As New MySqlConnection(SQLConnect) con.Open() Dim cmd As MySqlCommand = con.CreateCommand cmd.CommandText = "SELECT … -
Replied To a Post in Check if record exist in SQL database
You don't need a datareader. All you need to know is if you have a record that matches the username and password. cmd.CommandText = "SELECT COUNT(*) FROM userinfo" & " … -
Replied To a Post in Uncheck multiple checkboxes with a few lines of code
You could extract the numeric portion of the name like For Each cbx As CheckBox In Me.Controls.OfType(Of CheckBox)() Dim num As Integer = CInt(cbx.Name.Substring(8)) If num >= 1 And num … -
Replied To a Post in Uncheck multiple checkboxes with a few lines of code
The reason is that Me.Controls("CheckBox" & i) evaluates to a generic control and while a generic control has a **Visible** property, it does not have a **Checked** property. That is … -
Replied To a Post in Which laptop should I buy?
I've never personally had a problem with Dells and there have been five in my immediate family. On the rare occasions I've had to get service it was always easily … -
Replied To a Post in Show ''0" when data have null values...
You could use the COALESCE function. Given two or more parameters, it evaluates to the first parameter that is not null. SELECT fieldName = COALESCE(fieldName,0) FROM myTable SELECT fieldName = … -
Replied To a Post in for Saving
Judging by the other post I'm assuming MS Access. I suggest you have a look at the [W3 SQL Tutorial](http://www.w3schools.com/sql/sql_intro.asp) -
Replied To a Post in for saving
Is there a question? -
Replied To a Post in Alternative careers for Computer Science degree holders
No real information but I do have an anecdote. Back in the '80s I was part of a team of five programmers who maintained an AGC/SCADA system (rrealtime). My boss … -
Replied To a Post in Need some database help
We are not going to teach you everything you need to know about databases. I suggest you do a little googling. You can start with [W3 SQL Tutorial](http://www.w3schools.com/sql/default.asp?PHPSESSID=300ae3404d5fa2612f238abeebb8869c). -
Replied To a Post in Text Colour
And even if it is read only you can still set the background colour to anything you want. Or you could just use a label control. -
Replied To a Post in Alternative careers for Computer Science degree holders
Have you considered a career in technical writing? Your thoughts are clear and well organized and you seem to have a good grasp of proper grammar. There is a demand … -
Replied To a Post in What is your favorite English word?
I always thought it was"upsy daisy". -
Replied To a Post in edit a connected database
Please post your code. My guess is you are modifying the in-memory copy of the table but not saving it to the database. -
Replied To a Post in Error String Conversion To Boolean
That's not quite true. To get the short-circuit form you have to use If Not_Business OrElse IsEmpty(DOB.Text) Then If you use **Or** or **And** instead of **OrElse** or **AndAlso** then … -
Replied To a Post in Auto-displaying identity primary key on a textbox
Then you can get the next available ID number by SELECT nextID=MAX(ID)+1 FROM mytable Just remember not to specify ID when you save the record or you will get an … -
Replied To a Post in Running 2 commands one after the other??
What is the code behind **Knock()**? You could always create a sound file that has the desired sound repeated. Then you would only have to call the routine once as … -
Replied To a Post in Auto-displaying identity primary key on a textbox
Do you mean that when you bring up a blank form (so you can create a new entry) the ID number of the record that will be added is displayed? … -
Replied To a Post in Error String Conversion To Boolean
What is the problem? -
Replied To a Post in Error String Conversion To Boolean
If DOB.Text = "" Then Not_Business = True MessageBox.Show("missing dob") End If -
Gave Reputation to jwenting in Practical uses of algorithms
given a website, make a temporal distribution of homework questions over a period of one month. -
Replied To a Post in Error String Conversion To Boolean
The statement Not_Business = True & MessageBox.Show("missing dob") is invalid. MessageBox returns type DialogResult. You have to compare that result to something to get a boolean. Example If MessageBox.Show("missing dob") … -
Replied To a Post in Sql Connection + Ini file
There is no such thing as a SQL form, and reading information from an ini file does not require SQL. -
Replied To a Post in Search command issue
Try rec.Open "select * from Body_Markings_new where [Part Number] like '%" & txtsearch.Text & "%' ", conn, adOpenDynamic, adLockOptimistic It's my own preference, but I always avoid putting spaces in … -
Replied To a Post in Why does Windows XP refuse to die?
Do you think you can still get parts to repair your old 8-track cassette deck? Or any cassette deck? How long do you expect car manufacturers to keep supporting old … -
Replied To a Post in Bad Grammar
He could have written >Imagine no more countries. -
Replied To a Post in Replacing the Enter key behaviour with Tab behaviour
You could always specify a specific action for each handler if you use the first approach. -
Replied To a Post in Replacing the Enter key behaviour with Tab behaviour
The last four parameters are forward true to move forward in the tab order; false to move backward tabStopOnly true to ignore the controls with the TabStop property set to … -
Replied To a Post in Replacing the Enter key behaviour with Tab behaviour
I think a better way to do this would be Private Sub TextBox1_KeyPress(sender As System.Object, e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress If e.KeyChar = vbCr Then Me.SelectNextControl(Me.ActiveControl, True, True, True, True) … -
Replied To a Post in error on boot up
POST stands for Power On Self Test. If you are getting this message then you may have a hardware problem. Is there a boot option to boot into a diagnostic … -
Replied To a Post in Get paid to answer questions
Or a daniweb logo you could print on a decal and apply to a blank mug. -
Replied To a Post in Which language now??
There's an old saying (I don't know who said it first) that goes "I write all my time critical routines in assembler and all my comedy routines in BASIC.". Having … -
Replied To a Post in regular expression in vb.net
A handy reference for regular expressions can be found [here](http://www.regexr.com/). It also includes an area for interactive testing of regular expressions. You can use the provided sample text or paste … -
Replied To a Post in Programming Sucks
The good part is there is never a problem making decisions (and you can still get advice from other people - you just don't have to take it). The bad … -
Replied To a Post in Programming Sucks
For my first 2 years or so of professional programming I was a one-person shop. I did the conception, design, coding, debugging and integration. I didn't know how good I … -
Created Programming Sucks
This is just too good not to share with everyone. >The only reason coders' computers work better than non-coders' computers is coders know computers are schizophrenic little children with auto-immune … -
Replied To a Post in Which language now??
Nobody can say with any certainty what languages will still be around in 20 years. Even 5 years is difficult with some. If you want to port old VB programs …
The End.