- strSQL = "insert into CONTACT_GROUP(NAME,USER_NAME,ACCESS_PERMISSION,DESCRIPTION)values(@NAME,@USER_NAME,@ACCESS_PERMISSION,@DESCRIPTION) select id = scope_identity()";
- SqlParameter[] parameters = new SqlParameter[4];
- parameters[0] = new SqlParameter("@NAME", TextBox_Name.Text.Trim());
- parameters[1] = new SqlParameter("@USER_NAME", UserName);
- parameters[2] = new SqlParameter("@ACCESS_PERMISSION", DropDownList_AccessPermission.Text);
- parameters[3] = new SqlParameter("@DESCRIPTION", TextBox_Description.Text.Trim());
- //新建一个Group,并返回其id(注意:不是int类型的,而是decimal类型)
- decimal id = (decimal)SqlHelper.ExecuteScalar(tran, CommandType.Text, strSQL, parameters);
scope_identity() 函数获取插入记录的自动编号ID,需要注意的是它是 decimal类型的,不是int类型的。