السلام عليكم ورحمة الله وبركاتة
عندى قاعدة بيانات مكتبة وبعرضها على الويب المفروض انى بسمح بادخال اسماء مؤلفين جدد وبيناتهم ولكن عند عمل insert يظهر لي فى المستعرض بعد ادخال البيانات والضغط على زر insert
String or binary data would be truncated.
The statement has been terminated.
هذا هو الكود اللى استخدمتة
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:mybookstoreConnectionString1 %>"
DeleteCommand="DELETE FROM [authors] WHERE [au_id] = @au_id"
InsertCommand="INSERT INTO [authors] ([au_lname], [au_fname], [phone], [address], [city], [state], [zip]) VALUES (@au_lname, @au_fname, @phone, @address, @city, @state, @zip)"
ProviderName="<%$ ConnectionStrings:mybookstoreConnectionString1.ProviderName %>"
SelectCommand="SELECT [au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip] FROM [authors]"
UpdateCommand="UPDATE [authors] SET [au_lname] = @au_lname, [au_fname] = @au_fname, [phone] = @phone, [address] = @address, [city] = @city, [state] = @state, [zip] = @zip WHERE [au_id] = @au_id">
<DeleteParameters>
<asp:Parameter Name="au_id" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="au_lname" Type="String" />
<asp:Parameter Name="au_fname" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="city" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="zip" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="au_lname" Type="String" />
<asp:Parameter Name="au_fname" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="city" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="zip" Type="String" />
<asp:Parameter Name="au_id" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</p>