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 高德地图点聚合中Marker的位置无法实时更新
  • ¥15 DIFY API Endpoint 问题。
  • ¥20 sub地址DHCP问题
  • ¥15 delta降尺度计算的一些细节,有偿
  • ¥15 Arduino红外遥控代码有问题
  • ¥15 数值计算离散正交多项式
  • ¥30 数值计算均差系数编程
  • ¥15 redis-full-check比较 两个集群的数据出错
  • ¥15 Matlab编程问题
  • ¥15 训练的多模态特征融合模型准确度很低怎么办