Search:

Type: Posts; User: GideonE

Page 1 of 4 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    15
    Views
    2,412

    Re: Cannot connect to MySQL database

    Hi vbdotnut. Apologies that was frustration getting the hold of me. I agree that I must have " botched' up somewhere. Finding that issue connection to a Mysql database using MySQL Database (MySQL...
  2. Replies
    15
    Views
    2,412

    Re: Cannot connect to MySQL database

    Hi dday9. I have managed to use ODBC. Seems like Visual studio used 32 bit. So when i made the sure the platform in my ODBC Datasources is a 32 bit I could add and ODBC connections after many,many...
  3. Replies
    15
    Views
    2,412

    Re: Cannot connect to MySQL database

    Ok so I have given up. To anyone reading this - if you want to create database applications with Visual studio : DO NOT USE MYQL.
    Even if you use Visual Studio 2019.
    Also it seems vb.net is with...
  4. Replies
    15
    Views
    2,412

    Re: Cannot connect to MySQL database

    Hi Zvoni. Thank you for making the effort to reply.
    I have tried to connect via Microsoft ODBC Data Source (ODBC).
    I have set a SYSTEM DNS on my ODBS Data Sources (64bit) and created a data...
  5. Replies
    15
    Views
    2,412

    Re: Cannot connect to MySQL database

    Yes, looks like Microsoft is putting pressure on us to use SQL in stead of MySql.
    Even hours spent on chatgbt could not solve this.
  6. Replies
    15
    Views
    2,412

    Re: Cannot connect to MySQL database

    All the caractersets and collation for the database, tables and columns are the same.
  7. Replies
    15
    Views
    2,412

    Re: Cannot connect to MySQL database

    Thank you very much for replying.

    I include part of the my.ini file

    [mysqld]
    local_infile=ON
    secure-file-priv = ""

    character-set-server=utf8mb4
    collation-server=utf8mb4_0900_ai_ci
  8. Replies
    15
    Views
    2,412

    Cannot connect to MySQL database

    Hope I am not asking this on the wrong forum, but I have no idea where to look elsewhere (and this forum has been my recue many, many times).

    I am trying to develop a new VB.net application with...
  9. Replies
    10
    Views
    1,934

    Re: Vb.net excel hide gridlines

    Thank you dbasnett that did it for me.
  10. Replies
    10
    Views
    1,934

    Re: Vb.net excel hide gridlines

    Thank you for that tip Si

    However I have tried :


    xlWorkSheet.DisplayGridlines = False

    I get the following error when I run (not in the editing mode of Visual studio)
    ...
  11. Replies
    10
    Views
    1,934

    [RESOLVED] Vb.net excel hide gridlines

    Can someone please help me with the command to hide gridlines when creating an Excel file?

    I use the following code :

    Dim xlApp As Excel.Application
    Dim xlWorkBook As...
  12. Replies
    6
    Views
    1,212

    Re: Datagrid view both Combobox AND Autofilter

    I have referenced a .dll called DataGridViewAutoFilter.dll.

    I then have an option to set the datagridview's column type to DataGridViewAutoFilterTextBoxColumn.

    When I run the application, I...
  13. Replies
    6
    Views
    1,212

    Datagrid view both Combobox AND Autofilter

    Using VB.Net, I would like to know if a datagridview column can be set in the designer to both a Combobox AND an Autofilter type?

    Regards
  14. Bound datagridview combobox from another table.

    I have a bound VB.net datagrid in my application. I would like to make one of the columns a combobox. Problem is I want to use data in another MySQL table (different from the currently bound table)...
  15. VS 2019 Re: Adding and grouping datagrid view column header in VB.NET

    For anyone interested - what I have done is:

    Increase the width of the second group and draw it before the first group.

    You may have to play with the heights and alignments a bit.

    In the...
  16. VS 2019 [RESOLVED] Adding and grouping datagrid view column header in VB.NET

    I am trying to add grouped column headers to a bound datagrid view.

    I want columns 3-7 grouped as "First Group". I have managed that with the following code :

    In the cellpainting event :


    ...
  17. Vb.net cannot change Datagridview column index

    I am trying to increase the width of a last dummy column in a datagridview so that I display certain rows after a button click.
    The DGV is bigger that the screen so it scrolls, also the forth column...
  18. Replies
    11
    Views
    1,817

    VS 2019 Re: Simple for to loop

    Thank you for replying.

    You are right, when I use the code in a new project it executes as expected.

    I am using the code within a datagridview's RowStateChanged event as I would like to make...
  19. Replies
    11
    Views
    1,817

    VS 2019 Simple for to loop

    Can any please tell me what I am missing in this very simple for to loop ?





    For index As Integer = 15 To 21 Step 1


    MsgBox("This is the loop no : " & index.ToString)
  20. Thread: Cloud hosting

    by GideonE
    Replies
    3
    Views
    1,078

    Re: Cloud hosting

    Thank you. I've added my location to my profile (South Africa).
    I will also read your link.
  21. Thread: Cloud hosting

    by GideonE
    Replies
    3
    Views
    1,078

    Cloud hosting

    I have developed an vb.net application which uses a MySql database.

    I would like to host it in the cloud, but have no idea how to start.

    The database needs to be updated every day.

    Should I...
  22. Re: VB.NET Combine .txt files without header

    Thank you very much.
  23. 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...
  24. [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...
  25. Replies
    9
    Views
    1,990

    Re: Webbrowser Invoke problems

    Adding System.Threading.Thread.Sleep(5000) before the second link made no difference.
  26. Replies
    9
    Views
    1,990

    Re: Webbrowser Invoke problems

    Yes I would.
  27. Replies
    9
    Views
    1,990

    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...
  28. Replies
    9
    Views
    1,990

    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...
  29. 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 :
    ...
  30. Replies
    6
    Views
    4,606

    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
  31. Replies
    6
    Views
    4,606

    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
  32. Replies
    6
    Views
    4,606

    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?
  33. Replies
    6
    Views
    4,606

    [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 :

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

    Sorry my bad.
    My dataset locale was different from my regional settings.
  35. [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...
  36. 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...
  37. [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.

    ...
  38. 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...
  39. Replies
    7
    Views
    6,369

    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 :
    ...
  40. Replies
    7
    Views
    6,369

    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...
Results 1 to 40 of 141
Page 1 of 4 1 2 3 4



Click Here to Expand Forum to Full Width