4,911 Posted Topics
 | My given names are Richard James but my mother decided I should go by my middle name which is a royal pain in the a$$ because every bleeding form in the world asks for my first name and maybe my middle initial. Thus, whenever the receptionist in the doctor's office …  |
| | Never have, never will. My dad suffered from emphysema after smoking for 40 years.  |
| | It might be the double comma at @dtaGender,,Telephone and since you are using parameters everywhere else why not change WHERE EId='" & Me.MaskedTextBox6.Text & "'" to WHERE EId=@EId  |
| | Normally when you do a join you specify a common (related) field. When you do a join without doing this you end up with a recordset that contains the product of each table. For example, If you have 6000 records in one table and 400 in the other you will …  |
| | Re: Key press event This is the vb.net forum. Please post your question in [vb 4-5-6](http://www.daniweb.com/software-development/visual-basic-4-5-6/4) |
| | I've used both Melody Assistant and its bigger brother, Harmony Assistant from [Myriad Online](http://www.myriad-online.com/en/index.htm). I used the Virtual Singer add-on to create four-part vocal tracks for my quartet for learning the various vocal parts.  |
 | If you mean expanding/collapsing long code segments it was answered [here](http://www.daniweb.com/community-center/daniweb-community-feedback/threads/452314/when-codes-get-long) |
 | Without getting into all the other stuff, if you want to know the highest number in a column you can use the MAX function as in SELECT MAX(PrinterID) FROM ... |
 | The most complex program I ever wrote was when Westinghouse was developing our first AGC/SCADA system (in service 1983-1998). Although Westinghouse developed the codebase, it was up to us to create the databases. This was done using a DDL (data definition language) which was used to create the hierarchical database …  |
| | The following lists all of the subkeys under HKCU\Software Dim key As Microsoft.Win32.RegistryKey = My.Computer.Registry.CurrentUser.OpenSubKey("Software") For Each subkey In key.GetSubKeyNames Debug.WriteLine(subkey.ToString) Next |
| | Re: Windows 8 I hate Metro, however, StarDock is offering a new (reasonably priced) utility called ModernMix which will allow you to run all of the Metro (full screen) apps in windows just like regular desktop apps. Using that would allow you to run Metro apps on multiple desktops. They can also be …  |
 | According to a very old joke, "tickle your a$$ with a feather?". If she takes offense you reply "I said, typical nasty weather". That breaks the ice for further conversation. However, if she replies "Sounds kinky. Let's do it" then further conversation isn't really necessary. |
| | The preferred way is to use parameters. Because you are using MS SQL I will assume you are using SqlClient and not OleDb. cmd.CommandText = "INSERT INTO PRINTERMAINT(PrinterName, PrinterNumber, PrinterLocation, PrinterAddress) " & _ "VALUES (@prtName, @prtNo, @prtLoc, @prtAdd)" cmd.Parameters.AddWithValue("@prtName", printName) cmd.Parameters.AddWithValue("@prtNo", printNo) cmd.Parameters.AddWithValue("@prtLoc", printLoc) cmd.Parameters.AddWithValue("@prtAdd", printAdd) |
 | You'll find several people here who love the stuff. Various ages as well. For example, I'm 59. Go to the advanced search (Click on Search but don't enter a search string), then use **Anime** for the search string and **Geeks Lounge** for the forum and you'll get numerous hits. So, …  |
| | What have you got so far and what are you having problems with? Do you know how to connect to the database? Are you unsure of the syntax of an insert query? Do you know how to iterate through the rows of a listview? |
 | You could get rid of 90% of your code by trying the following: Create a dictionary where the key is a word in the word list and the value is the address of the associated label. For example (using 3 words and labels) Private wordlist As New Dictionary(Of String, Label) … |
 | If you think that we will do your homework for you then you are sadly mistaken. We've got better things to do and you won't learn anything if we do. |
| | VB will flag a problem if the variable is set inside another block. For example Dim s As String If x > 5 Then s = "bigger" End If Msgbox(s) will indicate a problem because there is an execution path where s does not get assigned a value. I have …  |
| | Your first problem (and this is a biggie) is that you have included no comments with your code. It is hard to say if your code is doing what it is supposed to do when there are no comments saying what it is supposed to do. Your second problem is … |
| | This has been asked and answered several times in this forum. Click on **Search** then enter **application settings** for the search string and vb.net for the forum. |
| | The most important quality you will need as a professional programmer (or a professional anything) is the ability to communicate clearly. Reread your initial post and consider that. Yes. This is a snotty comment. But it is an important lesson. |
 | Re: Need an advice I found programming a lot like the game of bridge. The bidding conventions can be complex but at some point a switch gets thrown in your brain and you understand without having to consciously think about it. With programming, it just takes practice and perseverence to get to the point … |
| | I'm going to make a few assumptions - the database will always be MS SQL - the database name will never change - the security type will be **integrated security** based on those assumptions, the only thing you should ever have to modify from installation to installation is the SQL … |
| | If you just try to open the vb6 project in vb10 it should automatically start the conversion wizard. It will take you through the conversion and ask you if you want to see the resulting log file when done. In my experience it does a decent job of converting. If … |
| | I set up a sample table using the MS SQL NorthWind database as a start. The table has ProductName CategoryName where there are multiple products which fall into one of 8 categories. The following query select CategoryName,COUNT(CategoryName) as Frequency from temp group by categoryName produced CategoryName Frequency ========================= Beverages 12 … |
| | It's not so much that you can't remember names so much as you don't bother to remember them (my problem). I find that the best way to remember soneone's name is to immediately use it a few times. For example, when you are introduced to someone, instead of saying, "pleased … |
 | You can format the output using .ToString("yyyy-mm-dd") as in Now().ToString("yyyy-mm-dd") |
| | As far as I know you cannot add a progress bar because the upload is being done in a single statement and there is no way to determine how much of the file has been uploaded at any given time. However, if you broke the upload into chunks and wrote … |
| | If the field is of variable length then use nvarchar. Just make sure to do a **Trim** on the text when you patch in the parameter. What goes into the field is exactly what you tell it to. The spaces are there because they were in the original text field.  |
| | You can do an integer divide more simply by intTotalAsterisks = intSales \ intASTERISK And you don't need the if-then-else for the zero case. You can just do Dim strAsterisks As New String("*", intTotalAsterisks) Your indentation is extremely misleading. Redo it so that it is obvious which code belongs to … |
| | >Im not sure what to do with the dropdown menu if the user selects fragrance...? I don't see that you need a drop down list **inside** the listbox. It would just be an option that would be available (enabled) as long as the selected package included a scent. The default … |
| | Let's not. It takes up space on the Daniweb servers and serves no useful purpose. |
| | >made me a bit cynical I suppose You'd never know it from your picture :-)  |
 | AFAIK "rank" cannot be bought. It must be earned.  |
| | Re: SQL query on CSV You don't put single quotes around field names. Because your names have embedded blanks try putting the field names inside square brackets as in **[my field name]**. When you say SELECT myfield what gets returned is the value of **myfield** for all records. When you specify a literal like SELECT … |
 | Background threads cannot access controls directly. They have to use delegates. They are not that complicated and you can see an example of how to do that [here](http://www.daniweb.com/software-development/vbnet/code/440614/backgroundworker-ip-monitor) |
| | Re: Sites Can't suggest anything offhand but There have been some pretty interesting conversations about various topics in this forum. If you want to start a conversation just post a thread with a topic or topics of your choice. We have more than a few intelligent (and opinionated) people in this community … |
| | The **Split** method will allow you to convert the line into a string array. You can split on any character but the default is a blank so if you start with Dim line As String = "roivic lanoria ASRock 2.4 GHz Dual Core SSD 160 GB" then do Dim fields() … |
| | |
| | You can read the entire file into a string array by Dim text() As String = System.IO.File.ReadAllLines(filename) If the file contains many lines and you only want one (assuming you can uniquely identify a line by, for example, the email address) you can do Dim email As String = "heburn@YAHOO.COM" … |
 | One big thing is to avoid duplication. Another is to partition your data. For example, information in the **Students** table should contain information that is mostly static. This would be information like student name, address, date of birth, phone number, etc. All other tables that refer to a student require … |
| | It would help to see the code you are using to add in the parameters in case there is a problem there, but for now try SQL = "SELECT s.FirstName, s.MiddleName, s.Surname, p.* " _ & " FROM tblstudents AS s, tblpayments as p " _ & " WHERE s.studentid … |
| | Re: Syntax habbits. I try to strike a balance in my use of whitespace. Ifindthattoolittlemakesthecodehardtoread and too much can also be a pain. |
| | Re: Online Learning There is a good online tutorial [here](http://channel9.msdn.com/Series/Visual-Basic-Development-for-Absolute-Beginners) |
| | Execute the query SELECT @@VERSION You'll get back something like Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86) Sep 22 2011 00:28:06 Copyright (c) 1988-2008 Microsoft Corporation Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1) |
| | Dim qry As String = "insert into Department(DNo,DName,Manager,AddressL1,AddressL2,City,Telephone,E-mail)values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "' )" Debug.WriteLine(qry) Then copy the output and post it here. … |
| | There is something in place already. If you have email notification enabled then you will be notified when you are upvoted or downvoted (at least with a comment). |
 | You can also get the drive activity if you have too little RAM and too many programs starting up automatically. You end up with a lot of page swapping. The solution is to add RAM or to remove programs from the startup list. There are several ways to determine what … |
| | The simplest method is - connect to the database - select records from one or more tables (query) - copy the data from the retrieved records into a display control The type of interface you use will depend on the type of database. For example, if you are using a … |
| | Almost 500 lines of code and you couldn't even bother to tell us what line was throwing the error? Not cool. |
The End.