Search:

No Sir,

Thank you for your guidance.

BTW... your codebank on Retrieving and saving data to a database is my bible.

I learned that when I close my ACCESS database and run the code it takes 10 seconds to read the CSV and write the datatable to the database.

When I have ACCESS opened it takes over 4 minutes.

The reading of the CSV file into the DataTable takes a couple of seconds:


Dim dtTable As New DataTable
With dtTable.Columns
.Add("PasswordAdapter", GetType(String))
...

I was to fast in making the previous conclusion.

It works great with a CSV file of 10 rows.

However with a file of 10.000 rows it is again very slow.

Dear jmcilhinney...

I finally got it working with the code below (and your guidance).



Private Sub SaveCsvToDB()
Try
Dim dtTable As New DataTable
With dtTable.Columns

I also get an error while running:

Managed Debugging Assistant 'ContextSwitchDeadlock'
Message=Managed Debugging Assistant 'ContextSwitchDeadlock' : 'The CLR has been unable to transition from...

I am getting close.....

The code I have right now is the one below:


Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

' Create a variable that holds the...

Thank you very much,

I've looked through your specific codebank and got the code below:


Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

' Create a...

Hello everybody,

It has been a long time since I worked with VB.NET so I am a bit rusty.

I would like to save a CSV file to a datebase.

The part of reading the CSV file to a datatable...

Hello,

I have a form containing a datagridview with 6 columns (unbound).

On form load I add a dgvComboBoxColumn and set the default value to "Shared".
When the form loads the dgvComboBoxColumn...

Thanks again for your helpfull comment!

Thanks.
This works too and this way I have more control over what values I want to add to my string.

Hello JMCILHINNEY,

Your code works perfect for the values in the DGV.
Thanks very much.
However it seems te be quite difficult to add values to the string.

For example:
I want to add a...

Hello,

I have an unboud datagridview on my form that ultimately should result in a csv file.
However... if I leave a cell of my DGV empty a get a nullreferenceException:
...

Everybody thank you very much for ALL off your great tips and help.

I have solved it by installing the microsoft Access database engine.

There is no MS ACCESS installed on my workspace at work....

I have to mention that MS ACCESS is NOT installed on the developer client PC.

Hello everybody,

It has been a long time ago I wrote here.

But I have picked up programming VB.NET as a hobby again.

I am using VB.NET (Visual Studio Community 2019) and I am trying to make...

Thank you very much for your reaction.

But I just dont seem to get it.

When I navigate through my DGV (using the arrow keys) I want a msgbox to pop up containing the value of the first cell of...

Could anybody please send me in the right direction?

Thanks for the tip. I will test this in the weekend.

When the form opens the textbox contains the cursor and the scan is done manually.

Hello everybody,

I have a form containing a datagridview and a textbox.
When the datagridview is loaded I can navigate through the rows using the arrow keys on my keyboard.
When I click on a row...

Hello,

I have a form containing a couple of text boxes.
When the user opens the form the cursor is automatically set to the first textbox (txtBarcode).

The user now scans a label (using a...

Just trying again ;-)

Could anybody please push me in the right direction?

Thanks a bunch!

.....

Hello everybody,

JMC thanks for your reply and sorry for the fact that I just cant grasp this subject.
While I was in the hospital I played around with my problem but I just cant seem to fix it....

Hello,

After JMC's advice to add an endedit on my binding source I get the following error when i update the dataadapter:
"Dynamic SQL generation for the UpdateCommand is not supported against a...

Hello,

I have the code below to populate my DGV.
What is the best way to insert a parameter in my query.
When I have a command object I could build it in but now I am a bit lost.

Thanks in...

Solved thanks to the codebank submission of JMCilhinney!

Thanks

That's the one thing I forgot to check.

Everything works like a charm!!!!

Thank you very much.

Dear JMC,

I almost got everything to work except:
When I select a value form the combobox "column1" the valuemember isn't shown in the column "Wagen_ID" of my childtable (GetDataRit). See code...

Should I call the InitialiseDataAdapter method on each butten click event?

Dear JMC...

Once again i've returned to your very helpfull topic in the codebank.
Finally I came up with the following code but when I press the save button the data doesn't get updated to the...

Dear JMC,

I am sorry for the very late response. I was in hospital and needed to recover. So finally time to pick up where I left behind.
Your topic in the codebank was very helpfull. I copied it...

Hello,

I have a form containing a datagridview. The datagrid view also contains a DataGridViewComboBoxColumn that gets its data from a table in an ACCESS 2007 database.

The datagridview code:
...

Dear JMC,

I am fairly new to updating, inserting and deleting data from a datagridview.
After reading this topic I have build the following code:



Dim sql As String =...

Hello,

I have a piece of code that prints an empty page.

Private Sub pnKassa_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles pnKassa.Click
Me.Cursor =...

Anybody?

Hello,

I have a question about deploying an application running on ms sql server express 2008 R2.
The client has no ms sql server express R2 installed on their server (pc).

Is there a solution...

It's clear to me.

Thank you very much for explaining JMC!!!!