C＃类型转换错误从SqlDatatype.BIT到C＃中的布尔值

本文介绍了C＃类型转换错误从SqlDatatype.BIT到C＃中的布尔值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 大家好 我得到< g class =" gr_ gr_87 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace"数据-GR-ID =" 87" id =" 87"> a a< / g>此行上的类型转换错误 SqlParameter参数= oCmd.SelectCommand.Parameters.Add（" @ blnSelectStatus"，SqlDbType.Bit）.Value = blnSelectByIDStatus .; 下面给出了代码片段。 请帮忙。 提前致谢。   public bool displayEventGalleryDetailsByGalleryByID（int ipknEventGalleryID）         { $             bool blnSelectByIDStatus = false;            串zpConnectionString = WebConfigurationManager.ConnectionStrings [" MSC-UFCFUD-60-M"] ConnectionString.ToString（）; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; SqlConnection oCon = new SqlConnection（zpConnectionString）;             SqlDataAdapter oCmd = new SqlDataAdapter（）; $             oCmd.SelectCommand = new SqlCommand（" usp_EventGallery_Image_By_Image_Id_Select"，oCon）;             oCmd.SelectCommand.CommandType = CommandType.StoredProcedure;             oCmd.SelectCommand.Parameters.Add（QUOT; @ ipknImageID" ;, SqlDbType.Int）。价值= ipknEventGalleryID; &NBSP;&NBSP ;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; //设置返回值的参数 SqlParameter参数= oCmd.SelectCommand.Parameters.Add（" @ blnSelectStatus"，SqlDbType.Bit）.Value = blnSelectByIDStatus .;             parameter.Direction = ParameterDirection.ReturnValue; $ $   &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;试试            {                 DataSet oDs = new DataSet（）;                 oCmd.Fill（oDs）; $                ;&NBSP; //检索ReturnValue。                 Int32 rowCount =（Int32）oCmd.SelectCommand.Parameters [" @ blnSelectStatus"]。Value; $      ;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;如果（（int）的oCmd.SelectCommand.Parameters [" @ blnSelectStatus"]。值及0） &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; { &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; blnSelectByIDStatus = true;                 }             }             catch（例外情况）             {                抛出新的ApplicationException（"数据错误。"）;             }            最后是            {                 oCmd.Dispose（）;&                oCon.Close（）;             }            返回blnSelectByIDStatus; $         }     }            &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;            &NBSP;&NBSP; 解决方案 Hi AllI am getting <g class="gr_ gr_87 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="87" id="87">an a</g> type conversion error on this lineSqlParameter parameter = oCmd.SelectCommand.Parameters.Add("@blnSelectStatus", SqlDbType.Bit).Value = blnSelectByIDStatus.;The code snippet is given below.Please help.Thanks in advance. public bool displayEventGalleryDetailsByGalleryByID(int ipknEventGalleryID)        {            bool blnSelectByIDStatus = false;            string zpConnectionString = WebConfigurationManager.ConnectionStrings["MSC-UFCFUD-60-M"].ConnectionString.ToString();            SqlConnection oCon = new SqlConnection(zpConnectionString);            SqlDataAdapter oCmd = new SqlDataAdapter();            oCmd.SelectCommand = new SqlCommand("usp_EventGallery_Image_By_Image_Id_Select", oCon);            oCmd.SelectCommand.CommandType = CommandType.StoredProcedure;            oCmd.SelectCommand.Parameters.Add("@ipknImageID", SqlDbType.Int).Value = ipknEventGalleryID;            //Set the parameter for the return valueSqlParameter parameter = oCmd.SelectCommand.Parameters.Add("@blnSelectStatus", SqlDbType.Bit).Value = blnSelectByIDStatus.;            parameter.Direction = ParameterDirection.ReturnValue;            try            {                DataSet oDs = new DataSet();                oCmd.Fill(oDs);                // Retrieve the ReturnValue.                Int32 rowCount = (Int32)oCmd.SelectCommand.Parameters["@blnSelectStatus"].Value;                if ((int)oCmd.SelectCommand.Parameters["@blnSelectStatus"].Value > 0)                {                    blnSelectByIDStatus = true;                }            }            catch (Exception ex)            {                throw new ApplicationException("Data error.");            }            finally            {                oCmd.Dispose();                oCon.Close();            }            return blnSelectByIDStatus;        }    }                                                              解决方案 这篇关于C＃类型转换错误从SqlDatatype.BIT到C＃中的布尔值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！