Datagrid to Database...

[Inbaraj]

Hi...

I want to insert some values to Database(Oracle ) from Datagrid. I want to Check the datagrid value and databse value. If value is present value should not get updated if value is not present database should be updated..

plz hepl me how to do this...

Thanks in advance.....

with reg
inbaraj.D

[Shashi Sadasivan]

lets call the dataset being used by the datagrid as dataGridToInser t
Create another dataset by reading the existing jobs from the database. = dataSetDB

loop through each row of dataSetDB and check if that row exists in dataGridToInser t

If it does then use the Delete method of dataGridToInser t's row to remove that row.

cheers

[Inbaraj]

lets call the dataset being used by the datagrid as dataGridToInser t
Create another dataset by reading the existing jobs from the database. = dataSetDB

loop through each row of dataSetDB and check if that row exists in dataGridToInser t

If it does then use the Delete method of dataGridToInser t's row to remove that row.

cheers

Sir,
In my database there is more then 1 lake record and my database is placed away i am using VSAT to retrive the data...

[Plater]

Please try not to double post.

http://www.thescripts. com/forum/thread723641.ht ml