static string sqlServer= "server=.;database=QQDB;user id=sa;pwd=sa;";
#region 返回单个值
public static void refDanz()
{
//实例化通道
SqlConnection conn = new SqlConnection(sqlServer);
//定义SQL语句
string sqlStr = "select max(qq) from users";
//准备执行命令
SqlCommand sqlcmd = new SqlCommand(sqlStr, conn);
//打开通道
conn.Open();
//执行命令,并返回单值,返回类型是object
object objstr = sqlcmd.ExecuteScalar();
//关闭通道
conn.Close();
//返回结果
Console.WriteLine(objstr.ToString());
}
#endregion