Modifying the database entries using vb
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:
before modifying the data i need the information to be displayed in the screen and then it has to be updated. please help me
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
Replies
-
shalini_goel14
Hi zia.sepsis,zia.sepsiscan 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
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?๐ -
zia.sepsis
Can you give me the code for your viewshalini_goel14Hi 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?๐ -
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.zia.sepsisCan you give me the code for your view
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. ๐ -
zia.sepsis
Thanks mate.shalini_goel14What 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. ๐ -
safwanhi 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 -
zia.sepsis
Its ok matesafwanhi 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 -
CEMemberSo buddy zia.sepsis, is your problem solved? Please share here,even i also want to know the answer.๐
-
zia.sepsis
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.....CEMemberSo buddy zia.sepsis, is your problem solved? Please share here,even i also want to know the answer.๐ -
zia.sepsis
Thanks shalini......๐ your idea helped me a lot.shalini_goel14What 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. ๐ -
shalini_goel14
Please share that part of code here zia.sepsis if possible. May be it can help us all. ๐zia.sepsisi have written some codes , which will show you the required data,
Welcome zia !! ๐. Happy to helpzia.sepsisThanks shalini......๐ your idea helped me a lot.
You are reading an archived discussion.
Related Posts
Hi
I have the following project:
I need to build a robot with 2 microphones attached to it on either side. The robot is placed on a 4x4 meter grid....
CEans,
Here's a great piece of advice to startup entrepreneurs: ( link-> ) Wisdom in hindsight: Team Up Scale Up
What do you say?
Hello CEans,
If you are organizing (or recently organized) any event in your college you'll be happy to read this announcement. We know organizing any event involves lot of work,...
Official Website: Requirements Engineering Conference (RE'09)
The International Requirements Engineering Conference is sponsored by the IEEE and is the premier academic and industrial event in the field of Requirements Engineering....
Hiii all,
In a Direct Sequence Spread Spectrum system, besides changing the types of modulator used, and adding more noises and fading to the channel, what else can we change...