need help in update query.

Question

currently am working on student management system. i am adding student details along with what class and section they are studing by selecting class and section combobox control. The added student details are stored into respective class with section table like  tbl_Nursery_A . and  tbl_Nursery_B . The same manner there will be tables upto 10th class. when adding student details there may chances that we may choose wrong section and class.  How can i update student correct studing details to the tables in EditStudentForm ?.

Laxmidhar Sahoo · Answer

hi 1- should update in a stored procedure .So it is easy for you 2-always updation try to complete on the bases of Id those are unique /text field that should unique values  3-Check the student whether present in that class and section or not useing select query like   select count(*) from student where  class = ' Nursery' and section= ' tbl_Nursery_A '   It will return a number  1 or 0. If 1  then update   like that update query   update tablename set columnname1 =   value,cloum2 = values where  class = ' Nursery' and section= ' tbl_Nursery_A '  abd studentid = id value

Jignesh Kumar · Answer

Hey,   Please share your table structure so member can help you exactly what you are looking for, As @rajanikant told you can do based on studentId

Rajanikant Hawaldar · Answer

You should update using studentId