第一个写数据库的代码

    public static void AddAlbum(string Caption, bool IsPublic)
    {
       SqlConnection connetion =new SqlConnection(ConfigurationManager.ConnectionStrings["PERSONAL"].ConnectionString );
       string sql = "insert into [Albums]([Caption],[IsPublic]) values(@Caption,@IsPublic)";
       SqlCommand command = new SqlCommand(sql,connetion);
       command.Parameters.Add(new SqlParameter("@Caption",Caption));
       command.Parameters.Add(new SqlParameter("@IsPublic",IsPublic));
       connetion.Open();
       command.ExecuteNonQuery();
    }