数据正在更新后失踪 [英] Data are missing after updating
问题描述
好吧,我会和图像讨论我的问题,所以我们可以很容易地解决这个问题。希望。
Okay I'll discuss my problem with images so we can solve it easily. Hoping.
首先,图像下图为PersonalInfo.aspx下PersonalInfo GridView控件
First, The image below shows the PersonalInfo gridview under PersonalInfo.aspx
二,下面的图片显示MobileINfo.aspx下MobileInfo gridview的
Second, The image below shows the MobileInfo gridview under MobileINfo.aspx
第三,我们现在要编辑该页面中的记录MobileInfo.aspx
Third, now we are going to edit the record in this page MobileInfo.aspx
四,下面我形象思维一切完美,因为数据已更新。但是...
Fourth, Image below I thought everything works perfectly because the data has been updated. But...
第五和最后一个,我又回到了PersonalInfo.aspx但它给了我这个...数据已被删除
Fifth and last, I went back in PersonalInfo.aspx but it gives me this...Data has been deleted
下面是我的code为PersonalInfo.aspx
Here's my code for PersonalInfo.aspx
<asp:AccessDataSource runat="server" ID="AccessDataSource1" DeleteCommand="DELETE FROM [DriversRecords] WHERE [ID] = ?" InsertCommand="INSERT INTO [DriversRecords] ([Username], [Password], [FirstName], [LastName], [MiddleName], [Address], [Age], [Gender], [ContactNumber], [PlateNumber], [Color], [Brand], [LiscensedNumber], [SSSNumber], [TIN], [Type], [Model], [BirthDay], [BirthMonth], [BirthYear]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" UpdateCommand="UPDATE [DriversRecords] SET [Username] = ?, [Password] = ?, [FirstName] = ?, [LastName] = ?, [MiddleName] = ?, [Address] = ?, [Age] = ?, [Gender] = ?, [ContactNumber] = ?, [PlateNumber] = ?, [Color] = ?, [Brand] = ?, [LiscensedNumber] = ?, [SSSNumber] = ?, [TIN] = ?, [Type] = ?, [Model] = ?, [BirthDay] = ?, [BirthMonth] = ?, [BirthYear] = ? WHERE [ID] = ?" DataFile="_private/records.mdb" SelectCommand="SELECT * FROM [DriversRecords]">
<DeleteParameters>
<asp:parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:parameter Name="Username" Type="String" />
<asp:parameter Name="Password" Type="String" />
<asp:parameter Name="FirstName" Type="String" />
<asp:parameter Name="LastName" Type="String" />
<asp:parameter Name="MiddleName" Type="String" />
<asp:parameter Name="Address" Type="String" />
<asp:parameter Name="Age" Type="String" />
<asp:parameter Name="Gender" Type="String" />
<asp:parameter Name="ContactNumber" Type="String" />
<asp:parameter Name="PlateNumber" Type="String" />
<asp:parameter Name="Color" Type="String" />
<asp:parameter Name="Brand" Type="String" />
<asp:parameter Name="LiscensedNumber" Type="String" />
<asp:parameter Name="SSSNumber" Type="String" />
<asp:parameter Name="TIN" Type="String" />
<asp:parameter Name="Type" Type="String" />
<asp:parameter Name="Model" Type="String" />
<asp:parameter Name="BirthDay" Type="String" />
<asp:parameter Name="BirthMonth" Type="String" />
<asp:parameter Name="BirthYear" Type="String" />
<asp:parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:parameter Name="Username" Type="String" />
<asp:parameter Name="Password" Type="String" />
<asp:parameter Name="FirstName" Type="String" />
<asp:parameter Name="LastName" Type="String" />
<asp:parameter Name="MiddleName" Type="String" />
<asp:parameter Name="Address" Type="String" />
<asp:parameter Name="Age" Type="String" />
<asp:parameter Name="Gender" Type="String" />
<asp:parameter Name="ContactNumber" Type="String" />
<asp:parameter Name="PlateNumber" Type="String" />
<asp:parameter Name="Color" Type="String" />
<asp:parameter Name="Brand" Type="String" />
<asp:parameter Name="LiscensedNumber" Type="String" />
<asp:parameter Name="SSSNumber" Type="String" />
<asp:parameter Name="TIN" Type="String" />
<asp:parameter Name="Type" Type="String" />
<asp:parameter Name="Model" Type="String" />
<asp:parameter Name="BirthDay" Type="String" />
<asp:parameter Name="BirthMonth" Type="String" />
<asp:parameter Name="BirthYear" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
和这里是我的code为MobileInfo.aspx
and Here's my code for MobileInfo.aspx
<asp:AccessDataSource runat="server" ID="AccessDataSource1" DeleteCommand="DELETE FROM [DriversRecords] WHERE [ID] = ?" InsertCommand="INSERT INTO [DriversRecords] ([Username], [Password], [FirstName], [LastName], [MiddleName], [Address], [Age], [Gender], [ContactNumber], [PlateNumber], [Color], [Brand], [LiscensedNumber], [SSSNumber], [TIN], [Type], [Model], [BirthDay], [BirthMonth], [BirthYear]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" UpdateCommand="UPDATE [DriversRecords] SET [Username] = ?, [Password] = ?, [FirstName] = ?, [LastName] = ?, [MiddleName] = ?, [Address] = ?, [Age] = ?, [Gender] = ?, [ContactNumber] = ?, [PlateNumber] = ?, [Color] = ?, [Brand] = ?, [LiscensedNumber] = ?, [SSSNumber] = ?, [TIN] = ?, [Type] = ?, [Model] = ?, [BirthDay] = ?, [BirthMonth] = ?, [BirthYear] = ? WHERE [ID] = ?" DataFile="_private/records.mdb" SelectCommand="SELECT * FROM [DriversRecords]">
<DeleteParameters>
<asp:parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:parameter Name="Username" Type="String" />
<asp:parameter Name="Password" Type="String" />
<asp:parameter Name="FirstName" Type="String" />
<asp:parameter Name="LastName" Type="String" />
<asp:parameter Name="MiddleName" Type="String" />
<asp:parameter Name="Address" Type="String" />
<asp:parameter Name="Age" Type="String" />
<asp:parameter Name="Gender" Type="String" />
<asp:parameter Name="ContactNumber" Type="String" />
<asp:parameter Name="PlateNumber" Type="String" />
<asp:parameter Name="Color" Type="String" />
<asp:parameter Name="Brand" Type="String" />
<asp:parameter Name="LiscensedNumber" Type="String" />
<asp:parameter Name="SSSNumber" Type="String" />
<asp:parameter Name="TIN" Type="String" />
<asp:parameter Name="Type" Type="String" />
<asp:parameter Name="Model" Type="String" />
<asp:parameter Name="BirthDay" Type="String" />
<asp:parameter Name="BirthMonth" Type="String" />
<asp:parameter Name="BirthYear" Type="String" />
<asp:parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:parameter Name="Username" Type="String" />
<asp:parameter Name="Password" Type="String" />
<asp:parameter Name="FirstName" Type="String" />
<asp:parameter Name="LastName" Type="String" />
<asp:parameter Name="MiddleName" Type="String" />
<asp:parameter Name="Address" Type="String" />
<asp:parameter Name="Age" Type="String" />
<asp:parameter Name="Gender" Type="String" />
<asp:parameter Name="ContactNumber" Type="String" />
<asp:parameter Name="PlateNumber" Type="String" />
<asp:parameter Name="Color" Type="String" />
<asp:parameter Name="Brand" Type="String" />
<asp:parameter Name="LiscensedNumber" Type="String" />
<asp:parameter Name="SSSNumber" Type="String" />
<asp:parameter Name="TIN" Type="String" />
<asp:parameter Name="Type" Type="String" />
<asp:parameter Name="Model" Type="String" />
<asp:parameter Name="BirthDay" Type="String" />
<asp:parameter Name="BirthMonth" Type="String" />
<asp:parameter Name="BirthYear" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
我希望有人能帮助我在这里。谢谢你。
I hope someone can help me here. Thanks.
推荐答案
我在这里看到的是,你有相同的更新命令
上的两个页面,但在第二您所做的更新页面,值都为空或不存在,其结果是,你实际上删除它们。
What I see here is that you have the same UpdateCommand
on the two pages, but on the second page that you make the update, the values are all null or not exist and the result is that you actually deletes them.
走在这条更新命令页面 MobileINfo.aspx
并删除你不实际使用领域 - 只保留一个你真正改变他们 - 或者休息被吹罚到不存在的,有前他们删除数据。
Go on this UpdateCommand of the page MobileINfo.aspx
and remove the field that you do not actually use - keep only the one that you actually change them - or the rest are refereed to data that not exist and there fore they are delete.
更新命令=UPDATE [DriversRecords] SET [用户名] = [密码] = [名字] = [姓氏] = [中间名] = [地址] =?,[年龄] = [两性] =?[ContactNumber] =?[PlateNumber] =?[颜色] =?[品牌] =?[LiscensedNumber] =?[SSSNumber] =? [TIN] = [类型] = [产品型号] =?[生日] =?[BirthMonth] =?[BirthYear] =?WHERE [ID] =?
例如,第二页上的 LiscensedNumber
退出,但性别
不是。你更新后的性别将更新为空或空字符串。
Eg, on the second page the LiscensedNumber
exit, but the Gender
not. After your update the Gender will update to null, or empty string.
这篇关于数据正在更新后失踪的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!