when i try to create a new record then a run time error appears. the image is uploaded on the the site but after......have no database knowledge!!!!

this is the code...

Cannot insert the value NULL into column 'PictureID', table 'D:\FINAL YEAR\PROJECT\WEBSITE\APP_DATA\OSFPDB.MDF.dbo.Galle ry'; column does not allow nulls. INSERT fails.
The statement has been terminated.

<asp:Label ID="FileUploadReport" runat="server"></asp:Label>
<asp:FileUpload ID="FileUpload1" runat="server" />
<br />
<br />
<asp:ListBox ID="ListBox1" runat="server" DataSourceID="SqlDataSourceFixtures"
DataTextField="FixtureDate" DataValueField="FixtureID"></asp:ListBox>
<asp:SqlDataSource ID="SqlDataSourceFixtures" runat="server"
ConnectionString="<%$ ConnectionStrings:WroxUnited %>"
SelectCommand="SELECT [FixtureID], [FixtureDate] FROM [Fixtures] ORDER BY [FixtureDate]">
</asp:SqlDataSource>
<br />
<br />
<asp:Label ID="Label2" runat="server" Text="Fan's Name"></asp:Label>
<asp:TextBox ID="TextBoxMemberName" runat="server"></asp:TextBox><br />
<br />
<br />
<asp:Label ID="Label1" runat="server" Text="Comments"></asp:Label>
<asp:TextBox ID="TextBoxNotes" runat="server"></asp:TextBox><br />
<br />
<asp:SqlDataSource ID="SqlDataSourceCreateGalleryRecord" runat="server"
ConnectionString="<%$ ConnectionStrings:WroxUnited %>"
OldValuesParameterFormatString="original_{0}"
InsertCommand="INSERT INTO [Gallery] ([FixtureID], [UploadedByMemberName], [Notes], [PictureURL]) VALUES (@FixtureID, @UploadedByMemberName, @Notes, @PictureURL)">
<InsertParameters>
<asp:ControlParameter Name="FixtureID" Type="Int64" ControlID="ListBox1" PropertyName="SelectedValue"/>
<asp:ControlParameter Name="UploadedByMemberName" Type="String" ControlID="TextBoxMemberName" PropertyName="Text" />
<asp:ControlParameter Name="Notes" Type="String" ControlID="TextBoxNotes" PropertyName="Text" />
<asp:ControlParameter Name="PictureURL" Type="String" ControlID="FileUpload1" PropertyName="FileName"/>
</InsertParameters>
</asp:SqlDataSource>
<br />
<asp:Button ID="Button1" runat="server" Text="Upload"
onclick="Button1_Click" />

Hi there,

Difficult to say without seeing your database and without having the book. I checked the download code, but can't find the page that contains his code.

Anyway, as the error suggests, you're not supplying a value for a required column. Maybe PictureID is the primary key but has not been set as an identity?

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!