Winan,
>...is it possible for me to INSERT/UPDATE/DELETE record(s) thru dataset? How are you currently updating your database? I assume, since you asked this question, that you are probably manually creating insert/update/delete SQL strings to do this. But, yes, you can also do the database updates from a DataSet. And the reason that I mentioned manually populating a DataSet was because you need the DataSet for your grid anyway, so it's preferable to the way you're currently doing it.
>...if I use dataset to INSERT/UPDATE/DELETE record(s) then is it still necessary for me to do clear and then fill the dataset again and again.. for showing them to datagrid?No, and that's the point of doing it this way ... you already have the data in DataSet, so there's no need to re-fill it.
~~Bonnie