Inserting data to datagridview from datatable only record last input

Question

0.00/5 (No votes)

See more:

i like to insert data from textbox and try getting displaying to datagridview by using datatable,
i can make success on first row but have problem on second row and ect because data gridview only displayed last input, What target is, i am going to input with different data for each row, please advice the solution Thanks...

What I have tried:

VB

Private Sub Create_VTableSell()
        Dim vRow As System.Data.DataRow
        Dim i As Integer
        VTablepenjualan = New DataTable
        VTablepenjualan.Columns.Add("Name_Items", GetType(String))
        VTablepenjualan.Columns.Add("Qty", GetType(Integer))
        VTablepenjualan.Columns.Add("Price", GetType(Double))
        VTablepenjualan.Columns.Add("Disc%", GetType(Double))
        VTablepenjualan.Columns.Add("Sub_Total", GetType(Double))
        VTablepenjualan.Columns.Add("Mode", GetType(String))
        'Try
        For i = 0 To DataGridView1.Rows.Count - 0
            'If IsDBNull(DataGridView1.Rows) Then Exit Sub
            vRow = VTableSell.NewRow
            vRow.Item(0) = TextBox4.Text
            vRow.Item(1) = TextBox5.Text
            vRow.Item(2) = TextBox6.Text
            vRow.Item(3) = TextBox7.Text
            vRow.Item(4) = TextBox5.Text * TextBox6.Text
            vRow.Item(5) = ComboBox1.Text
            VTableSell.Rows.Add(vRow)
        Next
         DataGridView1.Refresh()
        'Catch ex As Exception
        'End Try
    End Sub

Posted 2-Dec-16 23:46pm

Dargombes Romadlon

Updated 3-Dec-16 0:29am

Michael_Davies

v2

Add a Solution

Comments

Michael_Davies 3-Dec-16 6:28am

You are adding the contents of a set of text boxes, the content of the text boxes does not change between each iteration of the loop.

Counts are zero based so you would normally iterate the DataGridView1.Rows.Count - 1 or you might get an out of range index exception.

Where are VTableSell and VTablepenjualan, you create VTablepenjualan and never seem to use it.

Dargombes Romadlon 3-Dec-16 10:24am

i was thinking problem on loop but do not know where exactly
i have been tried to put rows.count-1 but the datagridview doesn't display any data

vTableSell is sub name, vTablepenjualan was declare earlier..

Michael_Davies 3-Dec-16 10:31am

The loop is tied to the number of rows in the DataGridView1, how many records are there? Use the debugger to walk the code through and see what is happening.

Dargombes Romadlon 3-Dec-16 10:44am

will be a lot of record because it purposed to creating per row in one record, some how i didn't see any error show up

Michael_Davies 3-Dec-16 11:12am

Okay as it is not clear change the loop line to the following and see what happens, then use the debugger to walk thru and see what is happening and work out what is wrong.

For i = 0 to 10

Dargombes Romadlon 4-Dec-16 21:20pm

Seem's like datagridview creating 10 row in same input per row, after i input another value all row was replacing by new input, look like not creating new row behind the previous row

Michael_Davies 5-Dec-16 1:55am

So now do you see the problem, you were using the row count of the DGV to insert the data and there were no rows to count so no rows inserted, changing the for loop to a number range proved that to you.

The data does not change between inserts so you insert the same data over and over again.

Everything is working fine it is doing what you ask it to do you just need to rethink the logic of what you are trying to do, unfortunately no one can do that for you.

Dargombes Romadlon 5-Dec-16 12:58pm

Thanks for your advice now i got another perspective view and technical trick, but i am still curious with technic inserting data via datatable to datagridview, for the moment i will back to very basic inserting directly from textbox to datagridview with creating column on form load then add new row from button click

Michael_Davies 5-Dec-16 13:11pm

You can set the DataSource of the DGV to be the table if that is what you wish, use Google lots of examples and explore.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)