Nu när jag försöker köra min stored procedure så klagar applikationen på:
"Conversion failed when converting from a character string to uniqueidentifier"
Slänger upp koden för att köra SP'n:
Article tempart = new Article();
tempart.ArticleNumber = ((TextBox)InquiryTableArticles.FindControl("lstDropDown_Textbox")).Text;
tempart.Term = ((TextBox)InquiryTableArticles.FindControl("txtAddInquiryArticleTerm")).Text;
SqlConnection conn = new SqlConnection("Data Source=.\\SQLExpress;Integrated Security=true; AttachDbFilename=|DataDirectory|\\databas.mdf;User Instance=true;");
SqlCommand cmd = new SqlCommand("AddArticles_InqArticles", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@companyID", currentUser.CompanyID));
cmd.Parameters.Add(new SqlParameter("@articlenr", tempart.ArticleNumber));
cmd.Parameters.Add(new SqlParameter("@term", tempart.Term));
cmd.Parameters.Add(new SqlParameter("@description", ""));
cmd.Parameters.Add(new SqlParameter("@inquiryID", Dropdownlistinquiries.SelectedValue));
cmd.Parameters.Add(new SqlParameter("@notice", 1));
cmd.Parameters.Add(new SqlParameter("@revnr", ((TextBox)InquiryTableArticles.FindControl("txtAddInquiryArticleRevnumber")).Text));
cmd.Parameters.Add(new SqlParameter("@pieces", ((TextBox)InquiryTableArticles.FindControl("txtAddInquiryArticlePcs")).Text));
cmd.Parameters.Add(new SqlParameter("@suborder", ((TextBox)InquiryTableArticles.FindControl("txtAddInquiryArticleSuborder")).Text));
cmd.Parameters.Add(new SqlParameter("@articletext", ""));
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
RefreshTable();
Här är SP'n:
ALTER PROCEDURE AddArticles_InqArticles
(
@companyID uniqueidentifier,
@articlenr varchar(50),
@term varchar(50),
@description varchar(MAX),
@inquiryID uniqueidentifier,
@notice int,
@revnr varchar(30),
@pieces varchar(13),
@suborder varchar(13),
@articletext varchar(MAX)
)
AS
BEGIN
set @description = ''
declare @ID uniqueidentifier
SELECT @ID = newid()
declare @inquiryartID uniqueidentifier
SELECT @inquiryartID = newid()
insert into article(ID,companyID,articlenr,term,description)Values(@ID,@companyID,@articlenr,@term,@description)
insert into inquiryarticles(inquiryartID,articleID,inquiryID,revnr,pieces,suborder,notice,articletext)VALUES(@inquiryartID,@ID,@inquiryID,@revnr,@pieces,@suborder,@notice,@articletext)
END
var är den här stringen som inte kan konverteras till Guid/uniqueidentifier?
mvh Sanji
