Search:
Type: Posts; User: GideonE
Search:
Search took 0.04 seconds.
-
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...
-
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...
-
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...
-
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...
-
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.
-
All the caractersets and collation for the database, tables and columns are the same.
-
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
-
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...
-
Thank you dbasnett that did it for me.
-
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)
...
-
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...
-
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...
-
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
-
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)...
-
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...
-
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 :
...
-
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...
-
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...
-
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)
-
Thank you. I've added my location to my profile (South Africa).
I will also read your link.
-
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...
-
-
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...
-
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...
-
Adding System.Threading.Thread.Sleep(5000) before the second link made no difference.
-
-
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...
-
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...
-
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 :
...
-
Thank you techgnome
I have indeed imported the wrong namespace:
''Imports Microsoft.Reporting.WebForms
Imports Microsoft.Reporting.WinForms
Regards
-
Thank you for spotting that Si.
It is as techgnome below suggested - I've imported the wrong namespace.
Regards
-
Does anyone know if it it possible to filter a report's dataset with SQL rather than using the parameters in the 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 :
...
-
Sorry my bad.
My dataset locale was different from my regional settings.
-
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...
-
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...
-
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.
...
-
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...
-
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 :
...
-
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...
|
Click Here to Expand Forum to Full Width
|