×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help Implementing datagridview as data entry

Help Implementing datagridview as data entry

Help Implementing datagridview as data entry

(OP)
I am trying to implement this functionality in a data entry form for my application.
The form will have a datagridview (dtgOffices) with 8 columns..
First column is a datagridviewtextboxcolumn, three datagridviewcombobox columns and another datagridviewtextboxcolumn, that will indicate if this is an existing office. The last columns are the dataentry text columns.
Onchange of value of the 1st column (Office ID), a datatable will be generated containing the records that will populate the 2nd (Region), 3rd (State),
and City (4th) comboboxes. When a Region is selected from the drop-down, only the State belonging to that Region should be available in the State combobox .. and so on and so forth.
After, if no record for this ID, 5th column will have an "N".

I was able to add a first row (Region only, for now, will take take of the rest once resolved) for an exisitng office ID
But when I entered non-existent office ID on the 2nd row data entry, the Region combobox is still populated with item from the previous tax id.

This is my Code:

Dim bsOffice as new BindingSource

if dtOffice.rows.count > 0 then 'this is the datatable that has the Region, State, and Cith info for a particular office ID, office ID has multiple Regions, States and Cities

bsOffice.DataSource = dtOffice

Dim cboRegion As DataGridViewComboBoxColumn = DirectCast(dtgOffices.Columns("Region"), DataGridViewComboBoxColumn)
cboRegion.DisplayMember = "RegionName"
cboRegion.ValueMember = "RegionID"
cboRegion.DataSource = bsOffice

Else
bsOffice.DataSource = Nothing
Exit Sub
End If

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close