Search:

Type: Posts; User: GideonE

Page 1 of 3 1 2 3

Search: Search took 0.03 seconds.

  1. Re: Change decimal symbol to period not comma

    Sorry my bad.
    My dataset locale was different from my regional settings.
  2. [RESOLVED] Change decimal symbol to period not comma

    I have a VB.NET application using a MySQL database.

    My datagridview shows decimal values from the database with a comma as a symbol - I would like it to show a period (.). My regional settings are...
  3. Re: VB.net delete rows from .csv where value = 0

    Thank you jmchilhinney.

    Your code is much cleaner than mine.

    Your question
    provided the answer.

    The solution was simple really. The data in the .csv is "0.0000" and not "0".

    So changing...
  4. [RESOLVED] VB.net delete rows from .csv where value = 0

    I am trying to delete all rows from a .csv where a column is 0.

    I use a streamreader to read the lines and then streamwriter to create a new file.

    However the rows are not being deleted.

    ...
  5. Using CsvHelper to speed up inserting from .csv to database

    I am currently using Mysqlbulkloader to insert data from a .csv file to a Mysql Database. The .csv file has just over 1 mil lines and take just under two minutes to complete.

    I want to use...
  6. Replies
    7
    Views
    1,299

    Re: CSV Helper

    Thank you jmchilhinney. That worked. (I don't know whether I should put this on a new thread.)

    My plan is to use streamreader and put the data into a datable :

    'First Streamreader :
    ...
  7. Replies
    7
    Views
    1,299

    Re: CSV Helper

    Thank you both. I have tried csvReader.Configuration.BadDataFound = Nothing

    I get the following error : Proprty BadDatafound is readonly. The author's remarked that .

    He then refers to the...
  8. Replies
    7
    Views
    1,299

    [RESOLVED] CSV Helper

    I have a VB.Net (Framework 4.7.2) application and a Mysql database. I use Mysql bulkloader to insert just over 1 million lines from .csv file. It takes about 1 minute 46 sec to load. I am trying to...
  9. Replies
    12
    Views
    956

    Re: Month calendar

    So adding the control was remarkably easy.

    What I did was to extract the source file (I used the 2005 version). I then added the C# project to my existing VB.NET application (I'm using 4.7.2)....
  10. Replies
    12
    Views
    956

    Re: Month calendar

    When I download the source files (Visual studio 2005) from herehttps://www.codeproject.com/Articles/10840/Another-Month-Calendar and unzip it, a lot of files are displayed. So where do I start to...
  11. Replies
    12
    Views
    956

    Re: Month calendar

    Thank you. No I was not aware of that. I will try your advice and see if I can manage.
    Any advice where I can start to learn how to do that? I'll search in the meantime.
  12. Replies
    12
    Views
    956

    Re: Month calendar

    Nope. It seems we are stuck with the current uncustomizable standard Month Calendar from Visual Studio. I could not find a 3rd party calendar later than .NET 4.0.
  13. Replies
    12
    Views
    956

    Re: Month calendar

    Hmm. Can anyone suggest a customizable month calendar which I can use.

    I have managed to get the control in my toolbox. However it seems like al lot of methods (eg. day selected) needs to be...
  14. Replies
    12
    Views
    956

    [RESOLVED] Month calendar

    I am trying to use a third party month calendar to jazz up my month calendar.
    I have managed to make certain dates based on a a mysql data tabl bold using the standard month calendar control....
  15. Replies
    12
    Views
    874

    Re: Parse date to correct format

    Thank you techgnome.
  16. Replies
    12
    Views
    874

    Re: Parse date to correct format

    jmchilhinney thank you for clearing that up.
  17. Replies
    12
    Views
    874

    Re: Parse date to correct format

    Thank you all.

    Lessons learnt :

    1. When asking questions on the forum be specific about the error and include an error message
    2. When storing a date/datetime value in MySQL formatting is...
  18. Replies
    12
    Views
    874

    Re: Parse date to correct format

    Thank you for replying techgnome


    I get the following error : System.InvalidCastException: 'Conversion from string "LastWriteTime" to type 'Integer' is not valid.'

    at the following line;
    ...
  19. Replies
    12
    Views
    874

    Re: Parse date to correct format

    Well I created a data table :


    Dim dt As DataTable = New DataTable

    With dt
    .Columns.Add("Name", System.Type.GetType("System.String"))
    ...
  20. Replies
    12
    Views
    874

    [RESOLVED] Parse date to correct format

    Hi

    I have the following code to save file info in a data table to a mysql database table via an adapter:

    With cmd2.Parameters
    .Add("@Name", MySqlDbType.VarChar, 50, "Name")
    ...
  21. Replies
    7
    Views
    609

    Re: Compressing files

    Thank you.
  22. Replies
    7
    Views
    609

    Re: Compressing files

    Thank you jmchilhinney. Yes I was incorrectly passing a file in stead of a directory.
    From what I read I then take it one cannot compress a single file in a directory. Everything gets compressed...
  23. Replies
    7
    Views
    609

    Re: Compressing files

    Thank you. Especially for the tip on Microsoft docs.
  24. Replies
    7
    Views
    609

    [RESOLVED] Compressing files

    If have the following code to compress a .csv file into a .zip file :


    Imports System
    Imports System.IO.Compression

    Public Class Form1
    Private Sub Button1_Click(sender As Object, e As...
  25. VS 2019 Re: MySQL Bulk Loader from .csv without column names

    Thank you jmcilhinney. You were right (as always).
    I was over-complicating things. Thank you for getting my mind out of a rabbit hole.
  26. VS 2019 [RESOLVED] MySQL Bulk Loader from .csv without column names

    I have the following vb.net code to load a .csv file very fast into a MySQL table :


    Dim bl As New MySqlBulkLoader(conn)
    bl.TableName = "elektrisiteit_staging"
    ...
  27. Replies
    2
    Views
    1,418

    Re: Report does not show integer

    I feel like an idiot. Probably because I am one.
    I am embarrassed to report that my field was empty in my database.
    Don't know how I missed such a basic issue.
  28. Replies
    2
    Views
    1,418

    [RESOLVED] Report does not show integer

    Using Microsoft reportviewer in VB.Net a textbox does not show a integer.

    I have a textbox in the report header with the following expression :


    = "Verkope (k" & CHRW(8467) & ") : " &...
  29. Re: Import date from csv into MySQLBulkloader wiith different date format

    Thank you jmcilhinney.

    That works perfectly. Thank you for your patience.

    Regards
  30. Re: Import date from csv into MySQLBulkloader wiith different date format

    Thank you for your continued support.

    Your first suggestion b1.Expressions.Add("SET Datum = STR_TO_DATE(@Datum, '%d-%m-%Y')") gives the following error:

    MySql.Data.MySqlClient.MySqlException...
  31. Re: Import date from csv into MySQLBulkloader wiith different date format

    Hi jmcilhinney

    I could not find anything to help me. I have the following MySql query that works perfectly :


    LOAD DATA INFILE "D:/Wingerdbou/LutzvilleProgram/InvoerDataFiles/Eskom -...
  32. Re: Import date from csv into MySQLBulkloader wiith different date format

    Hi jmcilhinney

    OK so this is working in MySQL workbench :


    LOAD DATA INFILE "D:/Wingerdbou/LutzvilleProgram/InvoerDataFiles/Eskom - Consumption History.csv"
    INTO TABLE elektrisiteit_staging...
  33. [RESOLVED] Import date from csv into MySQLBulkloader wiith different date format

    I have the following to import from a .csv


    Dim bl As New MySqlBulkLoader(conn)
    bl.TableName = "elektrisiteit_staging"
    bl.FieldTerminator = ","
    bl.LineTerminator = "\r\n"
    bl.FileName =...
  34. Replies
    5
    Views
    1,355

    Re: Report with NULL parameter

    OK got it.

    In VB.net :


    Dim param1 As New ReportParameter

    If KiesVorm.CmbAliasnaam3.SelectedIndex <> -1 Then
    param1 = New ReportParameter("ReportParameterAliasnaam",...
  35. Replies
    5
    Views
    1,355

    Re: Report with NULL parameter

    Hi Technnome is is really baffling me.

    From your first reply I understand I cannot assign a null value to a string. So I pass only the following :


    Dim param1 = New...
  36. Replies
    5
    Views
    1,355

    Re: Report with NULL parameter

    Thank you for your reply Technome.

    I have replaced nothing with an empty string


    If KiesVorm.CmbAliasnaam3.SelectedIndex <> -1 Then
    stringaliasnaam =...
  37. Replies
    5
    Views
    1,355

    [RESOLVED] Report with NULL parameter

    I have a VB.NET application with reports (using Microsoft Reportviewer).

    I have searched, but cannot find a answer to my problem.

    I want to show all records on the report if the reportparameter...
  38. Replies
    9
    Views
    2,054

    VS 2019 Re: Using MysqlBulkloader

    Thank you all. I keep forgetting to reply. The solution was as suggested to use a staging table. That is an identical table as the original excluding the identity column. I then loaded data into this...
  39. Replies
    9
    Views
    2,054

    VS 2019 Re: Using MysqlBulkloader

    Thank you techgnome

    As far as I understand MySQLBulkloader differs from SQLBulkCopy that it reads from a file whereas SQLBulkCopy reads from a datatable. See this reply...
  40. Replies
    9
    Views
    2,054

    VS 2019 Re: Using MysqlBulkloader

    Thank you jmcilhinney.

    First let me acknowledge you for your help.

    I have read your suggested documentation. I must say MySQLBulkloader is very fast.

    The data was successfully loaded when I...
Results 1 to 40 of 108
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width