Update a sql table using Windows form from the Menustrip

Bineesh Viswanath

Sir I am Doing ADO.NET Program using C# and sql Server.

I want your help in the followings.

I want to open a form using menuStrip with full data I saved in the form.

lets see the MDI Parent Form:-

See in the Menu School. there is four items; one to create school and the edit(Update) and delete.

I did the Create school function.

I want your help in the Edit School Item

when I click in the edit school , I want to open the form frmSchool with data in it

lets see the frmSchool

see when click in the edit school , I want full data in the each control of this form.

My task is update function on this form.

please give me a solution.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bineesh Viswanath13y ago
How I can retrieve the saved data from database and bind to all controls?

take look at the form from where we do this operation.

This is the form. My tasks are;-

1) A new school to be created when i click menu item Create School.

2)The school saved to be retrieved and bind with the concerned controls when i click in the menu item Edit School.

Let me know how this possible?
Iftikar Hussain13y ago
Hi,
On loading edit school form,retrieve the saved data from your database and bind it to all controls.

Regards,
Iftikar
Ravi Shekhar13y ago
On the click of edit button open same form .
and on the page load get all the data of this schhol and bind every textbox one by one Now on the click of update run a update query with atleast single where clause .
Kunal Vaishya13y ago
Hi Bineesh ,

I can suggest one idea regarding this ,

You can do like this At the time of opening for you can set create a form object into MDI for that form ,which form opened and after when you clicked on save button In MDI form then call that Save Event of form Object. Its not Easy task but i can help you as concept if any confusion then tell us we are here.
Bineesh Viswanath13y ago
this code is I think only for open a form.

I want to do is the updation.

So when I click on the edit school in menustrip, I want to load full data to corresponding fields
of the form.
Naveed Zaman13y ago
don't worry you need to use mdi child property on. for example FrmReciveCall frmreccall = new FrmReciveCall(); frmreccall.MdiParent = this; frmreccall.Show();