数据未插入sql server

本文介绍了数据未插入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 :)