C# (CSharp) DAL SQLHelper.GetSigleObject示例

示例#1

        public string GetClassNameById(string classId)
        {
            StringBuilder sqlBuilder = new StringBuilder();

            sqlBuilder.Append("select ClassName from [dbo].[StudentClass] where ClassId={0}");
            string sql = string.Format(sqlBuilder.ToString(), classId);

            try
            {
                return((string)SQLHelper.GetSigleObject(sql));
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw;
            }
        }