Modifying the database entries using vb

zia.sepsis · 2009-02-20T04:39:52+00:00

I have created a standard connection(oracle) and i have created a new recordset during the on load of the main form. The project is named as student information system and deals with the addition, modification,deletion of the data. Here is the relevant code: Dim con as new adodb.connection Dim rs as new adodb.recordset ------------------------------ private sub add() rs.addnew call add rs.update msgbox"record added" call clear end sub ----------------------------- can any help me by providing me the code to modify the data's before modifying the data i need the information to be displayed in the screen and then it has to be updated. please help me

Modifying the database entries using vb

zia.sepsis
@ziasepsis-0NGPzn

Updated: Oct 22, 2024

Views: 1.3K
I have created a standard connection(oracle) and i have created a new recordset during the on load of the main form. The project is named as student information system and deals with the addition, modification,deletion of the data.
Here is the relevant code:
```
Dim con as new adodb.connection
Dim rs as new adodb.recordset
------------------------------
private sub add()
rs.addnew
call add
rs.update
msgbox"record added"
call clear
end sub
-----------------------------
```
can any help me by providing me the code to modify the data's
before modifying the data i need the information to be displayed in the screen and then it has to be updated. please help me
0

Replies

Howdy guest!

Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.

Replies

shalini_goel14

Member • Feb 20, 2009

zia.sepsis
can any help me by providing me the code to modify the data's
before modifying the data i need the information to be displayed in the screen and then it has to be updated. please help me
Hi zia.sepsis,

Firstly I am not clear about your question .If you are asking for displaying data, I guess you can use textboxes and datagrids for showing and then use rs.update for saving changes into the database right?Or Am I taking your question wrong?😕

Are you sure? This action cannot be undone.
Cancel
zia.sepsis

Member • Feb 20, 2009

shalini_goel14
Hi zia.sepsis,

Firstly I am not clear about your question .If you are asking for displaying data, I guess you can use textboxes and datagrids for showing and then use rs.update for saving changes into the database right?Or Am I taking your question wrong?😕
Can you give me the code for your view

Are you sure? This action cannot be undone.
Cancel
shalini_goel14

Member • Feb 20, 2009

zia.sepsis
Can you give me the code for your view
What is there in code for this? Just drag and drop the textboxes/ data grid to your form and bind it to your dataset. Thats it.

I don't have VB setup with me otherwise I could provide you with code. Sorry 😔

May be CEans safwan can help you out in this. He will be back here after 23rd Feb.Please have patience till then. 😀

Are you sure? This action cannot be undone.
Cancel
zia.sepsis

Member • Feb 20, 2009

shalini_goel14
What is there in code for this? Just drag and drop the textboxes/ data grid to your form and bind it to your dataset. Thats it.

I don't have VB setup with me otherwise I could provide you with code. Sorry 😔

May be CEans safwan can help you out in this. He will be back here after 23rd Feb.Please have patience till then. 😀
Thanks mate.

Are you sure? This action cannot be undone.
Cancel
safwan

Member • Feb 26, 2009

hi zia till now my teacher in school did not teach me how to join oracle in school but i was able to make connection with your help before but working with data grides frankly i dont know it will be teach to me in next year means in 12 class. i am sorry

@ shallini ( i am beginior in vb). thanks

Are you sure? This action cannot be undone.
Cancel
zia.sepsis

Member • Feb 26, 2009

safwan
hi zia till now my teacher in school did not teach me how to join oracle in school but i was able to make connection with your help before but working with data grides frankly i dont know it will be teach to me in next year means in 12 class. i am sorry

@ shallini ( i am beginior in vb). thanks
Its ok mate

Are you sure? This action cannot be undone.
Cancel
CEMember

Member • Feb 26, 2009

So buddy zia.sepsis, is your problem solved? Please share here,even i also want to know the answer.😔

Are you sure? This action cannot be undone.
Cancel
zia.sepsis

Member • Feb 28, 2009

CEMember
So buddy zia.sepsis, is your problem solved? Please share here,even i also want to know the answer.😔
i have done things in accordance to shalani's suggestions..... i have created a new form for the purpose of updation. i have written some codes , which will show you the required data, this process is done at the time of loading the updation form. this made updating,delete as a easy one.... i guess this may help you.....

Are you sure? This action cannot be undone.
Cancel
zia.sepsis

Member • Feb 28, 2009

shalini_goel14
What is there in code for this? Just drag and drop the textboxes/ data grid to your form and bind it to your dataset. Thats it.

I don't have VB setup with me otherwise I could provide you with code. Sorry 😔

May be CEans safwan can help you out in this. He will be back here after 23rd Feb.Please have patience till then. 😀
Thanks shalini......😁 your idea helped me a lot.

Are you sure? This action cannot be undone.
Cancel
shalini_goel14

Member • Feb 28, 2009

zia.sepsis
i have written some codes , which will show you the required data,
Please share that part of code here zia.sepsis if possible. May be it can help us all. 😀

zia.sepsis
Thanks shalini......😁 your idea helped me a lot.
Welcome zia !! 😁. Happy to help

Are you sure? This action cannot be undone.
Cancel