4,911 Posted Topics
 | 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") |
| | |
| | How about SELECT (SELECT SUM(sold) FROM veggies) + (SELECT SUM(sold) FROM flowers) AS total |
 | |
| | Put a breakpoint at lvorder.Items(i).Text = (Val(lvorder.Items(i).Text) + 1).ToString and see if the code stops there. If not then you are never getting a match. In that case put a breakpoint at If lvorder.Items(i).SubItems(1).Text = btn.Text Then and step through each iteration of the loop and check the values oof … |
| | Re: Feedback I'd estimate I spend anywhere from 1-3 hours per day on DaniWeb. When I started as a noob back in 2010 I had already been programming for over 30 years but never in vb.nbet so I didn't need help with technique algorithms as much as I did with vb.net specific …  |
| | People have to sign up for this? Amazing! In my reality, if I want to cut down on something I just fucking do it. A few years ago, Richard Jeni (a brilliant comic whom we lost all too early) had a bit on a new diet plan. It was called … |
| | If you are calculating the tootal price for each dish you need to know 1. the quantity 1. the price per unit (the rate) Your table only has columns for 1. the quantity 1. the name of the dish 1. the total price You need to add a column indicating … |
| | Use **@name** parameters with SQLDB. For OleDB you have to use **?** as s placeholder. Plese see [Use Parameterized Queries to Avoid SQL Injection Attacks](https://www.daniweb.com/software-development/vbnet/code/445801/use-parameterized-queries-to-avoid-sql-injection-attacks). When using SQLDB, parameters can be added by name. With OleDB you must add them in the order in which they appear in the query. |
 | Re: Laptop choice Until last month I would have whole-heartedly recommended Dell. However, I have spent the last month in Dell Hell and can no longer give them my support. They useed to have excellent (really top-notch) after sales support. Now it's just an exercise in one useless conversation after another with people … |
 | Re: Inventory System Please have a look at [this](https://www.daniweb.com/software-development/visual-basic-4-5-6/threads/484380/please-read-this-before-posting) first. Pay special attention to \#5. I suggest you start by googling **sample table structure for inventory database**.  |
| | I also suggest that it is bad form to omit field names when doing inserts. You should force correspondence between field names and values by using the form INSERT INTO tablename (fldname1, fldname2, ...) VALUES(value1, value2, ...) I don't have SQL installed at the moment (new laptop) but as I … |
| | You have to give us actual code. If TextBox1.[dont know what to type here] = True Then does not qualify. May I also suggest you name your controls more clearly. For example, txtUsername and txtPassword instead of TextBox1 and TextBox2. And your explanation is still very confusing. |
| | Helping by Skype would not benefit anyone else on the forum. |
| | Adding more controls than can be shown will not activte the scroll bars. You have to add text to do that. |
| | >Then use them to prove to me that gravity is a lie Well obviously since nobody knows how gravity works then it's only a "theory" like the theory of evolution and we all know that that is a lie. Therefore gravity doesn't exist. >smoking has no health risks what so … |
| | Declare an integer at the class level as in Private ButtonClickCount As Integer = 0 Then in the button click event handler do ButtonClickCount += 1 Me.Text = "Current count = " & ButtonClickCount This will display the count in the title bar. Replace the last line to copy the … |
 | I haven't got SQL installed at the moment so I can't code and test something but I have used the following Private Sub btnRetrieve_Click(sender As System.Object, e As System.EventArgs) Handles btnRetrieve.Click Dim con As New SqlConnection("Server=.\SQLEXPRESS;Database=mydb;Trusted_Connection=yes;") Dim cmd As New SqlCommand("", con) Dim file As String = "D:\temp\test.docx" cmd.CommandText = …  |
| | For OleDB you use **?** for the parameters as follows: sql = "UPDATE tbdishlist SET " & _ "qty = qty + ?, " & _ "price = price + ? " & _ "WHERE nod = ?" acscmd.Parameters.AddWithValue("@qty", qty) acscmd.Parameters.AddWithValue("@price", price) acscmd.Parameters.AddWithValue("@name", name) |
 | From Windows, run DISKMGMT.MSC. That will show you the disks and partitions. Take a snapshot of the window (ALT-PRTSCR) and post it here. The bottom pane of disk manager will be the most useful so size it so all disks are shown. |
| | Re: Help! It is not necessary to delete all of the partitions on the drive. I always recommend two partitions, C for the OS and apps, and D for user files (I make them both Primary). If you already have this setup then you need to reformat only the C partition - … |
| | Please provide a little more detail. |
| | Dani: I've started getting duplicate notifications by email. I forwarded them to your regular email address. |
 | I can't say enough good things about [SpinRite](https://www.grc.com/spinrite.htm) |
| | You talk to the customer to determine the requirements (specs) then you develop the code. Along the way you might decide to prototype a GUI for the customer to approve. If you have to go farther back then you start by learning how to program and how to use databases. … |
 | My vote goes to Heath Ledger. Jack Nicholson is limited by the fact the every character he portrays is basically just a slight variation of himself. Nicholson's Joker was more like circus clown. Ledger's Joker was more like Tim Curry's Pennywise. It's like comparing Mark Hammil's version of the Joker … |
 | What kind of database are you trying to add to? Is it MS-SQL, MySQL, Access, etc.? While a database could be a simple text file it usually is something more complex and can not be maintained with basic text I/O. Please provide more details and we'll try to help you. |
| | Parameterrs in OleDB are specified with **?** rather than **&parm**. See [here](https://www.daniweb.com/software-development/vbnet/code/445801/use-parameterized-queries-to-avoid-sql-injection-attacks) for a working example. |
 | It's a hidden folder. You have to enable "Show Hidden Folders, Files and Drives" in folder view. |
 | >Why do so many people expect to be rewarded... I don't know about other places, but here in Winnipeg there was talk a few years ago about something which I believe is at the root of the problem. Some teachers felt that it was proper to give either a lower … |
| | The simplest way is to just copy the database file to wherever you want to store it. |
| | |
| | Start by taking the string from the textbox and adding a blank at the front. Then scan through the entire string and check each character. If a character is non-blank and is preceded by a blank then add that character (upper case) to your output string. Once you have finished … |
| | Re: retrieve data See [here](https://www.daniweb.com/software-development/vbnet/code/445801/use-parameterized-queries-to-avoid-sql-injection-attacks) for examples using SQLDb and OleDB. |
 | My older son was always an avid reader. With him it was mostly books on science. He is now doing a post-doc in bio-physics. When my younger son was in early school he liked to read the Goosebumps books by R L Stein. His teacher at that time discouraged him. … |
 | If there was an online storage option that would store my files encrypted (including file names) where the encryption key was stored only on my computer then I would likely use it. I realize that I can use truecrypt to create a container which I could then use on DropBox, … |
 | Re: Upgraded editor **Problem 2** I've been having this problem - I click in my text to position the cursor and the cursor does not move there. **Problem 3** For longer posts I use either Textpad or Markdown Pad then copy/paste to Daniweb. |
| | Save the date and time when the app was first run, then just pop up a nag and exit if it is mote than one year old. The first-run date could be saved in a Settings variable or the registry (possibly encrypted to prevent abuse). |
| | I've noticed that a lot of your recent questions could be answered by even a cursory reading of just about any intro to vb.net programming book or one of the many similar (free) tutorial web sites. Might I suggest you get one and read it? |
| | Re: phone number I don't see a question and you didn't bother to say what you want your code to do, but once I corrected your formatting (please use the **Code** tool to post code) it was obvious that you were missing an **End If**. You also do not do anything with the … |
 | Check with your IT department before you download and install **ANY** software.  |
 | I believe it is the exact opposite. It isn't until you shut sown that registry changes are committed to disk. That is why if you get a BSOD or just power off without shutting down some changes go away. |
| | |
 | Re: warm or cold? Cold. You can always add clothing if you are cold. You can only take off so much when you live in the heat. I've been to Arizona in the heat of August (+45C), It was brutal. On the other hand, here in winter it can go to -40 and I … |
The End.