提前致谢.
protected voID Page_Load(object sender,EventArgs e) { string connString_librarySystem = "Server=DEVSERVER;User ID=sa;Password=Sup3r-Us3r;Database=librarySystem"; string strsql = "INSERT INTO TblBooks (bookID,bookTitle,lastname,firstname,description,categoryID,dateadded,statusID,quantity,isdeleted) VALUES (@bookID,@bookTitle,@lastname,@firstname,@description,@categoryID,@dateadded,@statusID,@quantity,@isdeleted)"; sqlConnection conn = new sqlConnection(connString_librarySystem); conn.open(); sqlCommand cmd = new sqlCommand(); cmd = new sqlCommand(strsql,conn); cmd.Parameters.AdDWithValue("@bookID",Request.Form["bookID"]); cmd.Parameters.AdDWithValue("@bookTitle",Request.Form["bookTitle"]); cmd.Parameters.AdDWithValue("@lastname",Request.Form["lastname"]); cmd.Parameters.AdDWithValue("@firstname",Request.Form["firstname"]); cmd.Parameters.AdDWithValue("@description",Request.Form["description"]); cmd.Parameters.AdDWithValue("@categoryID",Request.Form["categoryID"]); cmd.Parameters.AdDWithValue("@dateadded",Request.Form["dateadded"]); cmd.Parameters.AdDWithValue("@statusID",Request.Form["statusID"]); cmd.Parameters.AdDWithValue("@quantity",Request.Form["quantity"]); cmd.Parameters.AdDWithValue("@isdeleted",Request.Form["isdeleted"]); cmd.ExecuteNonquery(); { conn.Close(); } statuslabel.Text = "Insert successful"; }
编辑:刚刚删除了数据类型.
解决方法 您不必在insert语句中包含数据类型.跳过它们.尝试
string strsql = "INSERT INTO TblBooks (bookID,@isdeleted)";总结
以上是内存溢出为你收集整理的c# – 尝试/ Catch方法错误ASP.NET全部内容,希望文章能够帮你解决c# – 尝试/ Catch方法错误ASP.NET所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)