Search:

Type: Posts; User: GideonE

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: VB.NET Combine .txt files without header

    Thank you very much.
  2. Re: VB.NET Combine .txt files without header

    Thank you jmcilhinney.

    Works like a charm.
    However the new file in in Windows(CRLF) UTF8 format. The original files are in Unix(LF) UTF8 format.
    For importing it into MYSQL, I changed the...
  3. [RESOLVED] VB.NET Combine .txt files without header

    Hi all

    I have the following code to combine all .txt files in a folder into a single .txt file :



    Dim path As String = "D:\Wingerdbou\Lutzville2\InvoerDataFiles\Ander...
  4. Replies
    9
    Views
    698

    Re: Webbrowser Invoke problems

    Adding System.Threading.Thread.Sleep(5000) before the second link made no difference.
  5. Replies
    9
    Views
    698

    Re: Webbrowser Invoke problems

    Yes I would.
  6. Replies
    9
    Views
    698

    Re: Webbrowser Invoke problems

    Thank you for replying jmcilhinney.

    I can login with Button3_Click. In the webbrowser window the login is successful, but when I try to invoke the second link, nothing happens ( no error...
  7. Replies
    9
    Views
    698

    Webbrowser Invoke problems

    Hello All

    I am trying to save a html table from a website to a .csv file.

    However, I have issues invoking an element. I have managed to login into the site, but cannot work out how to invoke a...
  8. Expression for both font color and weight in SSRS

    Hi

    I would like to know if it is possible to change both the font color AND font weight based on conditions for a textbox with an expression.

    If have the following to change the font color :
    ...
  9. Replies
    5
    Views
    1,723

    Re: Cannot pass parameters to report

    Thank you techgnome

    I have indeed imported the wrong namespace:


    ''Imports Microsoft.Reporting.WebForms
    Imports Microsoft.Reporting.WinForms

    Regards
  10. Replies
    5
    Views
    1,723

    Re: Cannot pass parameters to report

    Thank you for spotting that Si.
    It is as techgnome below suggested - I've imported the wrong namespace.

    Regards
  11. Replies
    5
    Views
    1,723

    Re: Cannot pass parameters to report

    Does anyone know if it it possible to filter a report's dataset with SQL rather than using the parameters in the report?
  12. Replies
    5
    Views
    1,723

    [RESOLVED] Cannot pass parameters to report

    I have used this method many times with success, but all of a sudden its not working.

    I have a report with two parameters.

    I am trying to pass these two with the following code :

    ...
  13. Re: Change decimal symbol to period not comma

    Sorry my bad.
    My dataset locale was different from my regional settings.
  14. [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...
  15. 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...
  16. [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.

    ...
  17. 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...
  18. Replies
    7
    Views
    3,650

    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 :
    ...
  19. Replies
    7
    Views
    3,650

    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...
  20. Replies
    7
    Views
    3,650

    [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...
  21. Replies
    12
    Views
    1,652

    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)....
  22. Replies
    12
    Views
    1,652

    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...
  23. Replies
    12
    Views
    1,652

    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.
  24. Replies
    12
    Views
    1,652

    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.
  25. Replies
    12
    Views
    1,652

    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...
  26. Replies
    12
    Views
    1,652

    [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....
  27. Replies
    12
    Views
    1,542

    Re: Parse date to correct format

    Thank you techgnome.
  28. Replies
    12
    Views
    1,542

    Re: Parse date to correct format

    jmchilhinney thank you for clearing that up.
  29. Replies
    12
    Views
    1,542

    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...
  30. Replies
    12
    Views
    1,542

    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;
    ...
  31. Replies
    12
    Views
    1,542

    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"))
    ...
  32. Replies
    12
    Views
    1,542

    [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")
    ...
  33. Replies
    7
    Views
    1,287

    Re: Compressing files

    Thank you.
  34. Replies
    7
    Views
    1,287

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

    Re: Compressing files

    Thank you. Especially for the tip on Microsoft docs.
  36. Replies
    7
    Views
    1,287

    [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...
  37. 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.
  38. 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"
    ...
  39. Replies
    2
    Views
    6,813

    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.
  40. Replies
    2
    Views
    6,813

    [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) & ") : " &...
Results 1 to 40 of 120
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width