السلام عليكم ورحمة الله
المثال من VWD2005
اخوتي الكرام ، بصراحة انا تعبت وانا احاول عمل نموذج FormView يقوم بإضافة حقول مختلفه منها حقل للتاريخ وحقلين لإضافة وقت البداية ووقت النهايه ، وبصراحة هوه مش راضي يعمل اضافة ومرة بعطيني الخطء :
You tried to assign the Null value to a variable that is not a Variant data type.
وبصراحة انا مش فاهم قصده فيه
ولما اعمل محاولة اضافة من خلال ال detailsView بعطي رسالة الخطء التالية :
The string was not recognized as a valid DateTime. There is a unknown word starting at index 0.
مع العلم انو اذا ما حذفت الحقول تبعت التاريخ و تبعت الوقت ما بعطيني رسالة خطء
وهي كود الفورم فيو (حذفت البارمتر بخصوص وقت البداية والنهاية وخليت حقل التاريخ عشان انحل المشكلة خطوة خطوة بإذن الله):
<asp:AccessDataSource ID="AccessDataSource1" runat="server" ConflictDetection="CompareAllValues"
DataFile="~/calendar.mdb" DeleteCommand="DELETE FROM [Calendar] WHERE [CalendarNo] = ? AND [UserCode] = ? AND [CalendarDate] = ? AND [CStart] = ? AND [CEnd] = ? AND [CActiveTypeCode] = ? AND [CTitle] = ? AND [CSubject] = ? AND [CPlace] = ? AND [CInvite] = ? AND [CComment] = ?"
InsertCommand="INSERT INTO [Calendar] ([CalendarNo], [UserCode], [CalendarDate], [CActiveTypeCode], [CTitle], [CSubject], [CPlace], [CInvite], [CComment]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Calendar]"
UpdateCommand="UPDATE [Calendar] SET [UserCode] = ?, [CalendarDate] = ?, [CStart] = ?, [CEnd] = ?, [CActiveTypeCode] = ?, [CTitle] = ?, [CSubject] = ?, [CPlace] = ?, [CInvite] = ?, [CComment] = ? WHERE [CalendarNo] = ? AND [UserCode] = ? AND [CalendarDate] = ? AND [CStart] = ? AND [CEnd] = ? AND [CActiveTypeCode] = ? AND [CTitle] = ? AND [CSubject] = ? AND [CPlace] = ? AND [CInvite] = ? AND [CComment] = ?">
<DeleteParameters>
<asp:Parameter Name="original_CalendarNo" Type="Int32" />
<asp:Parameter Name="original_UserCode" Type="String" />
<asp:Parameter Name="original_CalendarDate" Type="DateTime" />
<asp:Parameter Name="original_CStart" Type="DateTime" />
<asp:Parameter Name="original_CEnd" Type="DateTime" />
<asp:Parameter Name="original_CActiveTypeCode" Type="String" />
<asp:Parameter Name="original_CTitle" Type="String" />
<asp:Parameter Name="original_CSubject" Type="String" />
<asp:Parameter Name="original_CPlace" Type="String" />
<asp:Parameter Name="original_CInvite" Type="String" />
<asp:Parameter Name="original_CComment" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="UserCode" Type="String" />
<asp:Parameter Name="CalendarDate" Type="DateTime" />
<asp:Parameter Name="CStart" Type="DateTime" />
<asp:Parameter Name="CEnd" Type="DateTime" />
<asp:Parameter Name="CActiveTypeCode" Type="String" />
<asp:Parameter Name="CTitle" Type="String" />
<asp:Parameter Name="CSubject" Type="String" />
<asp:Parameter Name="CPlace" Type="String" />
<asp:Parameter Name="CInvite" Type="String" />
<asp:Parameter Name="CComment" Type="String" />
<asp:Parameter Name="original_CalendarNo" Type="Int32" />
<asp:Parameter Name="original_UserCode" Type="String" />
<asp:Parameter Name="original_CalendarDate" Type="DateTime" />
<asp:Parameter Name="original_CStart" Type="DateTime" />
<asp:Parameter Name="original_CEnd" Type="DateTime" />
<asp:Parameter Name="original_CActiveTypeCode" Type="String" />
<asp:Parameter Name="original_CTitle" Type="String" />
<asp:Parameter Name="original_CSubject" Type="String" />
<asp:Parameter Name="original_CPlace" Type="String" />
<asp:Parameter Name="original_CInvite" Type="String" />
<asp:Parameter Name="original_CComment" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="CalendarNo" Type="Int32" />
<asp:Parameter Name="UserCode" Type="String" />
<asp:Parameter Name="CalendarDate" Type="DateTime" />
<asp:Parameter Name="CActiveTypeCode" Type="String" />
<asp:Parameter Name="CTitle" Type="String" />
<asp:Parameter Name="CSubject" Type="String" />
<asp:Parameter Name="CPlace" Type="String" />
<asp:Parameter Name="CInvite" Type="String" />
<asp:Parameter Name="CComment" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
<asp:FormView ID="FormView1" runat="server" DataKeyNames="CalendarNo" DataSourceID="AccessDataSource1"
Style="z-index: 24; left: 248px; position: absolute; top: 56px" Width="432px" DefaultMode="Insert">
<EditItemTemplate>
CalendarNo:
<asp:Label ID="CalendarNoLabel1" runat="server" Text='<%# Eval("CalendarNo") %>'>
</asp:Label><br />
UserCode:
<asp:TextBox ID="UserCodeTextBox" runat="server" Text='<%# Bind("UserCode") %>'>
</asp:TextBox><br />
CalendarDate:
<asp:TextBox ID="CalendarDateTextBox" runat="server" Text='<%# Bind("CalendarDate") %>'>
</asp:TextBox><br />
CStart:
<asp:TextBox ID="CStartTextBox" runat="server" Text='<%# Bind("CStart") %>'>
</asp:TextBox><br />
CEnd:
<asp:TextBox ID="CEndTextBox" runat="server" Text='<%# Bind("CEnd") %>'>
</asp:TextBox><br />
CActiveTypeCode:
<asp:TextBox ID="CActiveTypeCodeTextBox" runat="server" Text='<%# Bind("CActiveTypeCode") %>'>
</asp:TextBox><br />
CTitle:
<asp:TextBox ID="CTitleTextBox" runat="server" Text='<%# Bind("CTitle") %>'>
</asp:TextBox><br />
CSubject:
<asp:TextBox ID="CSubjectTextBox" runat="server" Text='<%# Bind("CSubject") %>'>
</asp:TextBox><br />
CPlace:
<asp:TextBox ID="CPlaceTextBox" runat="server" Text='<%# Bind("CPlace") %>'>
</asp:TextBox><br />
CInvite:
<asp:TextBox ID="CInviteTextBox" runat="server" Text='<%# Bind("CInvite") %>'>
</asp:TextBox><br />
CComment:
<asp:TextBox ID="CCommentTextBox" runat="server" Text='<%# Bind("CComment") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
UserCode:
<asp:TextBox ID="UserCodeTextBox" runat="server" Text='<%# Bind("UserCode") %>'>
</asp:TextBox><br />
CalendarDate:
<asp:TextBox ID="CalendarDateTextBox" runat="server" >
</asp:TextBox><br />
CStart:
<asp:TextBox ID="CStartTextBox" runat="server" Text='<%# Bind("CStart") %>'>
</asp:TextBox><br />
CEnd:
<asp:TextBox ID="CEndTextBox" runat="server" Text='<%# Bind("CEnd") %>'>
</asp:TextBox><br />
CActiveTypeCode:
<asp:TextBox ID="CActiveTypeCodeTextBox" runat="server" Text='<%# Bind("CActiveTypeCode") %>'>
</asp:TextBox><br />
CTitle:
<asp:TextBox ID="CTitleTextBox" runat="server" Text='<%# Bind("CTitle") %>'>
</asp:TextBox><br />
CSubject:
<asp:TextBox ID="CSubjectTextBox" runat="server" Text='<%# Bind("CSubject") %>'>
</asp:TextBox><br />
CPlace:
<asp:TextBox ID="CPlaceTextBox" runat="server" Text='<%# Bind("CPlace") %>'>
</asp:TextBox><br />
CInvite:
<asp:TextBox ID="CInviteTextBox" runat="server" Text='<%# Bind("CInvite") %>'>
</asp:TextBox><br />
CComment:
<asp:TextBox ID="CCommentTextBox" runat="server" Text='<%# Bind("CComment") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
CalendarNo:
<asp:Label ID="CalendarNoLabel" runat="server" Text='<%# Eval("CalendarNo") %>'>
</asp:Label><br />
UserCode:
<asp:Label ID="UserCodeLabel" runat="server" Text='<%# Bind("UserCode") %>'></asp:Label><br />
CalendarDate:
<asp:Label ID="CalendarDateLabel" runat="server" Text='<%# Bind("CalendarDate") %>'>
</asp:Label><br />
CStart:
<asp:Label ID="CStartLabel" runat="server" Text='<%# Bind("CStart") %>'></asp:Label><br />
CEnd:
<asp:Label ID="CEndLabel" runat="server" Text='<%# Bind("CEnd") %>'></asp:Label><br />
CActiveTypeCode:
<asp:Label ID="CActiveTypeCodeLabel" runat="server" Text='<%# Bind("CActiveTypeCode") %>'>
</asp:Label><br />
CTitle:
<asp:Label ID="CTitleLabel" runat="server" Text='<%# Bind("CTitle") %>'></asp:Label><br />
CSubject:
<asp:Label ID="CSubjectLabel" runat="server" Text='<%# Bind("CSubject") %>'></asp:Label><br />
CPlace:
<asp:Label ID="CPlaceLabel" runat="server" Text='<%# Bind("CPlace") %>'></asp:Label><br />
CInvite:
<asp:Label ID="CInviteLabel" runat="server" Text='<%# Bind("CInvite") %>'></asp:Label><br />
CComment:
<asp:Label ID="CCommentLabel" runat="server" Text='<%# Bind("CComment") %>'></asp:Label><br />
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
Text="Edit">
</asp:LinkButton>
<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"
Text="Delete">
</asp:LinkButton>
<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
Text="New">
</asp:LinkButton>
</ItemTemplate>
</asp:FormView>وتحت كود ال DetailsView
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="calendar.mdb" SelectCommand="SELECT [CalendarNo], [UserCode], [CalendarDate], [CStart], [CEnd], [CActiveTypeCode], [CTitle], [CPlace], [CSubject], [CInvite] FROM [Calendar] WHERE ([CalendarDate] = ?)" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [Calendar] WHERE [CalendarNo] = ? AND [UserCode] = ? AND [CalendarDate] = ? AND [CStart] = ? AND [CEnd] = ? AND [CActiveTypeCode] = ? AND [CTitle] = ? AND [CPlace] = ? AND [CSubject] = ? AND [CInvite] = ?" InsertCommand="INSERT INTO [Calendar] ([UserCode], [CalendarDate] , [CActiveTypeCode], [CTitle], [CSubject], [CPlace], [CInvite]) VALUES (@UserCode, @CalendarDate, @CActiveTypeCode, @CTitle, @CSubject, @CPlace, @CInvite)" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [Calendar] SET [UserCode] = ?, [CalendarDate] = ?, [CStart] = ?, [CEnd] = ?, [CActiveTypeCode] = ?, [CTitle] = ?, [CPlace] = ?, [CSubject] = ?, [CInvite] = ? WHERE [CalendarNo] = ? AND [UserCode] = ? AND [CalendarDate] = ? ">
<SelectParameters>
<asp:ControlParameter ControlID="Calendar1" Name="CalendarDate" PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="original_CalendarNo" Type="Int32" />
<asp:Parameter Name="original_UserCode" Type="String" />
<asp:Parameter Name="original_CalendarDate" Type="DateTime" />
<asp:Parameter Name="original_CStart" Type="DateTime" />
<asp:Parameter Name="original_CEnd" Type="DateTime" />
<asp:Parameter Name="original_CActiveTypeCode" Type="String" />
<asp:Parameter Name="original_CTitle" Type="String" />
<asp:Parameter Name="original_CPlace" Type="String" />
<asp:Parameter Name="original_CSubject" Type="String" />
<asp:Parameter Name="original_CInvite" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="UserCode" Type="String" />
<asp:Parameter Name="CalendarDate" Type="DateTime" />
<asp:Parameter Name="CStart" Type="DateTime" />
<asp:Parameter Name="CEnd" Type="DateTime" />
<asp:Parameter Name="CActiveTypeCode" Type="String" />
<asp:Parameter Name="CTitle" Type="String" />
<asp:Parameter Name="CPlace" Type="String" />
<asp:Parameter Name="CSubject" Type="String" />
<asp:Parameter Name="CInvite" Type="String" />
<asp:Parameter Name="original_CalendarNo" Type="Int32" />
<asp:Parameter Name="original_UserCode" Type="String" />
<asp:Parameter Name="original_CalendarDate" Type="DateTime" />
<asp:Parameter Name="original_CStart" Type="DateTime" />
<asp:Parameter Name="original_CEnd" Type="DateTime" />
<asp:Parameter Name="original_CActiveTypeCode" Type="String" />
<asp:Parameter Name="original_CTitle" Type="String" />
<asp:Parameter Name="original_CPlace" Type="String" />
<asp:Parameter Name="original_CSubject" Type="String" />
<asp:Parameter Name="original_CInvite" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="CalendarNo" Type="Int32" />
<asp:Parameter Name="UserCode" Type="String" />
<asp:Parameter Name="CalendarDate" Type="DateTime" DefaultValue=Getdate() />
<asp:Parameter Name="CActiveTypeCode" Type="String" />
<asp:Parameter Name="CTitle" Type="String" />
<asp:Parameter Name="CPlace" Type="String" />
<asp:Parameter Name="CSubject" Type="String" />
<asp:Parameter Name="CInvite" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" BackColor="White"
BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="CalendarNo"
DataSourceID="AccessDataSource1" GridLines="Horizontal" Height="50px" Style="z-index: 102;
left: 24px; position: absolute; top: 288px" Width="656px">
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<EditRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<Fields>
<asp:BoundField DataField="CalendarNo" HeaderText="CalendarNo" InsertVisible="False"
ReadOnly="True" SortExpression="CalendarNo" />
<asp:BoundField DataField="UserCode" HeaderText="UserCode" SortExpression="UserCode" />
<asp:BoundField DataField="CalendarDate" DataFormatString=""{0:d}"" HeaderText="CalendarDate"
HtmlEncode="False" SortExpression="CalendarDate" />
<asp:BoundField DataField="CStart" HeaderText="CStart" SortExpression="CStart" DataFormatString="{0:t}" HtmlEncode="False" />
<asp:BoundField DataField="CEnd" HeaderText="CEnd" SortExpression="CEnd" DataFormatString="{0:t}" HtmlEncode="False" />
<asp:BoundField DataField="CTitle" HeaderText="CTitle" SortExpression="CTitle" />
<asp:BoundField DataField="CPlace" HeaderText="CPlace" SortExpression="CPlace" />
<asp:BoundField DataField="CActiveTypeCode" HeaderText="CActiveTypeCode" HtmlEncode="False"
SortExpression="CActiveTypeCode" />
<asp:BoundField DataField="CSubject" HeaderText="CSubject" SortExpression="CSubject" />
<asp:BoundField DataField="CInvite" HeaderText="CInvite" SortExpression="CInvite" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />
</Fields>
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<AlternatingRowStyle BackColor="#F7F7F7" />
</asp:DetailsView>