ليش ما بيعما update للداتا؟؟؟؟

ما هي طبيعة المشكلة بالظبط التي تواجهك ؟؟؟

وضح مثالك ليتم التعامل معه ان شاء الله

أخي العزيز....

لنفرض مثلا عندي جدول طلاب.... قمت بعرض بعض المعلومات في gridview.... وباستخدام detailsview قمت بعرض معلومات مفصى عن الطالب الذي يختاره المستخدم من الجريد فيو...... المشكلة اني اريد عمل تعديل لمعلومات الطالب بوضع خاصية التعديل في detailsview ولكنه لا يعدل المعلومات... حتى لو استخدمت ال gridview لوحدها وعملت خاصية التعديل برضو مش راضي يعدل الداتا المدخلة......

طيب قولي انت بتملأ البيانات ازاي ؟؟

او اقولك لو حطيت الكود هنا ممكن نلاقي الخطأ ان شاء الله والحل

أخي الحبيب.... انا أعرف انه في .net2005 ... لما نجعل خاصية التعديل لل gridview مسموحة حيكتبلك جملة update لوحدة بدون كتابة اي كود....

على كل حال اليك ما قمت بعمله مرفق بالصور.....

1. قمت بعمل gridviewبعد اعداد sqldatasource طبعا..

2. بعد اختيار اي حقل يتم عرض المعلومات مفصلة detailsview التي جعلت عملية التعديل فيها مسموح

3. عند الضغط على تعديل ستظهر ال detailsview في شكل editmode ولكن عند عمل تحديث لا يتم تغيير الداتا في قاعدة البيانات......

وكود ال sqldatasource كما يلي...

 <asp:SqlDataSource ID="employeespecialdatasource" runat="server" ConnectionString="<%$ ConnectionStrings:quranConnectionString %>"
									 DeleteCommand="DELETE FROM [Employees] WHERE [EmployeeId] = @original_EmployeeId AND [EmployeeBirthdate] = @original_EmployeeBirthdate AND [EmployeeBoys] = @original_EmployeeBoys AND [EmployeeFamilycount] = @original_EmployeeFamilycount AND [EmployeeWork] = @original_EmployeeWork AND [EmployeePrevwork] = @original_EmployeePrevwork AND [EmployeeLocation] = @original_EmployeeLocation AND [EmployeeAge] = @original_EmployeeAge AND [EmployeeRateb] = @original_EmployeeRateb"
									 InsertCommand="INSERT INTO [Employees] ([EmployeeBirthdate], [EmployeeBoys], [EmployeeFamilycount], [EmployeeWork], [EmployeePrevwork], [EmployeeLocation], [EmployeeAge], [EmployeeRateb], [EmployeeId]) VALUES (@EmployeeBirthdate, @EmployeeBoys, @EmployeeFamilycount, @EmployeeWork, @EmployeePrevwork, @EmployeeLocation, @EmployeeAge, @EmployeeRateb, @EmployeeId)"
									 OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT EmployeeBirthdate, EmployeeBoys, EmployeeFamilycount, EmployeeWork, EmployeePrevwork, EmployeeLocation, EmployeeAge, EmployeeRateb, EmployeeId, EmployeeState FROM Employees WHERE (EmployeeId = @EmployeeId)"
									 UpdateCommand="UPDATE [Employees] SET [EmployeeBirthdate] = @EmployeeBirthdate, [EmployeeBoys] = @EmployeeBoys, [EmployeeFamilycount] = @EmployeeFamilycount, [EmployeeWork] = @EmployeeWork, [EmployeePrevwork] = @EmployeePrevwork, [EmployeeLocation] = @EmployeeLocation, [EmployeeAge] = @EmployeeAge, [EmployeeRateb] = @EmployeeRateb WHERE [EmployeeId] = @original_EmployeeId AND [EmployeeBirthdate] = @original_EmployeeBirthdate AND [EmployeeBoys] = @original_EmployeeBoys AND [EmployeeFamilycount] = @original_EmployeeFamilycount AND [EmployeeWork] = @original_EmployeeWork AND [EmployeePrevwork] = @original_EmployeePrevwork AND [EmployeeLocation] = @original_EmployeeLocation AND [EmployeeAge] = @original_EmployeeAge AND [EmployeeRateb] = @original_EmployeeRateb">
									 <InsertParameters>
										 <asp:Parameter Name="EmployeeBirthdate" Type="DateTime" />
										 <asp:Parameter Name="EmployeeBoys" Type="Int32" />
										 <asp:Parameter Name="EmployeeFamilycount" Type="Int32" />
										 <asp:Parameter Name="EmployeeWork" Type="String" />
										 <asp:Parameter Name="EmployeePrevwork" Type="String" />
										 <asp:Parameter Name="EmployeeLocation" Type="String" />
										 <asp:Parameter Name="EmployeeAge" Type="Int32" />
										 <asp:Parameter Name="EmployeeRateb" Type="Int32" />
										 <asp:Parameter Name="EmployeeId" Type="Int32" />
									 </InsertParameters>
									 <SelectParameters>
										 <asp:ControlParameter ControlID="GridView1" Name="EmployeeId" PropertyName="SelectedValue"
											 Type="Int32" />
									 </SelectParameters>
									 <UpdateParameters>
										 <asp:Parameter Name="EmployeeBirthdate" Type="DateTime" />
										 <asp:Parameter Name="EmployeeBoys" Type="Int32" />
										 <asp:Parameter Name="EmployeeFamilycount" Type="Int32" />
										 <asp:Parameter Name="EmployeeWork" Type="String" />
										 <asp:Parameter Name="EmployeePrevwork" Type="String" />
										 <asp:Parameter Name="EmployeeLocation" Type="String" />
										 <asp:Parameter Name="EmployeeAge" Type="Int32" />
										 <asp:Parameter Name="EmployeeRateb" Type="Int32" />
										 <asp:Parameter Name="original_EmployeeId" Type="Int32" />
										 <asp:Parameter Name="original_EmployeeBirthdate" Type="DateTime" />
										 <asp:Parameter Name="original_EmployeeBoys" Type="Int32" />
										 <asp:Parameter Name="original_EmployeeFamilycount" Type="Int32" />
										 <asp:Parameter Name="original_EmployeeWork" Type="String" />
										 <asp:Parameter Name="original_EmployeePrevwork" Type="String" />
										 <asp:Parameter Name="original_EmployeeLocation" Type="String" />
										 <asp:Parameter Name="original_EmployeeAge" Type="Int32" />
										 <asp:Parameter Name="original_EmployeeRateb" Type="Int32" />
									 </UpdateParameters>
									 <DeleteParameters>
										 <asp:Parameter Name="original_EmployeeId" Type="Int32" />
										 <asp:Parameter Name="original_EmployeeBirthdate" Type="DateTime" />
										 <asp:Parameter Name="original_EmployeeBoys" Type="Int32" />
										 <asp:Parameter Name="original_EmployeeFamilycount" Type="Int32" />
										 <asp:Parameter Name="original_EmployeeWork" Type="String" />
										 <asp:Parameter Name="original_EmployeePrevwork" Type="String" />
										 <asp:Parameter Name="original_EmployeeLocation" Type="String" />
										 <asp:Parameter Name="original_EmployeeAge" Type="Int32" />
										 <asp:Parameter Name="original_EmployeeRateb" Type="Int32" />
									 </DeleteParameters>
								 </asp:SqlDataSource>

emp.bmp