dcsimg

Search:

Type: Posts; User: GideonE

Page 1 of 2 1 2

Search: Search took 0.09 seconds.

  1. Replies
    1
    Views
    745

    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...
  2. Replies
    0
    Views
    810

    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...
  3. Replies
    0
    Views
    310

    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...
  4. Replies
    5
    Views
    370

    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",...
  5. Replies
    5
    Views
    370

    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...
  6. Replies
    2
    Views
    291

    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...
  7. Replies
    15
    Views
    1,108

    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.
  8. Replies
    15
    Views
    1,108

    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.
  9. Replies
    15
    Views
    1,108

    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...
  10. Replies
    15
    Views
    1,108

    Re: VB.net read csv file to data table

    Thank you Passel.
  11. Replies
    15
    Views
    1,108

    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
  12. Replies
    15
    Views
    1,108

    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...
  13. Replies
    15
    Views
    1,108

    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
    ...
  14. Replies
    15
    Views
    1,108

    [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",...
  15. Replies
    0
    Views
    331

    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...
  16. 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...
  17. Replies
    10
    Views
    563

    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...
  18. Replies
    10
    Views
    563

    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...
  19. Replies
    10
    Views
    563

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

    bmwpete, Thank you - I did make the assumption, wrongly.
  20. Replies
    10
    Views
    563

    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).
  21. Replies
    10
    Views
    563

    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...
  22. Replies
    10
    Views
    563

    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...
  23. Replies
    2
    Views
    320

    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...
  24. 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?
  25. 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,...
  26. 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,...
  27. 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...
  28. 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.
  29. [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 " &
    ...
  30. Replies
    5
    Views
    1,080

    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.
  31. Replies
    5
    Views
    1,080

    VS 2015 Re: VB.net use of GroupByGrid

    Thank you Chris E - will try that.
  32. Replies
    5
    Views
    1,080

    VS 2015 Re: VB.net use of GroupByGrid

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

    VS 2015 VB.net use of GroupByGrid

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

    VS 2015 Re: VB.Net delete lines from csv

    Inferrd. Thank you very much, that did the trick.
  35. Replies
    5
    Views
    790

    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("...
  36. Replies
    5
    Views
    790

    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(" ", "") <> ""...
  37. Replies
    5
    Views
    790

    VS 2015 [RESOLVED] VB.Net delete lines from csv

    I have the following code to delete lines in a csv file that contain " / /" in column no 8 :



    Dim modifiedCSV = (From line In...
  38. Replies
    5
    Views
    1,473

    VS 2015 Re: Pass sql value to vb.net variable

    Thank you Kebo. I ended up with the following code after the update command.

    Dim resultaat As String
    opdragresultaat.CommandText = "SELECT GroeperingsKode FROM skedulering2...
  39. Replies
    5
    Views
    1,473

    VS 2015 Re: Pass sql value to vb.net variable

    Thank you Kebo. I ended up with the following code after the update command.

    Dim resultaat As String
    opdragresultaat.CommandText = "SELECT GroeperingsKode FROM skedulering2...
  40. Replies
    5
    Views
    1,473

    VS 2015 Re: Pass sql value to vb.net variable

    Thank you Kebo. This is exactly what I want to do. However slaagsuiker is a value in the database. So I want the value sent back to VB from the database after the sql command. This value I then want...
Results 1 to 40 of 58
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width