Search:

Type: Posts; User: GideonE

Page 1 of 2 1 2

Search: Search took 0.04 seconds.

  1. Re: Import from .csv file into MySQL

    Thank you Chris.
  2. Re: Import from .csv file into MySQL

    Fantastic. Thank you very much, especially the explaining. Indeed that was the issue.

    When I turned Option Strict on I got the following error which is much more explanatory : Option Strict On...
  3. Re: Import from .csv file into MySQL

    Thank you for that insight.
    I have done as you suggested, but I am still getting the error. I have reduced the data table to only one column, i.e. vessel.
    That is definitely a string and is...
  4. [RESOLVED] Import from .csv file into MySQL

    I am trying to import data from a .csv file into a MySQL database, but are getting an error : 'Input string was not in a correct format.'

    I have searched and tried many solutions with no success....
  5. Replies
    1
    Views
    1,360

    Table color gradient

    Hi All

    I want to gradient fill a column from red (lowest value) to green (highest value). I am using a funtion found here...
  6. Replies
    0
    Views
    1,363

    Report Null parameter

    I have a report in VB.Net for which I am using a parameters as a filter. The parameter is set to allow null and blanks. However when I select nothing I am expecting to see all the records, however it...
  7. Replies
    0
    Views
    822

    Passing multiple report parameters

    I am trying to filter a report from three combobox values. Only selected values should be passed as report parameters. For example an user may select values in two comboboxes and the last one...
  8. Replies
    5
    Views
    424

    VS 2019 Re: Parse date string to date

    Thank you both. I have used the following to create the parameters :


    With cmd.Parameters

    .Add("@grower", DbType.String, 50, "grower")
    .Add("@alias",...
  9. Replies
    5
    Views
    424

    VS 2019 Parse date string to date

    I have the following situation. I read data from a csv file into a data table. I then read the data table into a SQLite table. I am having difficulty working wit a date ("datum") in the SQLite table...
  10. Replies
    2
    Views
    456

    VS 2019 Data table to Sqlite table

    I am trying to insert data from a data table into a Sqlite table. The data table is filled from a .csv file.


    Private Sub VoerWeighbridgehistorycsvInToolStripMenuItem_Click(sender As Object, e...
  11. Replies
    15
    Views
    2,443

    Re: VB.net read csv file to data table

    Ahh !! Thank you. I realized now how stupid my question was. Thank you for bearing with me.
  12. Replies
    15
    Views
    2,443

    Re: VB.net read csv file to data table

    Thank you Chris. Why is the double quotation marks necessary in myData(15) = "0" ? Isn't myData(15) then double?
    Anyway many thanks.
  13. Replies
    15
    Views
    2,443

    Re: VB.net read csv file to data table

    Thank you Passel. I understand.

    My problem is that I have empty fields in my csv file at column 15. I am trying to solve this with :


    Do While Not myReader.EndOfData
    Dim...
  14. Replies
    15
    Views
    2,443

    Re: VB.net read csv file to data table

    Thank you Passel.
  15. Replies
    15
    Views
    2,443

    Re: VB.net read csv file to data table

    Thank You ChrisE. That helps a lot. How to I convert the strings to double if I want to save the data table to a SQL data table where I use decimals for anavalue1.

    Regards
  16. Replies
    15
    Views
    2,443

    Re: VB.net read csv file to data table

    Thank you techgnome. I appreciate your response. (Oops sorry posted twice.) So I have edited my code to :



    If thecolumns(12).IsNullOrEmpty(thereader.ReadLine) Then
    'Do nothing...
  17. Replies
    15
    Views
    2,443

    Re: VB.net read csv file to data table

    Thank you techgnome. I appreciate your response. So I have edited my code to :



    If thecolumns(12).IsNullOrEmpty(thereader.ReadLine) Then
    'Do nothing
    Else
    ...
  18. Replies
    15
    Views
    2,443

    [RESOLVED] VB.net read csv file to data table

    I am trying to read a .csv file into a datatable which is defined like this :

    Dim thedatatable As New DataTable

    With thedatatable

    .Columns.Add("grower",...
  19. Replies
    0
    Views
    486

    VS Code VB.Net Report with vertical bullet chart

    Hi All

    As a relative beginner I am trying to create a chart in VB.net with report designer which resembles the following chart I have created in Excel :

    171745

    The black is the actual value...
  20. VB.Net Passing blank values from csv to data table

    I am using the following code to pass data from a csv file to a data table. However when a empty value is encountered I get the following error : Input string was not in a correct format.Couldn't...
  21. Replies
    10
    Views
    653

    VS 2015 Re: vb.net streamwriter error at certain line

    Thank you jmcilhinney. That worked. For the benefit of others I am including my code that works.


    Dim SWriter As New StreamWriter("C:\Users\Administrator\Desktop\Sked2019\Ezy Wine...
  22. Replies
    10
    Views
    653

    VS 2015 Re: vb.net streamwriter error at certain line

    Thank you jmcilhinney. That worked. For the benefit of others I am including my code that works.


    Dim SWriter As New StreamWriter("C:\Users\Administrator\Desktop\Sked2019\Ezy Wine...
  23. Replies
    10
    Views
    653

    VS 2015 Re: vb.net streamwriter error at certain line

    bmwpete, Thank you - I did make the assumption, wrongly.
  24. Replies
    10
    Views
    653

    VS 2015 Re: vb.net streamwriter error at certain line

    I have the same issue with plants. Lesson learnt for the future : attach files (or part of it).
  25. Replies
    10
    Views
    653

    VS 2015 Re: vb.net streamwriter error at certain line

    My apologies. Though I have attached. Clearly not. My files are to big even when zipped according to forum rules. I have found the problem though. Turned out to be a comma in a cetain row.

    I am...
  26. Replies
    10
    Views
    653

    VS 2015 vb.net streamwriter error at certain line

    I have the following code to alter a .csv file. (It copies only certian columns to the new file.)

    Dim SR As New StreamReader("C:\Users\Administrator\Desktop\Sked2019\Ezy Wine...
  27. Replies
    2
    Views
    362

    VS 2013 [RESOLVED] Copy csv to sql database

    I use the following code to copy data from a .csv file to my sql database :

    Dim dt As New DataTable()
    Dim line As String = Nothing
    Dim i As Integer = 0

    Using sr As...
  28. VS 2015 Re: VB Give integer value to column based on sort

    Thank you technome. Your code works well to select, but how do then do I update skedulering2?
  29. VS 2015 Re: VB Give integer value to column based on sort

    Thank you jmcilhinney. Came up with the following :

    SQL :


    ;WITH CTE AS
    (
    SELECT ROW_NUMBER() OVER (PARTITION BY kultivar,GroepperingsGroep ORDER BY LaasteOntledingsdatum Asc,...
  30. VS 2015 Re: VB Give integer value to column based on sort

    Thank you jmcilhinney. Came up with the following :

    SQL :


    ;WITH CTE AS
    (
    SELECT ROW_NUMBER() OVER (PARTITION BY kultivar,GroepperingsGroep ORDER BY LaasteOntledingsdatum Asc,...
  31. VS 2015 VB Give integer value to column based on sort

    I am building a VB.Net applications using SQL server and cannot figure the following out :

    I need to give a sequential integer (starting from 1) to a column in the database table (column called...
  32. Re: SQL code working in SQL but not in vb.net

    Thank you all. I feel embarrassed. My problem was program flow. This statement was done before EersteDatumSlaag had a value in the source table, thus the issue.
    Once again thank you all for replying.
  33. [RESOLVED] SQL code working in SQL but not in vb.net

    I have the following code in vb.net :


    Try
    konneksie.Open()
    Dim Query As String
    Query = "Update t1 " &
    "SET " &
    ...
  34. Replies
    5
    Views
    1,340

    VS 2015 Re: VB.net use of GroupByGrid

    Thank you techgnome. The data in the first column is not unique - you can only see the first bit which is unique.
  35. Replies
    5
    Views
    1,340

    VS 2015 Re: VB.net use of GroupByGrid

    Thank you Chris E - will try that.
  36. Replies
    5
    Views
    1,340

    VS 2015 Re: VB.net use of GroupByGrid

    Nope it seems you cannot group the grid only by the values from one column.
  37. Replies
    5
    Views
    1,340

    VS 2015 VB.net use of GroupByGrid

    I have downloaded the following code and saved it in as a new class.
    ...
  38. Replies
    5
    Views
    977

    VS 2015 Re: VB.Net delete lines from csv

    Inferrd. Thank you very much, that did the trick.
  39. Replies
    5
    Views
    977

    VS 2015 Re: VB.Net delete lines from csv

    Thank you. Very good point. I miised that. I've tried three options :


    Where fields(8) <> " / /"
    Where fields(8).Trim <> "/ /"
    Where fields(8).Replace("...
  40. Replies
    5
    Views
    977

    VS 2015 Re: VB.Net delete lines from csv

    Thank you. Very good point. I miised that. I've tried three options :

    Where fields(8) <> " / /"
    Where fields(8).Trim <> "/ /"
    Where fields(8).Replace(" ", "") <> ""...
Results 1 to 40 of 62
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width