Click here to Skip to main content
13,191,638 members (62,294 online)
Rate this:
Please Sign up or sign in to vote.
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 ?
Posted 14-Jan-13 2:51am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Looks like this is the cuplprit:

It looks that HowStill is a textbox control. You might need to do:
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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.171017.2 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100