licheng30001 2015-08-07 03:17 采纳率: 0%
浏览 2191

C# 代码明明有获取到数据,为什么还会出现错误“未将对象引用设置到实例”

public TheCustomCheckDetailObj GetTheCustomCheckDetail(int TheCustomCheck)
{
using (SqlConnection con = new SqlConnection(_connectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("OGetTheCustomCheckDetail", con);
cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@TheCustomCheck", SqlDbType.Int);
            cmd.Parameters["@TheCustomCheck"].Value = TheCustomCheck;

            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                obj.CurrentCustomDetailObj.CompanyName = Convert.ToString(reader["CompanyName"]);
                obj.CurrentCustomDetailObj.CompanyPart = Convert.ToString(reader["CompanyPart"]);
                obj.CurrentCustomDetailObj.CompanyWebsite = Convert.ToString(reader["CompanyWebsite"]);
                obj.CurrentCustomDetailObj.CustomName = Convert.ToString(reader["CustomName"]);
                obj.CurrentCustomDetailObj.CustomCellphone = Convert.ToString(reader["CustomCellphone"]);
                obj.CurrentCustomDetailObj.CustomPhone = Convert.ToString(reader["CustomPhone"]);
                obj.CurrentCustomDetailObj.CustomFenji = Convert.ToString(reader["CustomFenji"]);
                obj.CurrentCustomDetailObj.QQorMSN = Convert.ToString(reader["QQorMSN"]);
                obj.CurrentCustomDetailObj.Email = Convert.ToString(reader["Email"]);
                obj.CurrentCustomDetailObj.BusinessID = Convert.ToInt32(reader["BusinessID"]);
                obj.CurrentCustomDetailObj.ProvinceID = Convert.ToInt32(reader["ProvinceID"]);
                obj.CurrentCustomDetailObj.CountryID = Convert.ToInt32(reader["CountryID"]);
                obj.CurrentCustomDetailObj.CityID = Convert.ToInt32(reader["CityID"]);
                obj.CurrentCustomDetailObj.Address = Convert.ToString(reader["Address"]);
                obj.CurrentCustomDetailObj.PS = Convert.ToString(reader["PS"]);


                obj.InCheckCustomDetailObj.CompanyName = Convert.ToString(reader["OldCompanyName"]);
                obj.InCheckCustomDetailObj.CompanyPart = Convert.ToString(reader["OldCompanyPart"]);
                obj.InCheckCustomDetailObj.CompanyWebsite = Convert.ToString(reader["OldCompanyWebsite"]);
                obj.InCheckCustomDetailObj.CustomName = Convert.ToString(reader["OldCustomName"]);
                obj.InCheckCustomDetailObj.CustomCellphone = Convert.ToString(reader["OldCustomCellphone"]);
                obj.InCheckCustomDetailObj.CustomPhone = Convert.ToString(reader["OldCustomPhone"]);
                obj.InCheckCustomDetailObj.CustomFenji = Convert.ToString(reader["OldCustomFenji"]);
                obj.InCheckCustomDetailObj.QQorMSN = Convert.ToString(reader["OldQQorMSN"]);
                obj.InCheckCustomDetailObj.Email = Convert.ToString(reader["OldEmail"]);
                obj.InCheckCustomDetailObj.BusinessID = Convert.ToInt32(reader["OldBusinessID"]);
                obj.InCheckCustomDetailObj.ProvinceID = Convert.ToInt32(reader["OldProvinceID"]);
                obj.InCheckCustomDetailObj.CountryID = Convert.ToInt32(reader["OldCountryID"]);
                obj.InCheckCustomDetailObj.CityID = Convert.ToInt32(reader["OldCityID"]);
                obj.InCheckCustomDetailObj.Address = Convert.ToString(reader["OldAddress"]);
                obj.InCheckCustomDetailObj.PS = Convert.ToString(reader["OldPS"]);


            }


            reader.Close();
            con.Close();

            return obj;

        }
    }
  • 写回答

2条回答

  • threenewbee 2015-08-07 05:18
    关注

    具体是哪一行?看看是不是哪个字段你搞错了,实际不存在。

    评论

报告相同问题?

悬赏问题

  • ¥15 关于#python#的问题:求帮写python代码
  • ¥20 MATLAB画图图形出现上下震荡的线条
  • ¥15 LiBeAs的带隙等于0.997eV,计算阴离子的N和P
  • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘
  • ¥15 来真人,不要ai!matlab有关常微分方程的问题求解决,
  • ¥15 perl MISA分析p3_in脚本出错
  • ¥15 k8s部署jupyterlab,jupyterlab保存不了文件
  • ¥15 ubuntu虚拟机打包apk错误
  • ¥199 rust编程架构设计的方案 有偿
  • ¥15 回答4f系统的像差计算