Click here to Skip to main content
15,940,550 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
I make function to save data from datagridveiw to Access data Base

Private Function SD()
    Dim I As Integer
    For I = 0 To Me.DataGridView1.Rows.Count - 1
        Me.VendorLongBillTableAdapter1.Insert(Me.DataGridView1.Item(0, I).Value, Me.DataGridView1.Item(1, I).Value, Me.DataGridView1.Item(2, I).Value, Val(Me.DataGridView1.Item(3, I).Value), Val(Me.DataGridView1.Item(5, I).Value), Val(Me.DataGridView1.Item(4, I).Value) * Val(Me.DataGridView1.Item(3, I).Value), Val(HowIPaid.Text), Val(HowStill), Me.DataGridView1.Item(7, I).Value, Convert.ToDateTime(Me.DataGridView1.Item(6, I).Value))
        'TODO: This line of code loads data into the 'RAFAADataSet.Prudects' table. You can move, or remove it, as needed.
End Function

but when I use this function error happened

Argument 'Expression' cannot be converted to type 'TextBox'

where is the error ?

1 solution

Looks like this is the cuplprit:

It looks that HowStill is a textbox control. You might need to do:
Share this answer
Maciej Los 14-Jan-13 10:51am    
Moved from answer:
the value I have insert is String not double so if I input
val(HowStill.txt) it will return it to value = 0

Sandeep Mewara 14-Jan-13 13:03pm    
Thanks Maciej.

To OP:
Then simply put: HowStill.Text

If you know that you need text then how can you provide a control object instead of a value?! :doh:
Maciej Los 14-Jan-13 14:36pm    
Eagle-Eye, +5!
Sandeep Mewara 15-Jan-13 8:04am    
Thanks Mac. :)

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900