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 如何提取csv文件中需要的列,将其整合为一篇完整文档,并进行jieba分词(语言-python)
  • ¥15 MapReduce结果输出到HBase,一直连接不上MySQL
  • ¥15 扩散模型sd.webui使用时报错“Nonetype”
  • ¥15 stm32流水灯+呼吸灯+外部中断按键
  • ¥15 将二维数组,按照假设的规定,如0/1/0 == "4",把对应列位置写成一个字符并打印输出该字符
  • ¥15 NX MCD仿真与博途通讯不了啥情况
  • ¥15 win11家庭中文版安装docker遇到Hyper-V启用失败解决办法整理
  • ¥15 gradio的web端页面格式不对的问题
  • ¥15 求大家看看Nonce如何配置
  • ¥15 Matlab怎么求解含参的二重积分?