Modifying the database entries using vb

@ziasepsis-0NGPzn • Oct 22, 2024

Oct 22, 2024

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

Like 0 Replies 10

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

shalini_goel14

@shalini-goel14-ASmC2J • 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?😕
0
zia.sepsis

@ziasepsis-0NGPzn • 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
0
shalini_goel14

@shalini-goel14-ASmC2J • 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. 😀
0
zia.sepsis

@ziasepsis-0NGPzn • 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.
0
safwan

@safwan-NH7W5Y • 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
0
zia.sepsis

@ziasepsis-0NGPzn • 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
0
CEMember

@cemember-PlqlWH • Feb 26, 2009

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

@ziasepsis-0NGPzn • 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.....
0
zia.sepsis

@ziasepsis-0NGPzn • 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.
0
shalini_goel14

@shalini-goel14-ASmC2J • 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
0