komeil64
پنج شنبه 09 دی 1389, 14:10 عصر
سلام
سایتی که درست کردم در لوکال درست کار می کنه
اما بعد از آپلود جایی که sp قصد اینزرت داره این ارور رو میده!
Cannot insert the value NULL into column 'ID', table 'books.dbo.tbl_books'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The 'sp_tbl_books_Insert' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead
!!!!
چی کارش کنم؟
اینم کد sp:
USE [books]
GO
/****** Object: StoredProcedure [dbo].[sp_tbl_books_Insert] Script Date: 12/31/2010 13:48:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ================================================== ========================================
-- Entity Name: sp_tbl_books_Insert
-- Author: Mehdi Keramati
-- Create date: 12/22/2010 06:01:42 ب.ظ
-- Description: This stored procedure is intended for inserting values to tbl_books table
-- ================================================== ========================================
ALTER Procedure [dbo].[sp_tbl_books_Insert]
@book_name nvarchar(MAX),
@part1_book nvarchar(MAX),
@part_book nvarchar(MAX),
@price_book nvarchar(MAX),
@thumb_book nvarchar(MAX)
As
Begin
Insert Into tbl_books
([book_name],[part1_book],[part_book],[price_book],[thumb_book])
Values
(@book_name,@part1_book,@part_book,@price_book,@th umb_book)
Declare @ReferenceID int
Select @ReferenceID = @@IDENTITY
Return @ReferenceID
End
اینم کد اینزرت
ImageUpload();
SqlConnection scon_book=new SqlConnection(ConfigurationManager.ConnectionStrin gs["books"].ToString());
scon_book.Open();
SqlCommand scom_book=new SqlCommand("sp_tbl_books_Insert",scon_book);
scom_book.CommandType=CommandType.StoredProcedure;
scom_book.Parameters.AddWithValue("@book_name",txt_book_name.Text);
scom_book.Parameters.AddWithValue("@part1_book",txt_book_part1.Text);
scom_book.Parameters.AddWithValue("@part_book",txt_book_part2.Text);
scom_book.Parameters.AddWithValue("@price_book",txt_price_book.Text);
scom_book.Parameters.AddWithValue("@thumb_book",Finalimagename);
scom_book.ExecuteNonQuery();
scon_book.Close();
txt_book_name.Text = "";
txt_book_part1.Text = "";
txt_book_part2.Text = "";
txt_price_book.Text = "";
سایتی که درست کردم در لوکال درست کار می کنه
اما بعد از آپلود جایی که sp قصد اینزرت داره این ارور رو میده!
Cannot insert the value NULL into column 'ID', table 'books.dbo.tbl_books'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The 'sp_tbl_books_Insert' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead
!!!!
چی کارش کنم؟
اینم کد sp:
USE [books]
GO
/****** Object: StoredProcedure [dbo].[sp_tbl_books_Insert] Script Date: 12/31/2010 13:48:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ================================================== ========================================
-- Entity Name: sp_tbl_books_Insert
-- Author: Mehdi Keramati
-- Create date: 12/22/2010 06:01:42 ب.ظ
-- Description: This stored procedure is intended for inserting values to tbl_books table
-- ================================================== ========================================
ALTER Procedure [dbo].[sp_tbl_books_Insert]
@book_name nvarchar(MAX),
@part1_book nvarchar(MAX),
@part_book nvarchar(MAX),
@price_book nvarchar(MAX),
@thumb_book nvarchar(MAX)
As
Begin
Insert Into tbl_books
([book_name],[part1_book],[part_book],[price_book],[thumb_book])
Values
(@book_name,@part1_book,@part_book,@price_book,@th umb_book)
Declare @ReferenceID int
Select @ReferenceID = @@IDENTITY
Return @ReferenceID
End
اینم کد اینزرت
ImageUpload();
SqlConnection scon_book=new SqlConnection(ConfigurationManager.ConnectionStrin gs["books"].ToString());
scon_book.Open();
SqlCommand scom_book=new SqlCommand("sp_tbl_books_Insert",scon_book);
scom_book.CommandType=CommandType.StoredProcedure;
scom_book.Parameters.AddWithValue("@book_name",txt_book_name.Text);
scom_book.Parameters.AddWithValue("@part1_book",txt_book_part1.Text);
scom_book.Parameters.AddWithValue("@part_book",txt_book_part2.Text);
scom_book.Parameters.AddWithValue("@price_book",txt_price_book.Text);
scom_book.Parameters.AddWithValue("@thumb_book",Finalimagename);
scom_book.ExecuteNonQuery();
scon_book.Close();
txt_book_name.Text = "";
txt_book_part1.Text = "";
txt_book_part2.Text = "";
txt_price_book.Text = "";