Click here to Skip to main content
11,716,133 members (87,534 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: Access VB.NET DataGridView , +
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 at 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 at 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 at 14-Jan-13 14:36pm
Eagle-Eye, +5!
Sandeep Mewara at 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
0 Sergey Alexandrovich Kryukov 599
1 Richard MacCutchan 280
2 Maciej Los 275
3 OriginalGriff 160
4 F-ES Sitecore 145
0 Sergey Alexandrovich Kryukov 1,003
1 Richard MacCutchan 430
2 CHill60 415
3 Maciej Los 399
4 OriginalGriff 385

Advertise | Privacy | Mobile
Web01 | 2.8.150901.1 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2015
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