Search Results - VBForums

Search:

Type: Posts; User: IanRyder

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: I need a vb.net INSERT example to an Access 2007 table example.

    Hi,

    I just tested this and actually I am wrong and this does work with no spaces between the word Values. I did not expect that and you learn something new every day. LOL.

    That said, I have...
  2. Re: I need a vb.net INSERT example to an Access 2007 table example.

    Hi,

    You should have picked this one up. Have a look at your Query and you will see that you have got "[FedExPackagingCode])Values(?," which is syntactically incorrect so add the spaces in the...
  3. Replies
    2
    Views
    140

    VS 2010 Re: How to Get element by ID in this case?

    Hi,

    The GetElementByID Method will only get the First occurrence of an element with an ID of a particular name. Have a look at this:-

    HtmlDocument.GetElementById Method

    What you can do...
  4. Replies
    2
    Views
    120

    VS 2008 Re: Search from Datagridview from Access

    Hi,

    When posting to the Forum it is important to remember to be as specific as possible with regards to what your problem is and describing any error messages that you get so that we do not have...
  5. Replies
    3
    Views
    121

    VS 2008 Re: regex to remove spaces

    Hi,

    If this is all you are wanting to do then just use the String.Trim Method instead of trying to use RegEx. If you then want to remove Spaces contained with the string then just use the...
  6. Replies
    2
    Views
    172

    VS 2010 Re: Chart Line Colour

    Hi,

    You can use the Charts Customize Event to help you adjust the look and feel of a Chart just before it is displayed. Have a look at this:-

    Chart.Customize Event

    You can therefore say...
  7. Replies
    2
    Views
    141

    Re: How To Create A Dynamic User Form?

    Hi,

    What you may or may not realise is that there are about a dozen different questions in that statement ranging from getting your Data into a Project, populating a Combo Box, binding information...
  8. VS 2010 Re: Partition and Rank datatable by a certain column

    Hi,

    From what I understand of your question, I would use a combination of LINQ and traditional For Loops here to make things easier to read and understand.

    In your case you need to Group your...
  9. VS 2015 Re: Text comparison and lookup on a SQL server

    Hi,

    I think you have more or less got all the elements that you need to make this happen. If you take the Checksum idea from option 1 and then combine that as the search element for option 2 then...
  10. Replies
    4
    Views
    219

    VS 2010 Re: Slide effect

    Hi,

    You need to check your own logic there and rework your code since passel is correct. That first “If” statement is redundant since you are basically asking the same question twice but what you...
  11. Thread: Prime Finder

    by IanRyder
    Replies
    9
    Views
    315

    VS 2012 Re: Prime Finder

    Hi,

    As tg already mentioned, try not to overthink things. To convert a subroutine to a function is just a matter of changing Sub to Function and adding a Return Type to the functions signature....
  12. VS 2015 Re: Text comparison and lookup on a SQL server

    Hi,

    Based on what you have described option 1 sounds a bit like suicide so option 2 is the right answer here since you need let the database take care of only giving you the information that you...
  13. Replies
    10
    Views
    236

    VS 2013 Re: UPDATE Overload method?

    Hi,

    You are actually conflicting with an Existing Method of the Control Class of which a Form is derived from. In your case you must have declared a Method Called Update within your code without...
  14. Thread: Prime Finder

    by IanRyder
    Replies
    9
    Views
    315

    VS 2012 Re: Prime Finder

    Hi,

    You have accidentally removed the initialization of the “n” variable in the Dim Statement. Put that back to what you originally had to set the initial value of “n” otherwise that variable...
  15. Thread: Prime Finder

    by IanRyder
    Replies
    9
    Views
    315

    VS 2012 Re: Prime Finder

    Hi and Welcome to the Forum,

    You have made two major mistakes here:-

    1) You have forgotten to redo your calculation after you increment your “i” variable within the While Loop.

    2) Your...
  16. VS 2005 Re: Update record if already exist else Insert it

    Hi,

    To clarify your question, did you really mean to say that all the records in your Data Table end up being the same as the Last Record in your DataGridView once you run the Update Statement?
    ...
  17. Replies
    30
    Views
    591

    Re: Regular Expression: How to match this?

    Hi,

    I am not a VB6’er anymore so I have no idea how RegEx really works within VB6 but I saw this thread yesterday and the thing that struck me was that no one has suggested escaping that forward...
  18. Re: select/join return null values

    (I see that techgnome has just beat me to this so more or less the same)

    Hi,

    There must be something else going on here since that query, based on the Specific Data you have provided, should...
  19. Re: [VS2010] Balloon tip if caps lock is pressed

    Hi,

    If you set the UseSystemPasswordChar Property of the Textbox to True then you will automatically get a Default ToolTip notifying you that caps lock was set to on. If for some reason you need...
  20. Replies
    3
    Views
    198

    VS 2008 Re: Refresh dataset result !

    Hi,



    Well you still do what you want to do but a little better than what you are doing now. So, get rid of the setting of the Connection Object to Nothing and also get rid of the Explicit...
  21. Re: reading from a CSV to DataTable

    Hi,

    I am surprised you did not get that one. Don’t forget that the first overload of the Rows.Add Method accepts an Array of Parameters and when I read the CSV File I read each line and create an...
  22. Replies
    3
    Views
    198

    VS 2008 Re: Refresh dataset result !

    Hi,

    There are a few issues there. The reason why this is failing is because you have set the Connection Object to Nothing the first time this code segment is run by the Timer. This means that when...
  23. Re: reading from a CSV to DataTable

    Hi,

    Many CSV files are not just Delimited by a Comma but by both a Comma and a Quote Character to accommodate for valid commas within a text string. You can therefore use the TextFieldParser Class...
  24. Re: SQL to determine if field is null

    Hi,

    Just use a simple Case Statement such as:-

    SELECT
    CASE WHEN SomeField IS NULL THEN 'True' ELSE 'False' END AS IsMyFieldNull_AsTextString,
    CASE WHEN SomeField IS NULL THEN 1 ELSE 0 END AS...
  25. Re: Searching a DataTable based on a PrimaryKey?

    Hi,

    There is nothing wrong with dday9’s suggestion but I think it is also important for you to note that there is nothing wrong with what you have done in principal as well. Compare your method...
  26. VS 2012 Re: SqlClient command parameter OUTPUT problems

    Hi szlamany,

    See if this helps to get you on track.

    A simple Stored Proc which takes an Input Parameter and Outputs a Recordset and an Output Parameter.
    USE [Test]
    GO

    /****** Object: ...
  27. Re: Back to a problem I marked as solved a little while ago (draw image)

    Hi,

    I am not completely sure what you mean but after a quick play the only thing I can really see is that you need to use the ClientRectangle.Width property to get the current width of the form...
  28. Replies
    4
    Views
    239

    Re: [RESOLVED] TextBox Calculation Error

    Hi,

    Here you go:-

    Decimal.TryParse Method (String, Decimal)

    and to again compensate for Number Styles, here is the second overload of the TryParse Method:-

    Decimal.TryParse Method...
  29. Re: A question WRT FolderBrowserDialog

    Hi,

    I have no idea why you are struggling so badly with the Help System in VS but even if F1 is not doing what it should be than all you need to do is type into a Search Engine the Class Name with...
  30. Replies
    4
    Views
    239

    Re: TextBox Calculation Error

    Hi,

    When converting from a Text String to a Numeric Value you should be using the TryParse Method of a Specific Type so that you can test if the conversion was successful or not and then do what...
  31. Re: [RESOLVED] TextBox Completed based on CheckBox Selection

    Hi,

    You are welcome and glad I could help. Keep up the studies.

    Cheers,

    Ian
  32. Re: TextBox Completed based on CheckBox Selection

    Hi,

    You just need to set the Checked State of the ComboBox to True in the VS Property Grid. Have a look here:-

    129113

    Cheers,

    Ian
  33. Re: TextBox Completed based on CheckBox Selection

    Hi,

    You have more or less got it but you forgot to remember that a CheckBox control works independently from other CheckBox controls and therefore you need to make sure that you check the state of...
  34. Re: Read XML File with Header and Detail Node on datagridview in VB.NET

    Hi,

    There are various ways that this can be done and one of my preferred methods for dealing with XML files is to read the XML file into a DataSet and Infer the Data Schema as part of the Load...
  35. Re: what's the difference between null and ""?

    Hi,

    The NULL value is a special character which represents an Empty field or Object. That is a field or object which contains No value as opposed to a field which may contain a string value of...
  36. VS 2015 Re: ComboBox DrawItem is not working

    Hi,

    You may want to remember to set the DisplayMember, ValueMember and DataSource for the ComboBox and things will start to work.

    If you need help with the DrawItem Event then there is a good...
  37. Replies
    3
    Views
    207

    VS 2013 Re: "\" and "/" in path

    Hi,

    How about doing a simple Replace on the entered text in conjunction with the IO.Path class. Have a go with this:-

    Dim somePath As String = "C:/Test/Test1"...
  38. VS 2013 Re: Maintain selecting Listview after navigating Webbrowser

    Hi,

    Are you sure you have provided all the relevant information here about the errors that you may be getting? I have just tried what you are doing and the initial thing that struck me is that you...
  39. Replies
    5
    Views
    201

    Re: Why isn't this working?

    Hi,

    Since a text string is actually an array of chars here is another option for you using the Char Data Type and a bit of LINQ to Objects:-

    Dim sometext As String = "Some / Text To, Be Dealt...
  40. VS 2013 Re: Rotate Image and/or Picture Box?

    LOL! No worries and glad I was able to help.

    Cheers,

    Ian
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width