Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dataset help - no Addnew but edit allowed? 1

Status
Not open for further replies.
Coxylaad

Coxylaad

Programmer
Jan 27, 2004
155
0
0
GB
Hi all,
I am trying to remove the add new record line at the bottom of my dataset but retain the ability to edit existing records.

in MS Access it would go something like:

datagrid1.allowadditions = false
datagrid1.allowedits = true

the only thing I can find in vb.net is
tablestyle.readonly = true

which locks both. Can anyone help me out please?

thanks

Ian
 
Sort by date Sort by votes
The DataView that is used by the grid to display data does have an AllowNew property. To access it you can use the following:
Code: 
Dim cm As CurrencyManager = CType(DataGrid1.BindingContext(DataGrid1.DataSource, DataGrid1.DataMember), CurrencyManager)

CType(cm.List, DataView).AllowNew = False
This prevents the AddNew row being shown, but still allows edits.
 
Upvote 0 Downvote
Thank you very much - I have been stuck on that for donkeys!

Have a star :)

Ian
 
Upvote 0 Downvote
I have discovered a bit of a snag with this.

I have the datagrid setup as a child list which is driven by its parent. When I change the parent value the child list changes but the addnew row reappears.

I have tried inserting the code to remove the addnew at the end of the selectedindex changed on the parent list box, but it seems that the relating data in the datagrid only changes when the SelectedIndexCode has finished running.

so does anyone know how to

a)Put a break in the code to allow the child fields to update, then allow me to remove the addnew row after?

b)does anyone know of a specific event which is AfterSelectedIndexChanged?

Thanks for your time.

ian

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tomminil4
  • Locked
  • Question
Help with VBA code
Replies
3
Views
118
strongm
strongm
R_a_i_n_e_r_8
  • Locked
  • Question
Compile error: Types of intolerance (need help)
Replies
3
Views
205
strongm
strongm
2009luca
  • Locked
  • Question
HOOK api dont permit the edit code in edit mode
Replies
2
Views
63
2009luca
2009luca
sal21
  • Locked
  • Question
please strongm, big help
Replies
6
Views
91
sal21
sal21
sal21
  • Locked
  • Question
big help on rest api 2
Replies
17
Views
139
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top