Search results for query: *

  1. Noremacam

    Question html table to data table?

    I haven't done much string/html manipulation before so sorry if I'm slow. I've managed to copy a webpage source into a string and I want to take one of the tables(unfortunately embedded in other tables) and make a datatable out of it, or something similar, so that I can read all the values...
  2. Noremacam

    Question NumericUpDown "selectall"?

    That's weird because its not on my list. I included a pic to show all the members it shows for me(that begin with T). It has textalign, but not text. I'm using visual studio 2008 SP1 Express Edition - if that makes any difference.
  3. Noremacam

    Question NumericUpDown "selectall"?

    There is no text property for the NUD, but I did figure it out from your example. Thanks! nud.Select(0, nudCost.Value.Length) However, this will not highlight extra zero's after the decimal place - which thankfully is not an issue with me.
  4. Noremacam

    Question intentional UPDATE exception

    This question may not be specific to mysql. How do I make an UPDATE statement that will throw an exception if zero rows are affected by the update? Or is there an alternative that I'm missing?:confused:
  5. Noremacam

    Question NumericUpDown "selectall"?

    How do I make the text(or value?) selected when I focus on the control? Textboxes have the "selectall" feature, where the NUD does not.
  6. Noremacam

    help keeping listview selection after refresh

    Sorry to be so late replying. Yes, embarrassingly, I confused the name with the text(which, was the "name" in a different context). For whatever its worth, here's the code I found that fixed it, should anyone else be looking for a solution to this: Dim strItem As String = "" If...
  7. Noremacam

    help keeping listview selection after refresh

    Lets say my listview item name is "2". It successfully copies that variable to "item". ContainsKey(item) returns false. Very confusing. I'm pulling the name of the item into the "item" variable. Then it updates the listview. If I'm understanding you correct, you're saying that what's in...
  8. Noremacam

    help keeping listview selection after refresh

    I made the correction that JohnH suggested, but now I receive a NullReferenceException at the "lstview.Items(item).Selected = True" line. I've tried fiddling around with it a bit, but I can't seem to get rid of the exception.
  9. Noremacam

    help keeping listview selection after refresh

    Thanks for the quick reply! However it seems to think, even after I fill the string that holds the item name, that the string is still null, and I'm not sure why. Dim item As String If lstview.SelectedItems.Count > 0 Then item = lstview.SelectedItems.Item(0).Text...
  10. Noremacam

    help keeping listview selection after refresh

    I've searched the forum but couldn't find an answer, so I hope this isn't a duplicate. I have a listview(set as a details view) that is generated from a query to my database. I have a timer set to, every 5 minutes query the database and refresh the listview with a fresh copy, so that if someone...
  11. Noremacam

    Question exceptions in column sorting

    I'm using the same method to sort my listview columns as here. I want to sort a column of dates, but I have an exception. I'm pulling the dates from the database, and when they come back null, I replace the text with "Incomplete"(the dates are for completion dates). I thought this would save a...
  12. Noremacam

    Sorting a listview by columns

    Doh'! Thanks! It's obvious now that I looked at it.
  13. Noremacam

    Sorting a listview by columns

    This almost works for me. I've yet to find a method of listview sorting that doesn't give me unresolvable errors. I'm running Visual Basic .NET 2008 Express edition. The only problem I have is that e.Column is underlined blue in the lstview.ColumnClick section. It says "'Column' is not a member...
  14. Noremacam

    Question How to Sanitize textboxes for mysql commands

    Hello, I'm a noob when it comes to programming with mysql(I understand databases, but I don't really understand the sql syntax very well). I'm creating a database application, and I want to UPDATE a row with all the fields from various textboxes. How do I sanitize the strings from the textboxes...
Back
Top