数据未插入sql server [英] data is not inserting in 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！