Search:

Type: Posts; User: GideonE

Page 1 of 3 1 2 3

Search: Search took 0.08 seconds.

  1. 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...
  2. Replies
    7
    Views
    267

    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 :
    ...
  3. Replies
    7
    Views
    267

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

    [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...
  5. Replies
    12
    Views
    525

    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)....
  6. Replies
    12
    Views
    525

    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...
  7. Replies
    12
    Views
    525

    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.
  8. Replies
    12
    Views
    525

    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.
  9. Replies
    12
    Views
    525

    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...
  10. Replies
    12
    Views
    525

    [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....
  11. Replies
    12
    Views
    525

    Re: Parse date to correct format

    Thank you techgnome.
  12. Replies
    12
    Views
    525

    Re: Parse date to correct format

    jmchilhinney thank you for clearing that up.
  13. Replies
    12
    Views
    525

    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...
  14. Replies
    12
    Views
    525

    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;
    ...
  15. Replies
    12
    Views
    525

    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"))
    ...
  16. Replies
    12
    Views
    525

    [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")
    ...
  17. Replies
    7
    Views
    354

    Re: Compressing files

    Thank you.
  18. Replies
    7
    Views
    354

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

    Re: Compressing files

    Thank you. Especially for the tip on Microsoft docs.
  20. Replies
    7
    Views
    354

    [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...
  21. 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.
  22. 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"
    ...
  23. Replies
    2
    Views
    889

    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.
  24. Replies
    2
    Views
    889

    [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) & ") : " &...
  25. Re: Import date from csv into MySQLBulkloader wiith different date format

    Thank you jmcilhinney.

    That works perfectly. Thank you for your patience.

    Regards
  26. 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...
  27. 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 -...
  28. 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...
  29. [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 =...
  30. Replies
    5
    Views
    708

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

    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...
  32. Replies
    5
    Views
    708

    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 =...
  33. Replies
    5
    Views
    708

    [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...
  34. Replies
    9
    Views
    1,249

    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...
  35. Replies
    9
    Views
    1,249

    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...
  36. Replies
    9
    Views
    1,249

    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...
  37. Replies
    9
    Views
    1,249

    VS 2019 Re: Using MysqlBulkloader

    Thank you, I agree a much better converter than the ones I tried.
  38. Replies
    9
    Views
    1,249

    VS 2019 [RESOLVED] Using MysqlBulkloader

    Hi all

    I am using Mysql and VB.Net (Visual Studio) to create an application.

    I have large .csv files to import into Mysql tables. I would like to use MYSQLBulkloader to speed up things. I do...
  39. VS 2019 Re: SQLite query with combobox selected item

    Thank you techgnome. Problem solved. Also thank you for explaining what the SQL essentially looks like.

    By the way breed is that fantastic dog on your avatar?

    Regards
  40. VS 2019 Re: SQLite query with combobox selected item

    Thank you for replying. The issue was resolved by technome below.
Results 1 to 40 of 104
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width