Reverend Jim

Malware on a new computer, spyware on the hard drive/controller, spyware in the routers. What's a techie to do?

You have to add adodb to the project. Project -> Add Reference .NET tab Sort by component name select adodb

At least you took the time to ask politely, unlike several other people who have recently posted theor homework verbatim.

I find it particularly annoying that not only do you expect us to do your homework for you but you can't even be bothered to ask. You just post the question and expect us to do the work for you. You get a downvote for your lack of effort.

I find it particularly annoying that not only do you expect us to do your homework for you but you can't even be bothered to ask. You just post the question and expect us to do the work for you. You get a downvote for your lack of effort.

I find it particularly annoying that not only do you expect us to do your homework for you but you can't even be bothered to ask. You just post the question and expect us to do the work for you. You get a downvote for your lack of effort.

Example. Iterate over all columns to change the entire row. dgvNames.Rows(row).Cells(0).Style.BackColor = Color.Thistle

I'm doing it right now.

The **Teams** table should contain all information unique to a team so why not include the Division as well. By adding the DivisionID to the Teams table you have created the relation without having to create a linking table. It is possible to take normalization too far. I also suggest …

[This article](http://www.codeproject.com/Articles/5468/ways-of-integrating-MATLAB-with-the-NET) connects the two via C\#. It may provide some help.

I agree with you on the first comment. If I was just left to my own programming I'd get better in only a few areas at the expense of many others. By answering questions on Daniweb I stretch myself in other areas and keep current in areas (like SQL) that …

A listbox can hold any number of lines. If you mean that it limits the number of visible lines, you can change that by changing the Height property. If you do ListBox1.Height = ListBox1.ItemHeight * (1 + ListBox1.Items.Count) then, assuming the form is big enough, the listbox will display all …

Sounds like Explorer crashed. To restart it, press CTRL-SHIFT-ESC to bring up the Task Manager then File -> New Task (Run...) Enter `Explorer` for the task name and click `OK`. It should restart your desktop.

If you are using SQLEXPRESS (free), the database size is 10GB.

Installing an application is more than just copying files to a folder (which it may be possible to undelete as long as the disk areas have not been overwritten). It usually involves things like registry changes and such. If you have uninstalled an application and want it restored you could …

Even if CD booting is enabled, you may also have to hit a specific key during boot to select an alternate boot device. For example, on my Dell it is F12.

Only a ton. See [here](http://en.wikipedia.org/wiki/Comparison_of_Visual_Basic_and_Visual_Basic_.NET).

We don't provide code on demand, however, if you show that you have put in some effort to solve the problem yourself we can help you work toward a solution.

What do you mean by "refreshing"?

Try this format bcp emdb..Patch2 out D:\shares\patch2.txt -c -T -S GEN-SERVER\EMMSDE

If the file isn't there then you will have to contact someone [here](http://www.ftsm.ukm.my/).

Try [testdisk](http://www.cgsecurity.org/wiki/TestDisk). It's free and open source. I haven't had the occasion to try it out but I've read good things about it. There is a [step by step here](http://www.cgsecurity.org/wiki/TestDisk_Step_By_Step).

Try SELECT (SELECT SUM(total) FROM icm.sales) AS branch1_sales, (SELECT SUM(total) FROM hism.sales) AS branch2_sales

Use the USERNAME environment variables. On my machine with my current account it is USERPROFILE=C:\Users\Jim You can see the resulting command by echo rd %USERPROFILE%\\.digilabs\ubuildabook\data If you use two backslashes before the "." when you post you get C:\Users\PC\\.digilabs\ubuildabook\data

You might need to do it from the command prompt running as Administrator. Assuming your logonid is Eileen you will have to check both C:\Users\Eileen\Desktop C:\Users\All Users\Desktop Do a `dir` from both locations. You should see the folder from one of them. Then use the `rd folder /s /q` command …

A better method is to use the KeyDown event to suppress unwanted keys Private Sub TextBox1_KeyDown(sender As System.Object, e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown Select Case e.KeyValue Case 50 To 59 'allow digits Case 8, 37, 39, 46 'allow bs, left, right, del Case Else e.SuppressKeyPress = True End Select End …

Awesome.

To get the table names depends on your database. For MSSQL you can do SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' or SELECT name from sys.tables I think for MySQL it is SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA='dbName'

Is your database set to use case sensitive strings? Try SELECT COUNT(*) FROM route WHERE van = 'van1' SELECT COUNT(*) FROM route WHERE van = 'Van1' and see how many records are returned.

There is nothing wrong with using MS Access for student project database. It's when you want to make a database of any significant size that it becomes a problem. As for the original question, you have to show us that you have put some effort into the program before we …

That doesn't address the question of whether you **should** be storing the file at that location. Just because you **can** do something doesn't mean that you should. What is the purpose of that file? Is it an all users file or is it specific to each user? Perhaps a better …

I'm not sure I see the problem. If you run osk.exe then click in a textbox to give it focus, whatever keys you click in osk will be sent to that textbox. If you want the keys to go to a different form or textbox then give that textbox focus.

You'll have to post the table structures along with a description of what you are trying to do with the query.

Try sql = "Update TBLORDERS " & " set qty = qty + ?," & " price = price + ?" & " where nod = ?" You were missing a comma.

This sounds like a homework question so I won't post the code but I can suggest that you use a regular expression to match "go" between two non-alphabetic characters.

It's just a string. Change it like any other string. If you don't know what to change it to please refer to [connection string reference](http://www.connectionstrings.com/).

What happens if you use the actual column name in the query like SQL = "SELECT ID FROM ReqItemList WHERE ReqItem = " & inputin When you are doing a SELECT it doesn't matter if the column is AUTONUMBER or not.

When you buy a hot dog at a baseball/football game you never know if you are getting a fresh one, or one that was leftover from the last game and just reheated. I know several people who worked the games as vendors and they said that this was common practice.

Tell me about it. Bluetooth was supposed to be the communication protocol that solved all of our communication problems. After two years of intermittent experimentation (and hours wasted with tech support via email and phone) I was unable to get either the built-in bluetooth (Dell Inspiron) or two external Bluetooth …

And we have yet another thread where the OP goes away without posting the solution that he/she figured out.

I suggest the following method to display a picture in a PictureBox from a file Dim fs As New System.IO.FileStream(FileList(indx), IO.FileMode.Open, IO.FileAccess.Read) pbxPicture.Image = System.Drawing.Image.FromStream(fs) If you load the picture directly (without using a FileStream) you end up locking the file. Using a FileStream releases the file once it has …

There is an example of that [here](https://www.daniweb.com/software-development/vbnet/code/464769/export-listview-to-excel-spreadsheet) in the code snippets titled **Export ListView to Excel Spreadsheet**.

You could try the following using regular expressions Dim Files() As String = System.IO.Directory.GetFiles("D:\Utils") Dim fltr As New ArrayList Dim opt As RegexOptions = RegexOptions.IgnoreCase 'Add all filenames starting with CE For Each file As String In Files Dim basename As String = My.Computer.FileSystem.GetFileInfo(file).Name If Regex.IsMatch(basename, "^CE.*", opt) Then fltr.Add(basename) …

I support Windows for several friends/relatives and it has been my experience that those who use "automatic driver update" utilities just end up with problems. My advice is not to update a driver unless it fixes a known problem. For example, don't update a video driver unless the update is …

Rather than checking the text length you should check if the textbox contains a number. This wouuld not require trimming and would also ignore non-numeric entries such as "abc". The following code should be reasonably self evident. Dim nums As New ArrayList For Each txt As TextBox In Me.Controls.OfType(Of TextBox)() …

Try something like Button1.BackgroundImage = New Bitmap("d:\temp\test.jpg")

Whiskey, tango, foxtrot?

How about SELECT (SELECT SUM(sold) FROM veggies) + (SELECT SUM(sold) FROM flowers) AS total

Never heard of it.