4,901 Posted Topics
 | The most common connections are 1. ADO 1. SqlClient 1. OLEDB ADO is the underlying connection behind both SqlClient and OLEDB but provides only basic functionality. SqlClient is used for connecting **only** to SQL databases but has the advantage of supporting named parameters (don't worry about that for now). OLEDB …  |
| | I set up two laptops for relatives and I just put on Microsoft Security Essentials. I've read good reviews from several sources including [Ask Leo](http://ask-leo.com/) and [Windows Secrets](http://windowssecrets.com/). |
| | Simpler way is Date.Today.ToString("yyyyMMdd") |
 | >Poor sod got banned from the BBC for it. Too bad. It was an amusing story that makes a great point about language.  |
 | Keep in mind that if you eliminate the column names then the values must be in the same order as the columns are defined in the table. If someone changes the column order then your query will puke or the data will go into the wrong fields. If someone adds …  |
 | Compose the query first then do the DB access later as in Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & System.Environment.CurrentDirectory & "\employeedb.mdb;") Dim cmd As New OleDbCommand("", con) Dim query As String = "SELECT * FROM Employees " Dim where As String = "" If cbox.Checked Then where &= " … |
 | This has surely been mentioned before. I've noticed an increase in the number of noobs who are resurrecting old threads. Based on what I did shortly after joining (before getting lightly slapped on the wrist), it's likely the posters just didn't notice the thread date. Apparently the purple banner isn't … |
 | > I am also brushing up on my German. Because German is such a melodic language it induces relaxation. Take the word, "butterfly" - Spanish - mariposa - French - papillon - Italian - farfalla - German - Schmetterling Or "I love you" - Spanish - Te amo - French … |
| | There is a property named AXVLC.VLCPlugin.Position that might be of use. I've never used the plugin but I noticed it while browsing the object. |
 | |
| | What have you done so far? We are not going to design it for you but if you have specific questions perhaps we can answer them. |
 | Re: Imagine Cup 2013 I'm personally not interested and I don't qualify in any case, but if you want to attract interest I suggest you provide some details as to the type of project, time commitment, timeline, scope, required skillsets, etc. |
| | Re: life It's a board game, I think by Milton Bradley. The rules of Life are probably online somewhere. Or if you meant the other thing then it's likely a subjective thing. I'm still a work in progress. I'll get back to you when I'm done. I plan to live forever. So … |
| | The first thing you should do is use parameterized queries. A simple example of how to do that can be found [here](http://www.daniweb.com/software-development/vbnet/code/445801/avoiding-sql-injection-attacks). As for doing a select, a basic select would look like SELECT * FROM ChkInOut WHERE ControlNo = '12012996' I'm assuming because you put single quotes around 12012996 … |
| | Please review the [member rules](http://www.daniweb.com/community/rules). One of them states - Do not hijack old forum threads by posting a new question as a reply to an old one. |
| | What's a floppy? Seriously, you can try [FFSJ](http://www.jaist.ac.jp/~hoangle/filesj/#Features). It's free.  |
| | We appreciate your willingness to contribute but please check the dates on posts before you respond to them This thread is more than three years old and it is likely that the original poster (OP) no longer needs help with this issue. Reviving this thread pushes more recent threads further … |
| | I'm thinking they don't have the correct version of the dotnet framework installed.  |
| | For details on how to use parameterized queries please refer to [this code snippet](http://www.daniweb.com/software-development/vbnet/code/445801/avoiding-sql-injection-attacks). It also suggests how to adjust your code formatting to make queries easier to read. |
| | I am used to seeing the categories such as Tutorials, Interviews, Code Snippets, etc at the top of the thread lists. I recently posted some code in the VB.NET forum showing how to used parameterized queries to avoid SQL injection. I wanted to categorize it as a tutorial but my …  |
| | |
| | The path and filename is just a string and if you don't know how to insert a string value into a database then you have put exactly zero effort into learning. Any beginning database programming book will show you how to do this in the first chapter or two. |
| | Please try again. I have no idea what you are asking.  |
| | On the following table Supplies ID Name Containing the following rows 1 paper 2 book 3 book 4 book 5 pen 6 pencil 7 pencil 8 pen The following query select count(*) as count,Name from supplies group by Name order by count desc returns 3 book 2 pen 2 pencil … |
| | Please post the code you are using to load and save the text. The usual way to load and save rich text is as follows: Private Sub btnSave_Click(sender As System.Object, e As System.EventArgs) Handles btnSave.Click RichTextBox1.SaveFile("d:\temp\myfile.rtf") End Sub Private Sub btnLoad_Click(sender As System.Object, e As System.EventArgs) Handles btnLoad.Click RichTextBox1.LoadFile("d:\temp\myfile.rtf") End … |
 | As tinstaafl says, you didn't say what line was throwing the error. Also, you should never (never) build queries by concatenation. That leads you open to SQL injection attacks. Build your queries using parameters. In your case that looks like strsql = "UPDATE tbl_tec_temp " _ & " SET tem_we_position … |
| | We appreciate your willingness to contribute but please check the dates on posts before you respond to them This thread is more than two years old and it is likely that the original poster (OP) no longer needs help with this issue. Reviving this thread pushes more recent threads further … |
| | There is an example of background threads [here](http://www.daniweb.com/software-development/vbnet/code/440614/backgroundworker-ip-monitor) in this forum. |
| | Re: Herge is back Welcome back. I see you are in Waterloo. Are you (or were you) associated with the university at all? I have a few friends there on the faculty of Comp Sci. |
| | A lot of code and little information. For example, what line of code generates the error? Put a try/catch around it and MsgBox the number of elements and the offending index. The index can't be larger than one less than the number of elements. |
| | If you need a driver then you should tell us - what computer - what device - what operating system |
| | >All you need to distribute is that file That is not necessarily the case. If you are creating a console app then probably. Otherwise, you have to distribute the entire folder. And that may not be enough. It depends on the infrastructure already in place on the target PC. It … |
| | Do not hijack threads, especially old ones. Please check the dates on posts before you respond to them This thread is more than four years old and it is likely that the original poster (OP) no longer needs help with this issue. Reviving this thread pushes more recent threads further … |
 | We have a friend who likes to go on about the coming apocalypse. In 2011 it was all about the Book of Revelation. Last year it was all 2012. I finally found a way to shut her up. Last year I asked her if she was convinced the world would …  |
| | I keep wanting to make a very rude joke here but it would be unbefitting of my fake honorific. |
| | Re: What to do? You haven't posted the structure of the tables so a definitive answer isn't possible, however I suspect you haven't **related** the tables. Your Employer table will need at least two fields such as **Employer** EmployerID (identity) EmployerName (varchar) And the Employee table will need the same type of fields **plus** … |
 | 1. Don't hijack threads 1. Don't resurrect old threads 1. Show some effort before you post 1. Provide some details |
| | You could try [this](http://www-rohan.sdsu.edu/faculty/rfreeman/reason.html) for starters. |
| | We appreciate your willingness to contribute but please check the dates on posts before you respond to them This thread is more than three years old and it is likely that the original poster (OP) no longer needs help with this issue. Reviving this thread pushes more recent threads further … |
| |  |
| | Use [autoruns from Sysinternals Suite](http://technet.microsoft.com/en-ca/sysinternals/bb963902.aspx). Free.  |
| | It. Laughable show but great performance (as always) by Tim Curry |
| | Normally (with just the main thread) you can access a control's properties directly as in lblStatus.Text = "online" however, if you are trying to access the control from another thread you must use a delegate. So what I do is wrap the code in a sub such as Private Sub … |
| | Re: Error in QUERY I don't have my dev machine so I can't test this but I believe the format for a date value is like select * from tble where Invoiced > #01/05/2012# so try "SELECT * FROM invoiced_filter " & _ " WHERE Invoiced > #" & fromdte & "# AND < … |
| | I just noticed the little purple dot on the threads with a pop-up indicating "user is currently online". Have I been overlooking this for a while or is this a brand new feature? In any case, I like it. |
| | There are a couple of things to try. I'm not using Windows 8 yet so I'm not sure where to find this (on Windows 7 it is under My Computer/Properties/Advanced/Environment Variables). Make sure PATHEXT includes .VBS In a command shell with admin rights, type WSCRIPT //H:wscript //S To set the … |
| | At the time of the writing of Charles Dickens', A Christmas Carol, "scrooge" was a slang word synonymous with the word, "squeeze". And "a humbug" was a person who put on false airs as in a person who behaves as if everything is rosy when his life is anything but. … |
| | My first impression is based on the initial download. One of the first things on the download page states >Your download (18.7 MB) should begin in a moment. If not, click here. However, when I do the download I end up with a 573K file that, when run, identifies itself …  |
| | Re: Sum Function >I want to get sum of total data where status is "yes" What you should provide is 1. the structure of all relevant tables 1. perhaps a few records with an example of the before and after This is particularly helpful if you are trying to explain the problem in … |
| | Please check the dates on threads before you post. This thread is more than four years old and your input is likely no longer needed. |
The End.