vb.net里绝对值方法是什么?如何把一个BOOLEAN类型插入到ＳＱＬ２０００的ＢＩＴ字段

[HooKim166]

vb.net里绝对值方法是什么?如何把一个BOOLEAN类型插入到ＳＱＬ２０００的ＢＩＴ字段

[zhangjidong]

public void addObject(string strObjectName,string strObjectDesc,bool boolAddable,bool boolDelable,
bool boolUpdateable,bool boolBrowsable,bool boolRestoreable,bool boolPrintable)
{
// CREATE PROCEDURE [rminsertOBJECT]
// (@OBJECT_NAME_1 [nvarchar](10),
// @OBJECT_DESC_2 [nvarchar](50),
// @ADDABLE_3 [bit],
// @DELETABLE_4 [bit],
// @MODIFIABLE_5 [bit],
// @BROWSABLE_6 [bit],
// @RESTOREABLE_7 [bit],
// @PRINTABLE_8 [bit])
if (mySqlConnection == null)
throw new Exception("无法连接数据库！");
try
{
SqlParameter [] arParms = new SqlParameter[8];
arParms[0] = new SqlParameter("@OBJECT_NAME_1", SqlDbType.NVarChar,10 );
arParms[0].Value = strObjectName;
arParms[1] = new SqlParameter("@OBJECT_DESC_2", SqlDbType.NVarChar,50);
arParms[1].Value=strObjectDesc;
arParms[2] = new SqlParameter("@ADDABLE_3", SqlDbType.Bit);
arParms[2].Value = boolAddable;
arParms[3] = new SqlParameter("@DELETABLE_4", SqlDbType.Bit);
arParms[3].Value = boolDelable;
arParms[4] = new SqlParameter("@MODIFIABLE_5", SqlDbType.Bit);
arParms[4].Value = boolUpdateable;
arParms[5] = new SqlParameter("@BROWSABLE_6", SqlDbType.Bit);
arParms[5].Value = boolBrowsable;
arParms[6] = new SqlParameter("@RESTOREABLE_7", SqlDbType.Bit);
arParms[6].Value = boolRestoreable;
arParms[7] = new SqlParameter("@PRINTABLE_8", SqlDbType.Bit);
arParms[7].Value = boolPrintable;
SqlHelper.ExecuteNonQuery(mySqlConnection, CommandType.StoredProcedure, "rminsertOBJECT", arParms);
}
catch(Exception ex)
{
string errMessage = "数据访问，添加对象：";
for( Exception tempException = ex; tempException != null ; tempException = tempException.InnerException )
{
errMessage += tempException.Message + Environment.NewLine + Environment.NewLine;
}
throw new Exception(errMessage);
}
finally
{
mySqlConnection.Close();
}
}

[lhcoolhacker]

使用byte类型代替bool即可

[webdiyer]

如果你用参数化SQL语句或存储过程，直接把这个bool变量传递给SQL语句中bit型字段的变量就行了，它会自动转换，象这样：

myCommand.Parameters.Add("@BitField",myBoolValue);

[Overriding]

System.Math.Abs()是吗？

[cnhgj]

"insert into t values (" & cint(false) & ")"