How to clear fields in Data Grid...

i have try datagrid.clearfields to clear up the fields before insert new data but can't work.

can i know the code for it.
LVL 1
cyseng10Asked:
Who is Participating?
 
Barry CunneyConnect With a Mentor Commented:
If your datagrid is bound to ADO  data control you can set reset recordsource to sql that you know will not return any records

Adodc1.RecordSource = "Select * from Personnel where PersonnelID = '2222'"
Adodc1.Refresh

I know there is no PersonnelID 2222
0
 
DanRollinsCommented:
Hi cyseng10,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept BCUNNEY's comment(s) as an answer.

cyseng10, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer
0
 
SpideyModCommented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.