本文介绍了数据未插入sql server的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
数据没有插入,我找不到问题,请看看
data is not inserting, i could not find the problem, please have a look
filename = System.IO.Path.GetFileName(upldphoto.PostedFile.FileName); filename = GetUniqueFileName(filename); bool a = obj.saveRecord(1,txtName.Text,txtPhone.Text,txtEmail.Text,txtAddress.Text,txtExpertise.Text,txtExp.Text,filename,txtQualification.Text);this是功能代码
this is function code
public bool saveRecord(int action,string name,string phone,string email,string address,string expertise,string experience,string image,string qualification) { Database db = DatabaseFactory.CreateDatabase(); DbCommand cmd = db.GetStoredProcCommand("SaveUpdateDocter"); db.AddInParameter(cmd, "@action", DbType.Int32, action); db.AddInParameter(cmd,"@Name",DbType.String,name); db.AddInParameter(cmd,"@Email",DbType.String,email); db.AddInParameter(cmd,"@Address",DbType.String,address); db.AddInParameter(cmd,"@Mobile",DbType.String,phone); db.AddInParameter(cmd,"@Qualification",DbType.String,qualification); db.AddInParameter(cmd,"@Expertise",DbType.String,expertise); db.AddInParameter(cmd,"@Experience",DbType.String,experience); db.AddInParameter(cmd,"@ImgName",DbType.String,image); using (TransactionScope scope = new TransactionScope()) { try { int a = cmd.ExecuteNonQuery(); scope.Complete(); if (a > 0) { return true; } else { return false; } } catch (Exception e) { return false; } finally { cmd.Dispose(); } } }推荐答案
实际上我正在检查的错误是a = cmd.ExecuteNonQuery();而不是int a = db.ExecuteNonQuery(cmd); 感谢您的所有关注:) actually error that i was checking int a = cmd.ExecuteNonQuery(); instead of int a=db.ExecuteNonQuery(cmd); thanks for all your concern :)
更多推荐
数据未插入sql server
发布评论