Update a sql table using Windows form from the Menustrip

Question

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.

Bineesh VP · Answer

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 Hussain · Answer

Hi On loading edit school formretrieve the saved data from your database and bind it to all controls. Regards Iftikar

Ravi Shekhar · Answer

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 Vaishya · Answer

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 VP · Answer

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 Zaman · Answer

don't worry you need to use mdi child property on. for example FrmReciveCall frmreccall = new FrmReciveCall(); frmreccall.MdiParent = this; frmreccall.Show();