Update many rows in GridView Asp.Net

Question

hi, I have a gridview with edit button. The edit works fine, but the probelm is I can only edit and update one row, when i edit the other row it does not get updated. I did not do any behind code for updating or editing, i just used data sources. Please help me thanks.

Guest User · Answer

Edit and Update Record in GridView in ASP.Net http://www.c-sharpcorner.com/UploadFile/1e050f/edit-and-update-record-in-gridview-in-Asp-Net/

Azm Amn · Answer

My aspx code: Approve or Reject Subjects Programme: " SelectCommand="SELECT [Programme] FROM [Programme]"> Status: Not Yet Approved Recommended By PL '> '> '> NEW INTAKE ENROLLMENT REPEAT SEMESTER REPEAT SUBJECT '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> Not Yet Approved Recommended By PL '> '> '> " DeleteCommand="DELETE FROM [Registration] WHERE [Registration_ID] = @original_Registration_ID AND [Type] = @original_Type AND [StudentName] = @original_StudentName AND [IC_PassportNum] = @original_IC_PassportNum AND [Student_ID] = @original_Student_ID AND [ContactNumber] = @original_ContactNumber AND [Semester] = @original_Semester AND [Semester_ID] = @original_Semester_ID AND (([Intake] = @original_Intake) OR ([Intake] IS NULL AND @original_Intake IS NULL)) AND [Sponsor] = @original_Sponsor AND [Faculty] = @original_Faculty AND [Programme] = @original_Programme AND [Subject1] = @original_Subject1 AND (([Subject1_Credit] = @original_Subject1_Credit) OR ([Subject1_Credit] IS NULL AND @original_Subject1_Credit IS NULL)) AND [Subject2] = @original_Subject2 AND (([Subject2_Credit] = @original_Subject2_Credit) OR ([Subject2_Credit] IS NULL AND @original_Subject2_Credit IS NULL)) AND [Subject3] = @original_Subject3 AND (([Subject3_Credit] = @original_Subject3_Credit) OR ([Subject3_Credit] IS NULL AND @original_Subject3_Credit IS NULL)) AND [Subject4] = @original_Subject4 AND (([Subject4_Credit] = @original_Subject4_Credit) OR ([Subject4_Credit] IS NULL AND @original_Subject4_Credit IS NULL)) AND [Subject5] = @original_Subject5 AND (([Subject5_Credit] = @original_Subject5_Credit) OR ([Subject5_Credit] IS NULL AND @original_Subject5_Credit IS NULL)) AND [Subject6] = @original_Subject6 AND (([Subject6_Credit] = @original_Subject6_Credit) OR ([Subject6_Credit] IS NULL AND @original_Subject6_Credit IS NULL)) AND [Subject7] = @original_Subject7 AND (([Subject7_Credit] = @original_Subject7_Credit) OR ([Subject7_Credit] IS NULL AND @original_Subject7_Credit IS NULL)) AND [Subject8] = @original_Subject8 AND (([Subject8_Credit] = @original_Subject8_Credit) OR ([Subject8_Credit] IS NULL AND @original_Subject8_Credit IS NULL)) AND [TotalCreditHours] = @original_TotalCreditHours AND [RegistrationStatus] = @original_RegistrationStatus AND [RecommendedBy] = @original_RecommendedBy" InsertCommand="INSERT INTO [Registration] ([Type], [StudentName], [IC_PassportNum], [Student_ID], [ContactNumber], [Semester], [Semester_ID], [Intake], [Sponsor], [Faculty], [Programme], [Subject1], [Subject1_Credit], [Subject2], [Subject2_Credit], [Subject3], [Subject3_Credit], [Subject4], [Subject4_Credit], [Subject5], [Subject5_Credit], [Subject6], [Subject6_Credit], [Subject7], [Subject7_Credit], [Subject8], [Subject8_Credit], [TotalCreditHours], [RegistrationStatus], [RecommendedBy]) VALUES (@Type, @StudentName, @IC_PassportNum, @Student_ID, @ContactNumber, @Semester, @Semester_ID, @Intake, @Sponsor, @Faculty, @Programme, @Subject1, @Subject1_Credit, @Subject2, @Subject2_Credit, @Subject3, @Subject3_Credit, @Subject4, @Subject4_Credit, @Subject5, @Subject5_Credit, @Subject6, @Subject6_Credit, @Subject7, @Subject7_Credit, @Subject8, @Subject8_Credit, @TotalCreditHours, @RegistrationStatus, @RecommendedBy)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [Registration_ID], [Type], [StudentName], [IC_PassportNum], [Student_ID], [ContactNumber], [Semester], [Semester_ID], [Intake], [Sponsor], [Faculty], [Programme], [Subject1], [Subject1_Credit], [Subject2], [Subject2_Credit], [Subject3], [Subject3_Credit], [Subject4], [Subject4_Credit], [Subject5], [Subject5_Credit], [Subject6], [Subject6_Credit], [Subject7], [Subject7_Credit], [Subject8], [Subject8_Credit], [TotalCreditHours], [RegistrationStatus], [RecommendedBy] FROM [Registration] WHERE (([Programme] = @Programme) AND ([RegistrationStatus] = @RegistrationStatus))" UpdateCommand="UPDATE [Registration] SET [Type] = @Type, [StudentName] = @StudentName, [IC_PassportNum] = @IC_PassportNum, [Student_ID] = @Student_ID, [ContactNumber] = @ContactNumber, [Semester] = @Semester, [Semester_ID] = @Semester_ID, [Intake] = @Intake, [Sponsor] = @Sponsor, [Faculty] = @Faculty, [Programme] = @Programme, [Subject1] = @Subject1, [Subject1_Credit] = @Subject1_Credit, [Subject2] = @Subject2, [Subject2_Credit] = @Subject2_Credit, [Subject3] = @Subject3, [Subject3_Credit] = @Subject3_Credit, [Subject4] = @Subject4, [Subject4_Credit] = @Subject4_Credit, [Subject5] = @Subject5, [Subject5_Credit] = @Subject5_Credit, [Subject6] = @Subject6, [Subject6_Credit] = @Subject6_Credit, [Subject7] = @Subject7, [Subject7_Credit] = @Subject7_Credit, [Subject8] = @Subject8, [Subject8_Credit] = @Subject8_Credit, [TotalCreditHours] = @TotalCreditHours, [RegistrationStatus] = @RegistrationStatus, [RecommendedBy] = @RecommendedBy WHERE [Registration_ID] = @original_Registration_ID AND [Type] = @original_Type AND [StudentName] = @original_StudentName AND [IC_PassportNum] = @original_IC_PassportNum AND [Student_ID] = @original_Student_ID AND [ContactNumber] = @original_ContactNumber AND [Semester] = @original_Semester AND [Semester_ID] = @original_Semester_ID AND (([Intake] = @original_Intake) OR ([Intake] IS NULL AND @original_Intake IS NULL)) AND [Sponsor] = @original_Sponsor AND [Faculty] = @original_Faculty AND [Programme] = @original_Programme AND [Subject1] = @original_Subject1 AND (([Subject1_Credit] = @original_Subject1_Credit) OR ([Subject1_Credit] IS NULL AND @original_Subject1_Credit IS NULL)) AND [Subject2] = @original_Subject2 AND (([Subject2_Credit] = @original_Subject2_Credit) OR ([Subject2_Credit] IS NULL AND @original_Subject2_Credit IS NULL)) AND [Subject3] = @original_Subject3 AND (([Subject3_Credit] = @original_Subject3_Credit) OR ([Subject3_Credit] IS NULL AND @original_Subject3_Credit IS NULL)) AND [Subject4] = @original_Subject4 AND (([Subject4_Credit] = @original_Subject4_Credit) OR ([Subject4_Credit] IS NULL AND @original_Subject4_Credit IS NULL)) AND [Subject5] = @original_Subject5 AND (([Subject5_Credit] = @original_Subject5_Credit) OR ([Subject5_Credit] IS NULL AND @original_Subject5_Credit IS NULL)) AND [Subject6] = @original_Subject6 AND (([Subject6_Credit] = @original_Subject6_Credit) OR ([Subject6_Credit] IS NULL AND @original_Subject6_Credit IS NULL)) AND [Subject7] = @original_Subject7 AND (([Subject7_Credit] = @original_Subject7_Credit) OR ([Subject7_Credit] IS NULL AND @original_Subject7_Credit IS NULL)) AND [Subject8] = @original_Subject8 AND (([Subject8_Credit] = @original_Subject8_Credit) OR ([Subject8_Credit] IS NULL AND @original_Subject8_Credit IS NULL)) AND [TotalCreditHours] = @original_TotalCreditHours AND [RegistrationStatus] = @original_RegistrationStatus AND [RecommendedBy] = @original_RecommendedBy"> " SelectCommand="SELECT DISTINCT [SubjectName] FROM [Subjects] WHERE ([Programme] = @Programme)">

Ramesh Palanivel · Answer

Hi ASM, Can u share Ur code?

Update many rows in GridView Asp.Net

Answers (3)